Abstract: The present disclosure pertains to systems and methods for providing search results. A database server can include both a database and a search engine. The database server can receive, from a software service server, storage metadata indicating a plurality of tables of the database and fields of each of the plurality of tables. The database can generate a metadata search index, including tables and fields populated based on the storage metadata, and store it on the database. The database server may receive a search request including one or more search terms from a query-building application of a remote computer. The search engine can determine search statements based on the search request and execute the search statements on a view of the stored metadata search index to obtain index search results. Metadata search results based on the index search results can be provided to the query-building application.

Abstract: Methods, systems, and computer-readable storage media for receiving, by a query manager service (QMS) executed within a first data center, a query definition provided from a browser of an analytics platform executed within a second data center, providing, by the QMS, a calculation scenario as an object model based on the query definition, executing, by a calculation engine within the first data center, the calculation scenario to provide an analytical artifact including a query-level calculation view on transactional data stored in the first data center, and transmitting, by the first data center, the analytical artifact to the second data center to perform analytics on at least a portion of the transactional data stored in the first data center.

Abstract: The present disclosure pertains to systems and methods for providing search results. A database server can include both a database and a search engine. The database server can receive, from a software service server, storage metadata indicating a plurality of tables of the database and fields of each of the plurality of tables. The database can generate a metadata search index, including tables and fields populated based on the storage metadata, and store it on the database. The database server may receive a search request including one or more search terms from a query-building application of a remote computer. The search engine can determine search statements based on the search request and execute the search statements on a view of the stored metadata search index to obtain index search results. Metadata search results based on the index search results can be provided to the query-building application.

Abstract: Methods, systems, and computer-readable storage media for receiving, by a query manager service (QMS) executed within a first data center, a query definition provided from a browser of an analytics platform executed within a second data center, providing, by the QMS, a calculation scenario as an object model based on the query definition, executing, by a calculation engine within the first data center, the calculation scenario to provide an analytical artifact including a query-level calculation view on transactional data stored in the first data center, and transmitting, by the first data center, the analytical artifact to the second data center to perform analytics on at least a portion of the transactional data stored in the first data center.

Abstract: Described herein are methods and systems for analyzing multidimensional data that use tangential exploration of data via a third or Z-dimension to the current two-dimensional view. The tangential exploration allows higher dimensionality to be explored without causing visual clutter.

Abstract: Described herein are methods and systems for analyzing multidimensional data that use tangential exploration of data via a third or Z-dimension to the current two-dimensional view. The tangential exploration allows higher dimensionality to be explored without causing visual clutter.

Abstract: A computer readable medium stores executable instructions to receive a Multidimensional Expressions (MDX) query. The MDX query is recursively rationalized to form a rationalized query. The rationalized query is applied to a multidimensional data source to produce query results. The query results are returned.

Abstract: A computer readable medium stores executable instructions to receive a Multidimensional Expressions (MDX) query. The MDX query is recursively rationalized to form a rationalized query. The rationalized query is applied to a multidimensional data source to produce query results. The query results are returned.