Variable Hierarchy and Node Hierarchy

[Former Member]

Hi Gurus,

Would like to ask for your assistance regarding the settings in the query that I need to modify. Below is the scenario

-There are 4 active hierarchy in the master data, hier1, hier2, hier3 and hier4

-The need is to have 2 variable for this hierarchy in the report

-one variable is to select the one of the 4 active hierarchy

-second intiial screen variable is the nodes or contents of the selected hierarchy above.

i think this is exit but can you give me adive on the execution of this.

[umashankar_poojar]

HI Ethan,

Does these 4 have different versions? like Hier1 V100, Hier2 V102, Hier3 V103 OR Hier4 V104 OR does these have different time frame? if yes then you can create variable for Version OR Time Frames. So that user can select which one they need.

Thanks,

Umashankar

[Former Member]

Hi Umashankar,

what versions are you referring, and time frame. the 4 hierarchy are the same settings.

[umashankar_poojar]

Hi Ethan,

Hierarchies can be Version Dependent and Time dependent. You can find the information regarding this in 'Hierarchy' Tab and in Hierarchy Properties in InfoObject Manage screen (@RSA1). If you have/made version dependent then we can achieve as mentioned in my previous post.

Thanks,

Umashankar

[Former Member]

the entire hierarchy is time dependent.

Hi Umashankar,

Do you kow how can I remove the node variable that is populated whenever I drill down a node variable, as if it is part of the lowest hierarchy node.

noticed that FRB - NODE if I drill down, there is a master data that is also FRB, its a bit confusing if you are going to choose a node base which is right, need assistance.

[cornelia_lezoch]

Hi Ethan,

if you use nodes that are also values of your base char - ie the node is a cost center and the hierarchy is a cost center hierarchy

then you will always see one leave =  node.

in the query you can disable to show "values of booked nodes" when you diasbale this seting, you will see only the node, not the leave.

regards

Cornelia

[Former Member]

Hi Cornelia,

Thank you for your prompt reply. But in the drill down, it is required also to have the lowest level node, I am just wondering, why is there a node at the same time, the same value apears to be the child, if I search G00857 for sample, it appears two values, and its a bit confusing, because if i choose the first one, it has values in the extraction, if i choose the second one, there is no data after extraaction, there is no indicator in analysis office if it is a node or a child.

but other hierarchy doesnt have that kind of drill down... that is why i am confused.

[cornelia_lezoch]

since I don´t know your data model and I can´t see your hierarchies, I can´t answer that question.

it could be a value used as node and leaf,

it could be a link node

it could be a compounded characteristic

[Former Member]

Thank you Cornelia for the help. Appreciated it.

[umashankar_poojar]

Hi Ethan,

For your Hierarchy Master data object in BEx Query designer, there is a option to display values based on 'Master Data'. Please disable that and keep it as values from InfoProvider OR posted values. Basically other than Master Data, then that master data after root node will not appear.

But your question/issue was to show all hierarchies as drop down? are you able to achieve it OR still not?

Thanks,

Umashankar

[Former Member]

it still doubles the value, the hier_node is also part of the child node but it is not a master data because it is just a node.