When you download the standard project from Cube Store all cube dimensions have, by default, been created as company independent. This means that the same Customer No. is assumed to be the same customer across all companies in the NAV database. In some cases this is not the case and we will have to set up the dimension to be company dependent.
Company dependent setup
Edit the key level of the dimension to include company
Modify the Name Column if necessary to show only name. If you need to see key and name in the front end you should create a field on the stage table that concatenates the key and name. Then drag the new name column onto the dimension table in the DWH. You can now select this column as your name column.
Modify the dimension relation in all cubes that are using the dimension:
- Deploy and execute the project or the necessary objects.