cancel
Showing results for 
Search instead for 
Did you mean: 

Attributes convert to hierarchy

Former Member
0 Kudos

Hello,

  I have a master data with attributes. I need to able to build a hierarchy on the master data including

the attribute.

  For instance,

   Master Data:                        Attribute:

   Customer Number: 1             Region: A

   Customer Number: 2             Region: A

   Customer Number: 3             Region: B

   Customer Number: 4             Region: B

My hierarchy should be like;

     A

       1

       2

    B

      3

      4

Is there any way to do that? Any abap programme?

And also, how can I update the hierarchy every night?

Thanx.

Accepted Solutions (1)

Accepted Solutions (1)

former_member976
Active Contributor
0 Kudos

Hi Engin,

Please check the with hier option in info object level and your correct  you have 4 customers and 2 regions like that above you mention.

which vesion working on BW? BI 7.0 not support but 7.3 will support and loading flat file and form ECC?

please find the below document.

Thanks,

Phani.

Answers (4)

Answers (4)

Former Member
0 Kudos

Thanx,

But, my problem is I should create a hierarchy including its attribute. If there is a new attribute, BW should automaticaly add that into the hierarchy as a component. And also, it should automaticaly add all master data, which is connected to the attribute, under the component.

My system is 7.30.

Thanx in advance.

Former Member
0 Kudos

Hi Engin,

you can activate a display hierarchy in your Query (assume you're on BI 7.0 and above).

Then click on "Rows", get properties and their you can set "Dispaly as hierarchy" to "Active", simply check the checkmark. You can also choose to which level the hierarchy should be expanded. In your case it's to Customer. But be aware, all other characteristics in your query will then apper under "node" customer.

Regards,

Jürgen

yasemin_kilinc
Active Contributor
0 Kudos

Hi Engin,

I remember a property in the query that shows the characteristics as hierarchy. Right Click on anywhere in rows or columns and check "display as hierarchy".

That will solve your problem.

Hope it helps

Regards

Yasemin...

RamanKorrapati
Active Contributor
0 Kudos

Hi,

why can't you create hierarchy structure at your info object level?

if you maintain hierarchy at info object level then you can load data thru flat files.

Thanks