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.

To report this post you need to login first.


You must be Logged on to comment or reply to a post.

    1. Andrey Eliseev


      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.

      1. Murali M

        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.

        1. 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.

          1. Nic C

            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?


Leave a Reply