Hi Alll ,
We have 1 requirement where we need to pull the data from Virtual Cube along with that we need to create few fields which will be dependent on 1 field lets say X .New fields will be A and B .
We donot have to make the changes in the existing flow .So the process which we are following is creating 1 master data which will be loaded from X along with will derive A and B field in the new master data . Now we will be having both A and B derived . For pulling the Key figures KF1 , KF2 from Virtual cube we tried with Composite Provider having X/Y field common between Virtual Cube and Master Data but we cannot use Virtual Cube in CP .I have referred the below thread .
We cannot go with Multiprovider approach as well as it will be based on union and will generate 2 records .With Multiprovider data will look like this :
X KF1 KF2
Y A B
If we will put filter on A field report will always show blank key figures .
At the end my data should look like this :
X/Y A B KF1 KF2