Select in Hierarchy

[#1]

Hi All,

Need one help. I have a hierarchy with 5 dimension. This hierarchy is used in a straight table.

is there a way to dynamicaly have a calculated dimension populated with field values of the current level of the hierarchy?

So if I am at Dim3 level in the hierarchy, the calculated dimension should have the values of Dim 3 field.

I was trying to use getFieldSelections(getCurrentField(ProductHierarchy)) but it does not work. Any thoughts please?

Thanks

Raghu

[kaushiknsolanki]

Dear Raghu,

     Kindly post example file for more clarification.

Regards,

Kaushik Solanki

[Gysbert_Wassenaar]

Is there a reason you can't use a Drill-down group? You can create groups on the Dimensions tab of the properties window. Add the dimensions that make up your hierarchy to the group and use the group as a dimension in your chart. If you click on a value in the group dimension the chart will drill down to the next level of the hierarchy.

[#4]

Hi Gysbert,

you are right in this approach. However I was trying to achieve a different functionality. I do not want the chart to be drillable, but the straight table should be drillable and use the drill group.

Hence I wanted to set the bar chart dimension based on the level of drill down group dynamically. Hope I was able to elaborate correctly.

Thanks

Raghu

[Gysbert_Wassenaar · Accepted solution]

See attached qvw. Is that what you're talking about?

[#6]

Thanks Gysbert.

Thats exactly what I wanted

I have one question for you:

=$(=GetCurrentField(MyGroup))

I get the GetCurrentField(MyGroup) piece of code. But why were we required to put the $(= before that. Will it not evaluate directly without that? I assume that all functions evaluate directly.

Or I am missing something very basic here?

Thanks

Raghu

[Gysbert_Wassenaar]

If you use =GetCurrentField(MyGroup) then the name of the field is used as value instead of as field name for the dimension. It's not very basic, so don't worry about missing something. I first tried without the $(= too. I saw what happened and tried using dollar-expansion next. That did gave me the result I wanted.

[#8]

great..thanks Gysbert!