Hi Guys
I have a situation where I have a simple flat dimension (Company as is happens)
However of a list of 20+ companies only one is not showing in the dimension list. The value is shown in the Company table in the Data Warehouse but is not carrying into the cube
The company code is ABC-FG with the fist three letters being constant
the one missing ends as IT if it relevant
Has any one encountered this before and has a fix/work-round
Thanks
Malcolm
Hello Malcolm,
this can have multiple reasons. How do you know that it is not in the cubes? Do you use Excel, pivot tables or NL? If NL: What is the Code you are using? Can you check via the "Browse Dimension" function from within the Data Manager?
Is it possible that the table in the data warehouse is guarded? Or the Dimension in the Cubes section?
Can you check, if the permissions on the Dimension are set correctly?
How do you deploy and execute your data warehouse? In the execution tab you can modify the tables that shall be deployed and executed and also exclude tables.
Can you deselect one other company in the data source and deploy and execute everything and see if this has any influence on the tables in the data warehouse or for the dimensions?
Let me know, if this helps.
Best Regards,
Johannes
Hi Guys
I have just worked it out - no data in the company
Thanks
Malcolm
Instead of the last step, you can use a data selection rule on the table in the data warehouse and only select a few companies for testing purposes. This might be easier and less error-prone.
