on 02-05-2014 1:53 PM
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.