Dynamic Dials based on a BEx Hiearachy Node Variable

[former_member277936]

Hi Guys,

I'm new to Xcelsius Dash Boards and I have a requirement where user wanted to have some Dials and report had hierarchy Node Variable. If User choose the Balance sheet then 8 Dials should come, one for each node. if User choose Balance sheet and Assets then four dials should come one for Balance sheet and one for Assets and two for asset child nodes. If user choose Balance sheet and Liabilities then 5 dials, one for balance sheet, one for Liabilities and three for Liabilities Child Nodes. If User choose Balance sheets, Assets ad Current Assets then three Dials, One for Balance Sheet, one for Assets an one for Current Assets and so on. Can somebody give me an idea how to do it.

Attached is the Hierarchy Structure for more info.

[former_member194862 · Accepted solution]

You can make the use of dymanic visiblity in the excel and show the gauges respectively.Say we select two values then value x gets inserted in the excel and then the dynamic visiblity can be mapped.

[former_member277936]

Finished the Dashboard, with the help of Dynamic visibility