Hi,
I have added zplant as a navigation attribute to 0mat_plant.
0Mat_plant is compounded by 0plant and source system also zplant is a reference characteristic to 0plant. This is needed to model Plant material source plant relation. I.e., Plant AAA sources material X from Plant BBB.
This setup will allow the master to change for the material plant level without affecting the data in the cube.
In the cube I have 0mat_plant as a characteristic. In the update rule I am mapping 0material to 0mat_plant. Also in the cube I have 0Plant and source system.
If my understanding, I should be able to use zplant as a navigation attribute in the query. However, zplant is always blank
I am not sure if there is an issue with having 0mat_plant compounded by 0Plant and source system.
How can I model this such that I do not need to store the source plant ZPLANT in the cube ? any feedback would be greatly appreciated ..
Thanks
Fahed