Abstract: An administration tool can be used to provide data flexibility in a business intelligence (BI) server that is associated with a data warehouse. The administration tool can display one or more data objects that are adapted to be imported from an application framework into a physical model maintained on the BI server. The administration tool can further map the one or more data objects in the physical model into a logical model, also maintained on the BI server, which corresponds to at least one target table in the data warehouse. Additionally, the administration tool can publish an extension input to an extender associated with the data warehouse based on the logical model, wherein the extender operates to generate one or more metadata extensions based on the extension input.

Abstract: Techniques are disclosed for querying, retrieval, and presentation of data. A data analytic system can enable a user to provide input, through a device to query data. The data analytic system can identify the semantic meaning of the input and perform a query based on the semantic meaning. The data analytic system can crawl multiple different sources to determine a logical mapping of data for the index. The index may include one or more subject areas, terms defining those subject areas, and attributes for those terms. The index may enable the data analytic system to perform techniques for matching terms in the query to determine a semantic meaning of the query. The data analytic system can determine a visual representation best suited for displaying results of a query determined by semantic analysis of an input string by a user.

Abstract: Predictive analysis techniques are described herein as applied to business variables. In some embodiments, a dynamic dependency model may be generated using a time-series data from a first time period. The model may define relationships between business variables during the first time period. A prediction of values of a variable (e.g., a business variable such as sales, revenue, attrition, or the like) can be generated based on the dynamic dependency model. The prediction of values may be for a second time period after the first time period. The actual values of the variable over the second time period can be obtained and compared to the predicted values to generate a statistical deviation. The statistical deviation may exceed a threshold and, a notification of the statistical deviation may be transmitted to a user device. The notification may alert the user that the variable is likely to miss the targeted/predicted value.

Abstract: Gaps in proficiencies may be identified within an enterprise. Understanding gaps in the existing workforce may help inform training, hiring, and firing decisions to ensure successful completion of the upcoming projects and deadlines. Using a multi-level model for each proficiency that accounts for enterprise needs as well as hiring, retraining, and the like, a relationship between proficiencies, projects, and employees over time may be generated as a multi-dimensional temporal model. The temporal model may be simulated to forecast gaps in proficiencies of the employed workforce. Recommendations regarding retraining, hiring, and termination can be made to help users remedy the deficiencies. Additionally, the proficiencies most valuable to the enterprise may be determined using a catalog of proficiencies to cluster the proficiencies into proficiency clusters for each job or job category and the proficiencies scored.

Abstract: Techniques are disclosed for querying, retrieval, and presentation of data. A data analytic system can enable a user to provide input, through a device to query data. The data analytic system can identify the semantic meaning of the input and perform a query based on the semantic meaning. The data analytic system can crawl multiple different sources to determine a logical mapping of data for the index. The index may include one or more subject areas, terms defining those subject areas, and attributes for those terms. The index may enable the data analytic system to perform techniques for matching terms in the query to determine a semantic meaning of the query. The data analytic system can determine a visual representation best suited for displaying results of a query determined by semantic analysis of an input string by a user.

Abstract: An input extension specification can be generated, via an administration tool on a business intelligence (BI) server, for an extender associated with a data warehouse in order to extend the data warehouse. The administration tool can request for data flow information of the data warehouse from the extender. The data flow information indicates the mapping relationship between one or more source data objects and one or more target tables in the data warehouse. The administration tool further allows a user to select said one or more target tables in the data warehouse to be extended based on the data flow information, and builds the input extension specification for the extender.

Abstract: A computer-implemented method of executing a user query includes presenting a user interface to allow a user to enter a query, receiving a user-entered textual request through the interface, launching a search service to rewrite the textual request into a search query, sending the search query to a presentation server, receiving an answer to the query, and returning the answer to the user as a graphical representation. A computer-implemented method includes receiving a crawl request from a user, launching a crawl manager to monitor the crawl request and track statistics related to the crawl, starting a crawl task based upon the crawl request, indexing a business intelligence presentation server to create a data index, and storing the data index.

Abstract: A computer-implemented method includes providing a fixed portion of a data model, uploading external files to an extended portion of the data model, matching at least some parts of the external files to the fixed portions of the data model, and using data from both the fixed and extended portions of the data model together. A computer-implemented method includes receiving a query from a user to a data model that includes a stored subject area portion and a stored extended subject area portion, accessing at least one storage to retrieve the subject area portion and the extended subject area portion, joining relevant portions of the subject area and extended subject area, extracting answers to the query from the joined portions, and reporting the answers to the user.

Abstract: An extender associated with a data warehouse can support metadata extension for the data warehouse. The extender can create an ETL extension plan for extending the data warehouse. The ETL extension plan includes one or more ETL plan elements that indicate extensions on ETL metadata objects. The one or more ETL plan elements within the ETL extension plan can be ordered, and ETL metadata extension can be performed based on the ETL extension plan.

Abstract: A scorecard application can support business strategy management using a business intelligence (BI) server. The BI server can take inputs from different data sources. The scorecard application can define an internal data structure that holds a plurality of strategy components and one or more key performance indicators (KPIs). Then, the scorecard application can populate each said strategy component in the internal data structure based on the inputs from the different data sources, and perform one or more actions once an alert is triggered, wherein the alert is triggered when a said KPI meets one or more criteria.

Abstract: A business intelligence (BI) server maintains a plurality of metadata objects to support the extract, transform and load (ETL) processes. These metadata objects includes a transparent view object, which takes a joined set of source tables and represents a data shape of the joined set of source tables using a transformation, and a ETL mapping association object that maps the transformation contained in the transparent view object to a target table. The BI server can then orchestrate the movement of data from source systems into the target data warehouses in a source and target system agnostic way.

Abstract: An extender associated with a data warehouse can support metadata extension for the data warehouse. The extender can create an ETL extension plan for extending the data warehouse. The ETL extension plan includes one or more ETL plan elements that indicate extensions on ETL metadata objects. The one or more ETL plan elements within the ETL extension plan can be ordered, and ETL metadata extension can be performed based on the ETL extension plan.

Abstract: An input extension specification can be generated, via an administration tool on a business intelligence (BI) server, for an extender associated with a data warehouse in order to extend the data warehouse. The administration tool can request for data flow information of the data warehouse from the extender. The data flow information indicates the mapping relationship between one or more source data objects and one or more target tables in the data warehouse. The administration tool further allows a user to select said one or more target tables in the data warehouse to be extended based on the data flow information, and builds the input extension specification for the extender.

Abstract: An administration tool can be used to provide data flexibility in a business intelligence (BI) server that is associated with a data warehouse. The administration tool can display one or more data objects that are adapted to be imported from an application framework into a physical model maintained on the BI server. The administration tool can further map the one or more data objects in the physical model into a logical model, also maintained on the BI server, which corresponds to at least one target table in the data warehouse. Additionally, the administration tool can publish an extension input to an extender associated with the data warehouse based on the logical model, wherein the extender operates to generate one or more metadata extensions based on the extension input.