cancel
Showing results for 
Search instead for 
Did you mean: 

Join in a Virtual Cube

Former Member
0 Kudos

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 .

https://answers.sap.com/questions/150851/composite-provider-based-on-cube-unable-to-add-in.html

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

Regards ,

Suraj Grewal

Accepted Solutions (0)

Answers (0)