Joining KF data with the same key from several BW DSOs in CPI-DS

[former_member531519]

Dear IBP Community,

I'm looking for ideas on interfacing key figure data from BW to IBP through CPI-DS.

The data at the source is stored in several regional DSOs and it contains key figure data with the same key (location/product/time bucket). The problem with loading that data through CPI-DS is that the insert-update mode overwrites one region data with another one in subsequent loads for the combinations that exist in more than one regional object.

Ideal scenario would be to create a virtual data provider in BW that can aggregate it at the source and read in CPI. However since multiproviders are not supported in CPI, that option doesn't work.

Creating a new DSO that would combine the data in BW isn't also a good solution as it involves data duplication and reloading, which is questionable from architecture standards pov.

Second option would be to use joins in CPI mapping, however union joins are not supported and are not designed to work fast with big data subsets.

Third idea is to load the data into separate KFs in IBP and add them up through calculations which seems the only one acceptable and moderately clean and could work with larger data sets.

Maybe anyone faced a similar problem and found a better solution.

Thanks

[p_cosmin]

Did you write "BW" in the "Context" field of the Datastore? For me it was type Business Suite App.

I don't have access to that system anymore because I changed companies but you can find some guidance at this link.

https://blogs.sap.com/2015/11/26/faq-sap-bw-operational-data-provisioning-framework-odp/

"InfoCube TEST123 for example would represent itself as TEST123$F in the ODP datasource tree in the target BW."

I'm sure there must be more info on forums, keywords are ODP, Cube, BW context, BODS or HCI, CPI.

Fore reading characteristics instead of cube I remember it was $P and for texts $T. Try with a cube and $F first.

Hope it helps,

Cosmin

[p_cosmin]

"Ideal scenario would be to create a virtual data provider in BW that can aggregate it at the source and read in CPI. However since multiproviders are not supported in CPI, that option doesn't work."

-> I have used Multiprovider as source for regional Cubes with CPI-DS using BW in the datastore context and it works. If I remember right, the name of the multiprovider has to be imported with $F at the end of the technical name.

Best regards,

Cosmin

[former_member531519]

Hi Cosmin - This would be great news, I've never seen such option in any of the documentation guides.

I've tried this option now with $F and it unfortunately doesn't work. Is there a chance you can recheck this on how you made this work?

Regards,

Bartek

[manikandan_shanmugam3]

As you say, BW has several DSOs, best way is to create an open hub table and add up data there. otherwise you will end up creating number of stored keyfigure as many as DSOs.

Don't think about option 2, as CPI DS doesn't perform well with multiple joins.

if you choose 2nd option, Join table like below.

Regards,

Mani