on 05-04-2017 5:18 PM
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
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.