Featured Database Articles

Designing & Creating the Local Cube with the PivotTable Report

We now
have a PivotTable report, with its connection to the Warehouse and
Sales server cube, in place, from which we can create our local cube.
The rest of the process is easy, although planning is critical to ascertain the
needs of the information consumers for whose remote use we are designing and
creating the local cube.

A
comparison to the items on the PivotTable Toolbar will reveal that the Create
Cube File Step 2 of 4 dialog contains all the dimensions that are
available for selection in the cube residing on the server. The checked boxes
indicate the dimensions that appear in the PivotTable report itself.

Note: This avenue of selection, within
the Create Cube File - Step 2 of 4 dialog, means we can do all selection
here, avoiding the need to create an elaborate PivotTable report that includes
all the dimensions and measures we want to incorporate into our local cube.
This is an opportunity to save time, and the reason that we put a minimal
amount of design into the PivotTable report earlier. (There is a
minimal requirement for data to enable the Offline OLAP Settings
option on the dropdown menu, however.)