Multi dimensional modelling
I just wanted to check on the following.
Lets say you have a multi provider which consists of 5 Key figures, 10 characteristics and is provided by 4 cubes.
If one of the key figure is available in all 4 cubes and is assigned from all 4 cubes. What do you see in a report in the case that you have a record which has different values for the same key figure? Thanks
Venkat Ambati replied
In the multiprovider, in the identification tab you will check the Plant Io and in the selection tab you will check the KF1.
Now in the report, for the plant ABCD, if you want to see the KF1 from cube1, you will restrict 0INFOPROV with cube1 and if you want to see KF1 of cube2, you will restrict 0INFOPRV with cube2.
0INFOPROV is used to differantaite the same values from different infoproviders.
So when you have plant ABCD in rows and have two columns;
First column you have KF1, the IO 0INFOPROV restricted with cube1, it will give the result 10.
Second column you have KF1, 0INFOPROV restricted with cube2, it will give the result 20.
The result will be as below"
PLANT ABCD - 10 - 20.
Like this you can restrict teh same key figure with different infoproviders to fetch values from respective infoproviders.