How to Copy HANA CompositeProviders
SAP BW 7.x SP8 has added more capability into the new type of CompositeProviders (loosely called HANA CompositeProviders). Hence, we’re seeing these type of CompositeProviders getting used more frequently and being preferred over MultiProviders. Unfortunately, at least in SP8, there’s no standard way to copy these type of CompositeProviders. I have written a program to fill this gap and this blog post contains a copy of that program. The program allows a user to specify the CompositeProvider to be copied, the InfoArea into which the new CompositeProvider will be placed, and the name of new CompositeProvider. The selection screen looks like this:
The program works by invoking the underlying ABAP classes of a HANA CompositeProvider namely: CL_RSO_HCPR and CL_RSO_HCPR_VERSION. The underlying tables that store the definition of a CompositeProvider is modeled a bit differently than the tables for the old BW objects (e.g. DSO, InfoCube). In particular, an XML representation of the object is now stored in table. For CompositeProviders, the main configuration table is RSOHCPR. The field XMLUI of this table contains the XML definition of a CompositeProvider. Hence, a good deal of the code in the attached program is for manipulating the XML string to change the name of the CompositeProvider and its InfoArea.
Nice Really helpful.
This helped a lot. Thank you
Perfect solution for something that should be available in the standard set-up...
Perfect. In future SAP might come with the solution as the Copy is not even working in SPS10 as well. Thanks for the blog.
Hi,
I've just tested in my system with SP10: there's a "Copy to" menu entry that allows you to copy the CP and change the InfoArea. Also in "Create Composite Provider" window you can choose "Copy from" option and create it as a copy. Maybe you should update your BWMT.
Hi Andrey, In my Ecplise, the menu copy option is disabled mode which I can not be able to use it. May be some installation issue! Apart from this all other features are fine to me. And create as a copy is also not coming. I will check if there are any installation issues are there! Thanks.
Hi, Murali.
I've faced some issues with Eclipse Mars (some perspectives were very buggy), but currently I'm on Eclipse 4.4 Luna SR2 with the latest version of BW Modelling Tools installed, and all works fine.
Hope you'll fix your installation to be full-featured.
I'm on SP11 and on Eclipse Mars 4.5.1. My BW modelling version are updated to latest 1.13.2
Still cant find any options for Copy. Any heads up?
Please see OSS Note 2166676 CompositeProvider: "Copy To...:
Hi Emmanuel,
Where is code mentioned by you?
Regards,
Dheeraj
Hi Former Member,
Thanks for writing this blog. Do you still have the code for this program that you mentioned in this blog?