CONTROLLED CREATION OF REPORTS FROM TABLE VIEWS

• US 20130332862A1
• Filed: 10/08/2012
• Published: 12/12/2013
• Est. Priority Date: 06/06/2012
• Status: Active Grant

• Current Assignee: Addepar Incorporated
• Original Assignee: Addepar Incorporated
• Inventors: MIRRA, JASON, PAULUS, MICHAEL, CHAN, WAI LOON, MARTELL, RICHARD THOMAS III
• Granted Patent: US 9,015,073 B2
• Time in Patent Office: Days
• US Class Current: 715/760
• CPC Class Codes: G06F 11/323 Visualisation of programs or trace data
• CPC Class Codes: G06F 18/29 Graphical models, e.g. Bayesian networks
• CPC Class Codes: G06F 3/048 Interaction techniques based on graphical user interfaces [GUI]
• CPC Class Codes: G06F 3/0481 based on specific properties of the displayed interaction object or a metaphor-based environment, e.g. interaction with desktop elements like windows or icons, or assisted by a cursor's changing behaviour or appearance
• CPC Class Codes: G06F 3/04842 Selection of displayed objects or displayed text elements G06F3/0482 takes precedence
• CPC Class Codes: G06F 40/106 Display of layout of documents; Previewing
• CPC Class Codes: G06Q 40/00 Finance; Insurance; Tax strategies; Processing of corporate or income taxes
• CPC Class Codes: G06Q 40/06 Asset management; Financial planning or analysis
• CPC Class Codes: G06Q 40/08 Insurance
• CPC Class Codes: G06T 15/005 General purpose rendering architectures

Abstract

A method comprising creating and storing, in memory of a computer, a graph having nodes and edges, wherein the nodes represent financial assets and any one or more of: accounts in which one or more of the assets are held; individuals who own one or more of the assets; or legal entities who own one or more of the assets; receiving and storing one or more bucketing factors and one or more column factors; the computer traversing the graph and creating a list of a plurality of paths of nodes and edges in the graph; the computer applying the bucketing factors to the paths to result in associating each set among a plurality of sets of the nodes with a different value node among a plurality of value nodes; the computer applying the column factors to the paths and the value nodes to result in associating column result values with the value nodes; creating and causing displaying a table view by forming rows based on the value nodes and forming columns based on the column result values.

Claims

1. A method comprising:

importing asset data from a memory of a computer, representing financial assets for any of accounts in which one or more of the assets are held, individuals who own one or more of the assets, or legal entities who own one or more of the assets;

retrieving report metadata comprising one or more of contexts, bucketing factors and column factors;

selecting display data from the asset data based on the report metadata, wherein the selecting the display data preserves the asset data unchanged in the memory of the computer;

wherein the selecting the display data from the asset data further comprises;

creating and storing, in the memory of the computer, a graph having nodes and edges, wherein the nodes represent the financial assets and any one or more of;

the accounts in which one or more of the assets are held;

the individuals who own one or more of the assets;

or legal entities who own one or more of the assets;

the computer traversing the graph and creating a list of a plurality of paths of nodes and edges in the graph;

the computer applying the bucketing factors to the paths to result in associating each set among a plurality of sets of the nodes with a different value node among a plurality of value nodes;

selecting the display data of the value nodes from the asset data;

displaying the selected data on a graphical user interface;

wherein the method is performed by one or more computing devices.

2. The method of claim 1 wherein the selecting the display data from the asset data further comprises:

the computer applying the bucketing factors to the paths to result in associating each set among a plurality of sets of the nodes with a different value node among a plurality of value nodes;

the computer applying the column factors to the paths and the value nodes to result in associating column result values with the value nodes;

selecting the display data of the column result values from the asset data.

3. The method of claim 1 further comprising displaying the selected data in at least one page of a plurality of pages in a report, and wherein the report comprises the pages and the report metadata.

4. The method of claim 1 further comprising:

receiving a request to generate a report;

in response to receiving the request, displaying a report selection dialog that enumerates a plurality of reports, wherein each report in the plurality of reports has a plurality of pages associated with the report;

receiving a selection of the report from the report selection dialog;

receiving a selection of a particular page of the plurality of pages associated with the report;

in response to receiving the selection, displaying the selected data in the page.

5. The method of claim 3 further comprising:

displaying the selected data in a plurality of widgets in the page, wherein the selected data in a particular widget in the plurality of widgets is displayed in a widget format described by widget formatting attributes of the particular widget, wherein the widget formatting attributes are controlled by a plurality of widget controls;

displaying the plurality of widget controls for the particular widget;

receiving a modification to a widget control of the plurality of widget controls;

in response to receiving the modification, modifying the widget formatting attributes of the particular widget, wherein the modifying of the widget formatting attributes of the particular widget preserves the asset data associated with the selected data unchanged in the memory of the computer;

causing re-displaying the selected data in the particular widget in a different format described by the modified widget formatting attributes of the particular widget.

6. The method of claim 5 wherein the particular widget is a text widget, and wherein the displaying the selected data further comprises displaying textual representations of a plurality of symbolic links, wherein each symbolic link identifies an entry in the asset data of the display data for a particular context.

7. The method of claim 6 wherein the entry in the asset data of the display data corresponds to a column factor for the particular context.

8. The method of claim 7 further comprising:

receiving a selection of a particular symbolic link in the text widget;

in response to receiving the selection of the particular symbolic link, displaying in the graphical user interface a column factor selection dialog box, wherein the column factor selection dialog box enumerates a plurality of column factors for the particular context;

receiving a column factor from the plurality of column factors; and

in response to receiving the column factor, causing re-displaying the textual representations for the particular symbolic link pointing to a different entry in the asset data of the selected data corresponding to the column factor for the particular context in the text widget.

9. The method of claim 5 wherein the particular widget is a table widget and wherein the displaying the selected data further comprises displaying a table view by forming rows based on the bucketing factors and forming columns based on the column factors for a particular context.

10. The method of claim 9 further comprising:

receiving a selection of a graphical element for column properties in the table view;

in response to receiving the selection, displaying in the graphical user interface a column formatting dialog box;

displaying a column widget control for a column in the column formatting dialog box, wherein the column widget control is a widget control from the plurality of widget controls for the table widget;

receiving a modification to the column widget control;

in response to receiving the modification, modifying the widget formatting attributes for the table widget, wherein the modifying of the widget formatting attributes preserves the asset data of the selected data unchanged in the memory of the computer;

causing re-displaying the selected data in the table view in the table widget in a different format described by the modified widget formatting attributes.

11. The method of claim 5 further comprising:

receiving a label for the page containing the plurality of widgets;

associating formatting attributes of the plurality of widgets and of the page with the label;

storing in the memory of the computer the formatting attributes associated with the label.

12. The method of claim 5 further comprising:

displaying the selected data in the page in a format described by page formatting attributes, wherein the page formatting attributes are controlled by a plurality of page controls;

displaying the plurality of page controls for the page;

receiving a modification to a page control from the plurality of page controls;

in response to receiving the modification, modifying the page formatting attributes, wherein the modifying of the page formatting attributes preserves the asset data of the selected data unchanged in the memory of the computer;

causing re-displaying the selected data in the page based on the modified page formatting attributes.

13. The method of claim 5 further comprising:

receiving a request to split the page based on a split factor of a bucketing factor or a column factor, wherein a plurality of values are associated with the split factor;

selecting display data sets from the asset data based on the report metadata and the factor, wherein each display data in the display data set has a different value from the plurality of values associated with the split factor;

for each of the display data, creating a new page;

applying formatting attributes to the new page.

14. The method of claim 13 wherein the receiving a request to split the page further comprises:

receiving the request to split the page;

in response to receiving the request, displaying a factor selection dialog;

wherein the factor selection dialog enumerates a plurality of split factors of the bucketing factors or of the column factors;

receiving a selection of the split factor from the plurality of split factors.

15. The method of claim 5 further comprising:

displaying the selected data in the page in a format described by report formatting attributes, wherein the report formatting attributes are controlled by a plurality of report controls;

displaying the plurality of report controls for the plurality of pages;

receiving a modification to a report control from the plurality of report controls;

in response to receiving the modification, modifying the report formatting attributes for the plurality of pages, wherein the modifying of the report formatting attributes preserves the asset data of the selected data unchanged in the memory of the computer;

causing re-displaying the selected data in the page in a different format described in the modified report formatting attributes.

21. The method of claim 1, further comprising:

retrieving formatting attributes that comprise one or more of report formatting attributes, page formatting attributes, and widget formatting attributes;

applying one or more formats from the formatting attributes to the display data, wherein the applying preserves the asset data unchanged in the memory of the computer and results in formatted data;

displaying the formatted data on a graphical user interface.

16. A non-transitory data storage medium storing one or more sequences of instructions which when executed cause performing:

importing asset data from a memory of a computer, representing financial assets for any of accounts in which one or more of the assets are held, individuals who own one or more of the assets, or legal entities who own one or more of the assets;

retrieving report metadata comprising one or more of contexts, bucketing factors and column factors;

selecting display data from the asset data based on the report metadata, wherein the selecting the display data preserves the asset data unchanged in the memory of the computer;

wherein the selecting the display data from the asset data further comprises;

creating and storing, in the memory of the computer, a graph having nodes and edges, wherein the nodes represent the financial assets and any one or more of;

the accounts in which one or more of the assets are held;

the individuals who own one or more of the assets;

or legal entities who own one or more of the assets;

the computer traversing the graph and creating a list of a plurality of paths of nodes and edges in the graph;

the computer applying the bucketing factors to the paths to result in associating each set among a plurality of sets of the nodes with a different value node among a plurality of value nodes;

selecting the display data of the value nodes from the asset data;

displaying the selected data on a graphical user interface.

17. The non-transitory storage medium of claim 16 wherein the instructions which cause selecting the display data from the asset data further comprise one or more sequences of instructions which when executed cause:

the computer applying the bucketing factors to the paths to result in associating each set among a plurality of sets of the nodes with a different value node among a plurality of value nodes;

the computer applying the column factors to the paths and the value nodes to result in associating column result values with the value nodes;

selecting the display data of the column result values from the asset data.

18. The non-transitory storage medium of claim 16 wherein the instructions which cause selecting the display data from the asset data further comprise one or more sequences of instructions which when executed cause displaying the selected data in at least one page of a plurality of pages in a report, and wherein the report comprises the pages and the report metadata.

19. The non-transitory storage medium of claim 16 wherein the instructions which cause selecting the display data from the asset data further comprise one or more sequences of instructions which when executed cause:

receiving a request to generate a report;

in response to receiving the request, displaying a report selection dialog that enumerates a plurality of reports, wherein each report in the plurality of reports has a plurality of pages associated with the report;

receiving a selection of the report from the report selection dialog;

receiving a selection of a particular page of the plurality of pages associated with the report;

in response to receiving the selection, displaying the selected data in the page.

20. The non-transitory storage medium of claim 19 wherein the instructions which cause selecting the display data from the asset data further comprise one or more sequences of instructions which when executed cause:

displaying the selected data in a plurality of widgets in the page, wherein the selected data in a particular widget in the plurality of widgets is displayed in a widget format described by widget formatting attributes of the particular widget, wherein the widget formatting attributes are controlled by a plurality of widget controls;

displaying the plurality of widget controls for the particular widget;

receiving a modification to a widget control of the plurality of widget controls;

in response to receiving the modification, modifying the widget formatting attributes of the particular widget, wherein the modifying of the widget formatting attributes preserves the asset data associated with the selected data unchanged in the memory of the computer;

causing re-displaying the selected data in the particular widget in a different format described by the modified widget formatting attributes.

22. The non-transitory storage medium of claim 16 wherein the instructions which cause selecting the display data from the asset data further comprise one or more sequences of instructions which when executed cause:

retrieving formatting attributes that comprise one or more of report formatting attributes, page formatting attributes, and widget formatting attributes;

applying one or more formats from the formatting attributes to the display data, wherein the applying preserves the asset data unchanged in the memory of the computer and results in formatted data;

displaying the formatted on a graphical user interface.