The Download Database Totals feature creates only one column per dimension, and includes all members, and the corresponding data, in the Results set. In addition, a column with each dimension’s parent members is also included in the results. By default this option is disabled. Once this option is enabled, any existing Results set is deleted. If this option is enabled through Tools, then Options, then Program Options, then OLAP, the option is enabled also in a newly created CubeQuery section.
Note: | If you use the Download to Results feature, only separate columns in the Results set are created 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:
All Product members, in the query, are listed in only one column and not separated into multiple columns based on Generation. In addition the data values for the upper level Product members are also included in the results.
Each dimension has an additional column that displays parent members for each member in the query.
The Year dimension members Qtr1, Qtr2, etc. have their parent member (Year) displayed in the “Year Parent” column.
The Scenario dimension members Actual and Budget have their parent member (Scenario) displayed in the “Scenario Parent” column.
The Product dimension members have their respective parent members displayed in the “Product Parent” column.
To download the query to results, select The behavior of the Download to Results feature varies for different components in CubeQuery: