Skip to Content
Author's profile photo Former Member

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:

ZBW_HCPR_COPY Selection Screen.PNG

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.

Assigned Tags

      11 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Nice Really helpful.

      Author's profile photo Sureshkumar Papureddi
      Sureshkumar Papureddi

      This helped a lot. Thank you

      Author's profile photo Anthony Debyser
      Anthony Debyser

      Perfect solution for something that should be available in the standard set-up...

      Author's profile photo Former Member
      Former Member

      Perfect. In future SAP might come with the solution as the Copy is not even working in SPS10 as well. Thanks for the blog.

      Author's profile photo Andrey Eliseev
      Andrey Eliseev

      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.

      Author's profile photo Former Member
      Former Member

      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.

      Author's profile photo Andrey Eliseev
      Andrey Eliseev

      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.

      Author's profile photo Former Member
      Former Member

      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?

      Author's profile photo Alex Neary
      Alex Neary

      Please see OSS Note 2166676 CompositeProvider: "Copy To...:

      Author's profile photo Former Member
      Former Member

      Hi Emmanuel,

      Where is code mentioned by you?

      Regards,

      Dheeraj

       

      Author's profile photo Former Member
      Former Member

      Hi  Former Member,

      Thanks for writing this blog. Do you still have the code for this program that you mentioned in this blog?