...
Using an excel template the data can be copied into a created Data Entry Report. In this report you can click the 'save' button to bring the data into the fact database. To bring the data from the fact towards the OLAP cube the data needs to be processed. After the processing phase the data is visible within the reports. In the design studio reports for the created hierarchies can be build. See the maintenance hierarchies article for more information.
To load data be aware to load on base members. Loading data on parent members is possible, however absolutely not wise to do. Therefore, always load on the Lowest Level. When the data is in the OLAP cube for the reports it is not required to use the lowest level. This can be done on any member in the hierarchy structure. The hierarchy structure can be created by a user or admin.
Configuration
For the Data Warehouse Adapter it is required to setup the Dimension Mapping. The Dimension Mapping maps the Standard CXO-Cockpit Dimensions to the OLAP Dimensions of the Source System.
Next to the Dimension Mapping setting the Period Frequency is an mandatory step during the initial roll-out of the Data Warehouse Adapter. You need to define the Period dimension members to be used and map them to the parent members of the Period hierarchy.
The /wiki/spaces/DEV/pages/23527429 need to be set for the created Data Warehouse Adapter. Dimension variables are used as a substitute for a Dimension Member.
Other Articles
- Link Data Entry Template
- Link naar Data Entry report
- Link naar Hierarchy Maintenance
...