Skip to Content

Hello SCN,

We use Open Hub destination to get the data from SAP BW system. In this blog, i would like to explain how to download a hierarchy from BW 7.30 to flat file.

When you export the hierarchy from BW 7.3, we will get the hierarchies in the new structure (though the hierarchy was defined in the old structure of 3.x).

In the navigation, i would brief about exporting hierarchy from BW to flat file, using a info object template.

 

Navigation:

1)      Go to DWWB (RSA1).

2)      Select Open Hub Destination.

3)      Now select “Create Open Hub Destination” from the context menu as shown below.

 

4) Give the name and description.

5) Select Template as Info object (It means we are selecting the Hierarchy to be downloaded on the basis of info object).

 

 

Give the info object name (Example: 0COSTCENTER)

6) Check the Subobj. Type as “info object Hierarchies”(to mention that we need the hierarchy list to be downloaded)

7)Check the option “Create Transformations and DTP”(it will automatically create the required transformations and DTP for data loading process).

Now you can see the transformations required for data loading process are automatically created and activated as shown below.

8) Now select the Destination type as “FILE”. 

 

9) Select the Directory and give the path name for your local directory.As you are giving “local directory” here , it would warn you as “it cannot be loaded using process chains”. You can ignore the warning.

 

10) Don’t forget to give the hierarchy name, which you want to download in the filter selections of the DTP.

11)Now Activate the DTP and execute it.

Now you can see 2 files S_HIERTANG.CSV (metadata of the hierarchies) and HIERTANG.CSV(hierarchy details in new structure).

Hence we downloaded the hierarchy. 

To report this post you need to login first.

13 Comments

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

  1. Rodrigo Riveros

    Hi Krishna,

    First of all congrats for a very good post.

    Do you know if this hierarchy export with open hub start only with a 7.3 BW version?

    I’m looking for the same feature in previous versions (7.1 – 7.2) and I’ve found only the “How to export hierarchy to a flat file”, but nothing about open hub.

    Thanks for your help.

    Rodrigo Riveros.

    (0) 
  2. J. Lievense

    Hi, Thank you for this.

    I have tried to export time dependent hierarchy, but running the generated DTP results in a dump,

    UC_OBJECTS_NOT_CONVERTIBLE

    The statement

        “MOVE src TO dst”

    requires that the operands “dst” and “src” are convertible.

    Since this statement is in a Unicode program, the special conversion

    rules for Unicode programs apply.

    In this case, these rules were violated.

    Any suggestions so solve this?

    (0) 
  3. Torsten Wirth

    Hi,

    We have tried this function now but the sort order of the hierarchy is mixed up. If this a special behaviour of our release (7.4 SP9) or is it normal that the order in the export (e.g. csv) is not the same than in the original hierarchy?

    Regards,

    Torsten

    (0) 

Leave a Reply