OLAP Sales cube dimensions
Cube Structure
OLAP Sales cube contains the following dimesions. All the dimensions are by default listed above the OLAP panel except Items and Period, which are added on the panel (as seen below).
Some of the dimensions are structured, which is marked with > in front of the measure. This means that one dimensions contain multiple dependent dimensions (e.g. dimension Period includes Year, Quartal, Month, Day). This dimension can be used as a whole, or you can remove individual dimension on the right click from the structure (see example below, where Quartal was removed from the structure).
ZEUS Sales cube structure depends on the category template you've selected in the ZEUS settings. If the Secondary Categories are Independent of Primary Categories option has been selected, two cubes will be used. With the other options, only one cube will be used. Cubes differ only in the structure of the Items dimension.
For the needs of ZEUS Sales, a cube (or cubes, see above paragraph) with the following dimensions has been designed:
| Name of dimensions |
Which data it includes |
Structured |
| Period |
Period(year, quartal, month, day) of solf items |
Yes |
| Items |
List of items with primary and secondary category (if selected) that were sold in selected period. |
Yes |
| Customers |
List of customers (subjects) to which items were sold. Structured as Country, Region, City, Customer |
Yes |
| Result/Plan |
|
|
| Departments |
Departments of sold items |
No |
Instructions for Use:
Related Topics: