Download to Results is an instrument for rendering a flat table representation of the multi-dimensional Essbase data cubes in Interactive Reporting. The data is loaded into a Result section of Interactive Reporting document, and can be used for further analysis, report creation and joining with data from other relational data sources. In this case the data processing (e.g. aggregation, totaling, custom calculations, table joins) is performed on the Interactive Reporting side.
By default Download to Results creates separate columns in the results set for every generation in every dimension. In addition, only the lowest level member values are imported, with any ancestors for each member (included in the original query) appearing in additional columns. In the following example, separate columns appear for the two Product member Generations from the query. Only the lowest level Product members data are in the query. Data for the upper level Product members is not included:
The Results set can be integrated with the Chart, Table, and reporting sections.
Results are only updated when you select the Download to Results feature, or when you take the downloaded results set and process the results again.
If you expect the query to retrieve a small to medium sized data set, it is recommended that you enable the automatic download feature from the Query, then Tools, then Options, then Program Options, then OLAP, and then Auto Generate Results When Processing OLAP Query. If you choose this option, the Results set is not created for the current CubeQuery section, but only for new CubeQuery sections. In some circumstances when querying large amounts of data, the automatic creation of a Results section may result in a slight reduction in query performance.
Note: | Shared members can be excluded from the query by way of Query Options, however there are some cases where customers might want to include Shared Members in the query and results set, but not in the totals. If you want to include shared members in the results set, the parent context needs to exist in the query. In other words, if a shared member’s parent does not exist in the query, Download to Results does not recognize that it is a shared member. |
Note: | If you open an Interactive Reporting version 11.1.1 document that contains data in Results downloaded from a CubeQuery with version 9.3.1, the existing Results data is not visible. Furthermore, using the “download to results” feature with an Interactive Reporting document created with Interactive Reporting version 11.1.1, the result set is not be the same as it was with version 9.3.1. |
To download the query to results, select The behavior of Download to Results varies for different components in CubeQuery: