In the Database field, type in the
database name in which the cube to be used is stored.
In the Cube field, type in the cube name
in which the dimensions of interests are stored. In this scenario, it is one
of the demo cubes Sales.
In the Cube type field, select the
Normal type from the drop-down list for
the cube to be created, meaning this cube will be normal and default.
Next to the Edit schema field, click the
three-dot button to open the schema editor.
In the schema editor, click the plus button to add the rows of the schema
to be edited. In this example, add rows corresponding to all of the
dimensions stored in the Sales cube:
Products, Regions, Months, Years, Datatypes,
Measures. Type in them in the order given in this
cube.
Click OK to validate this editing and
accept the propagation of this change to the next component. Then these
columns are added automatically into the Column column of the Cube
query table in the Component
view. If the order is not consistent with the one in the
Sales cube, adapt it using the up and down arrows
under the schema table.
In the Dimensions column of the Cube query table, type in each of the dimension
names stored in the Sales cube regarding to each row in
the Column column. In the
Sales cube, the dimension names are:
Products, Regions, Months, Years, Datatypes,
Measures.
In the Elements columns of the Cube query table, type in the dimension elements
you want to retrieve regarding to the dimensions they belong to. In this
example, the elements to be retrieved are All Products,
Germany and Austria (Belonging
to the same dimension Regions, these two
elements are entered in the same row and separated with a comma.),
Jan, 2009,
Actual, Turnover.
Did this page help you?
If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!
