Dynamic identification of supported items in an application

• US 9,836,708 B2
• Filed: 12/13/2013
• Issued: 12/05/2017
• Est. Priority Date: 12/13/2013
• Status: Active Grant

• Current Assignee: Visier Solutions Inc. (Visier, Inc.)
• Original Assignee: Visier Solutions Inc. (Visier, Inc.)
• Inventors: Zenger, Geoffrey, Sit, Chuen Yan, Hanna, Ryan Wayne
• Primary Examiner(s): ZIMMERMAN, JEFFREY P
• Application Number:
  US14/106,335
• Publication Number:
  US 20150170065A1
• Time in Patent Office: 1,453 Days
• Field of Search: 705 711
• CPC Class Codes: G06F 16/2465 Query processing support for facilitating data mining operations in structured databases
• CPC Class Codes: G06Q 10/063 Operations research, analysis or management
• CPC Class Codes: G06Q 10/10 Office automation; Time management

Abstract

Systems and methods of dynamically identifying supported items in an application are described. In one example, an analytics engine receives an indication of available client data, a user'"'"'s enterprise role, and/or a user'"'"'s security level. The analytics engine identifies a first subset of supported semantic items (e.g., business topics, business topics, measures, etc.) and a second subset of unsupported semantic items. For example, a semantic item may be supported if corresponding client data is available for analysis and the user'"'"'s role/security level enable access to the client data. The analytics engine may send data including the supported semantic items and excluding the unsupported semantic items to an application.

Claims

1. A computer-implemented method of generating graphical user analysis interfaces, the method comprising:

at an analytics engine configured to analyze a set of items based on data models and processing models;

receiving, at a first time, a first indication that first client data is available for use by the analytics engine, wherein a first portion of the first client data is stored on a first data storage device, wherein a second portion of the first client data is stored on a second data storage device that is distinct from the first data storage device, and wherein the analytics engine is configured to analyze the first client data using the set of items;

populating columns of a plurality of fact tables with the first client data;

populating and storing a table-info table to indicate which columns in each of the plurality of fact tables are populated with the first client data;

evaluating a plurality of content measures based on the populated columns of the plurality of fact tables, the table-info table, and at least one of a role or a security access level of a user to determine and store a set of computable content measures that are supported by the first client data;

identifying supported items of the set of items based on the stored set of computable content measures;

sending first graphical user interface (GUI) data to a client instance, wherein display of the first GUI data shows the supported items and excludes unsupported items;

receiving, at a second time, a second indication that a portion of the first client data has become unavailable;

determining that at least one of the supported items relies on the portion of the first client data;

sending second GUI data to the client instance, wherein display of the second GUI data excludes the at least one of the supported items;

receiving, from the client instance, a query that requests values spanning both the first portion and the second portion; and

responsive to receiving the query, dividing the query into a plurality of data requests, the plurality of data requests including a first request with respect to the first portion and a second request with respect to the second portion.

2. The method of claim 1, wherein the set of items includes at least one business term, at least one business concept, at least one business question, at least one business model, at least one business measure, or any combination thereof.

3. The method of claim 1, wherein the client instance corresponds to a particular enterprise client.

4. The method of claim 1, wherein execution of the client instance is initiated by the user.

5. The method of claim 1, wherein display of the first GUI data excludes one or more items based on an association of the user with a particular enterprise client.

6. The method of claim 1, wherein the user is associated with a first enterprise client, and further comprising:

receiving a third indication that second client data associated with a second enterprise client is available for use by the analytics engine;

evaluating the plurality of content measures based on the second client data and at least one of a role or a security access level of a second user to determine a second set of computable content measures that are supported by the second client data, wherein the second user is associated with the second enterprise client;

identifying second supported items of the set of items and second unsupported items of the set of items based on the second set of computable content measures; and

sending third GUI data to a second client instance, wherein display of the third GUI data shows the second supported items and excludes the second unsupported items.

7. The method of claim 1, wherein a first portion of the first client data is stored on a first data storage device, wherein a second portion of the first client data is stored on a second data storage device that is distinct from the first data storage device, and further comprising, responsive to a receiving query that spans both the first portion and the second portion, dividing the query into a plurality of data requests, the plurality of data requests including a first request with respect to the first portion and a second request with respect to the second portion.

8. The method of claim 1, wherein the stored set of computable content measures is reusable to identify the supported items while the first client data remains available and while the at least one of the role or the security access level of the user is unchanged.

9. The method of claim 1, further comprising:

receiving a third indication that second client data is available for use by the analytics engine;

populating, at a third time, the table-info table to indicate which of the columns in the plurality of fact tables are populated with the second client data;

evaluating, at the third time, the plurality of content measures based on the second client data and table-info table;

determining that at least one previously unsupported item is supported by the second client data; and

sending third GUI data to the client instance, wherein display of the third GUI data shows the at least one previously unsupported item that is supported by the second client data.

10. The method of claim 9, wherein the third time is subsequent to at least one of the first time or the second time.

11. A non-transitory computer-readable storage device storing instructions that, when executed by a computer, cause the computer to perform operations comprising:

detecting startup of one or more applications in an analytics engine configured to analyze a set of items based on data models and processing models to dynamically generate graphical user analysis interfaces;

populating columns of a plurality of fact tables with first client data, wherein a first portion of the first client data is stored on a first data storage device, and wherein a second portion of the first client data is stored on a second data storage device that is distinct from the first data storage device;

populating and storing a table-info table to indicate which columns in each of the plurality of fact tables are populated with the first client data;

evaluating a plurality of content measures based on the populated columns of the plurality of fact tables, the table-info table, and at least one of a role or a security access level of a user to determine and store a set of computable content measures that are supported by the first client data;

identifying supported items of the set of items based on the stored set of computable content measures;

sending data identifying the supported items to the one or more applications, wherein the data excludes unsupported items;

receiving an indication that a portion of the first client data has become unavailable;

determining that at least one of the supported items relies on the portion of the first client data;

sending second data to the one or more applications, wherein display of the second data excludes the at least one of the supported items;

receiving, from the one or more applications, a query that requests values spanning both the first portion and the second portion, and

responsive to receiving the query, dividing the query into a plurality of data requests, the plurality of data requests including a first request with respect to the first portion and a second request with respect to the second portion.

12. The non-transitory computer-readable storage device of claim 11, wherein the operations further comprise sending data identifying the set of computable content measures to the one or more applications.

13. The non-transitory computer-readable storage device of claim 11, wherein the stored set of computable content measures is reusable to identify the supported items while the first client data remains available and while the at least one of the role or the security access level of the user is unchanged.

14. An apparatus comprising:

a processor configured to analyze a set of items based on data models and processing models to dynamically generate graphical user analysis interfaces; and

a memory storing instructions that, when executed by the processor, cause the processor to perform operations comprising;

receiving, at a first time, first information identifying first client data available for use by the processor to support analysis of the first client data based on the set of items, wherein a first portion of the first client data is stored on a first data storage device, and wherein a second portion of the first client data is stored on a second data storage device that is distinct from the first data storage device;

populating columns of a plurality of fact tables with the first client data;

populating and storing a table-info table to indicate which columns in each of the plurality of fact tables are populated with the first client data;

evaluating a plurality of content measures based on the populated columns of the plurality of fact tables, the table-info table, and at least one of a role or a security access level of a user to determine and store a set of computable content measures that are supported by the first client data;

identifying supported items of the set of items based on the stored set of computable content measures;

sending first graphical user interface (GUI) data to a client instance, wherein display of the first GUI data shows the supported items and excludes unsupported items;

receiving, at a second time, second information that a portion of the first client data has become unavailable;

determining that at least one of the supported items relies on the portion of the first client data;

sending second GUI data to the client instance, wherein display of the second GUI data excludes the at least one of the supported items;

receiving, from the client instance, a query that requests values spanning both the first portion and the second portion; and

responsive to receiving the query, dividing the query into a plurality of data requests, the plurality of data requests including a first request with respect to the first portion and a second request with respect to the second portion.

15. The apparatus of claim 14, wherein the operations further comprising identifying different supported items for client data associated with different enterprise clients.

16. The apparatus of claim 14, wherein the operations further comprise identifying different supported items for different users associated with the same enterprise client.

17. The apparatus of claim 14, wherein a item in the set of items is associated with at least one term, at least one question, at least one model, at least one business measure, or any combination thereof.

18. The apparatus of claim 14, wherein the stored set of computable content measures is reusable to identify the supported items while the first client data remains available and while the at least one of the role or the security access level of the user is unchanged.