Migrate your Composite Providers (after upgrade BW7.3 –> BW7.4)
Dear readers,
I’m one of the lucky consultants who can ‘play’ with SAP BW7.4 on HANA at a client. Last week they upgraded our SAP BW 7.3 system to a new release –> SAP BW7.4 SP11. Before the upgrade we developed several Composite Providers via the traditional SAP GUI. A Composite Provider is an InfoProvider in which you can combine data from BW InfoProviders such as InfoObjects, DataStore Objects, SPOs and InfoCubes, or SAP HANA views such as Analytical or Calculation Views using join or union operations to make the data available for reporting.
After an upgrade we recognize two different kind of Composite Providers: the “Local Composite Provider” (coming from SAP BW7.3) and the new SAP HANA Composite Provider.
After the upgrade you’ve the possibility to migrate your Local Composite Provider to the new SAP HANA Composite Provider. With the program (SE38/SA38) “RSO_CONVERT_IPRO_TO_HCPR” you can convert your InfoProviders including the SAP BEx queries you’ve previously built. On OSS we found a SAP Note that gives you more insight in the program.
If you want to create a new SAP HANA Composite Provider, please read the following document from the SAP SDN: First Guidance SAP BW 7.40 on HANA – CompositeProvider.
Good luck with migrating your Composite Providers!!!
Hi Pieter,
What is the meaning of the square icon next to the image of the local composite provider in RSA1?
Thanks!
Hau
Hi Hau,
This icon means that this is an old Composite Provider that was created before the upgrade to BW7.4. Maybe you recognize this square when you look at the datasources, 3.x datasources also have a square icon.
Regards,
Pieter
Hi,
I tried to use the RSO_CONVERT_IPRO_TO_HCPR but it doesn’t accept local composite providers, only DSO, cubes, info objects, etc. Have you tried this program with local composite providers?
Thanks,
John
Hi John,
Insert the technical name of the local composite provider in the InfoProvider field, start with “@3..”. This will work.
Regards,
Pieter
Whenever i try to migrate old composit providers to new ones i get the error compounding parent missing for this field….. . Can you tell me what could be the problem?
Regards,
Anshul Sharma
Dear Anshul,
If I’m reading your error, this is a compounding issue. There are objects used in your old composite provider that are compounding with other objects, they should be in the composite provider as well. Eg. if you add 0GL_ACCOUNT, the object 0CHRT_ACCTS should always be part of your composite provider.
Hope this helps you to fix the issue.
Regards,
Pieter