Skip to Content
Author's profile photo Former Member

BW7.30:Exporting Hierarchy using Open Hub Destination into Flat file from BW 7.3

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. 

Assigned Tags

      13 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member
      nice post and good explanation. thank you very much krishna.
      Author's profile photo Former Member
      Former Member
      Blog Post Author
      Thank you for your appreciation 🙂
      Author's profile photo Former Member
      Former Member
      good explanation...understood in first read only..:P
      Author's profile photo Former Member
      Former Member

      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.

      Author's profile photo J. Lievense
      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?

      Author's profile photo Martin Grob
      Martin Grob

      nice post I found by accident..

      thanks

      Martin

      Author's profile photo Former Member
      Former Member

      Nice Blog.

      Author's profile photo Former Member
      Former Member

      nice post and good explanation. thank you ..

      Author's profile photo Former Member
      Former Member

      good piece of doc

      Author's profile photo Former Member
      Former Member

      Nice post..i see 2 files getting extracted. if this hierarchy needs to be loaded into an other existing object then what is the process

      Author's profile photo Ramesh Murugan
      Ramesh Murugan

      Understandable document.

      Author's profile photo Former Member
      Former Member

      Simple and undersandtable.Many thanks 🙂 .

      Author's profile photo Torsten Wirth
      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