dynamic columns in query depending on hierarchy nodes

[Former Member]

Hello all

I want to design a query with dynamic number of columns depending on hierarchy node.

A hierarchy node is selected while running the query and user has authorization to see all subsequent nodes below the selected node.

e.g. consider grp hierarchy with units and sub-grps as nodes.

level1 Grp1

levele2 unit1 : grp2 : grp3

level3 : unit2 unit4 : unit4 grp4

Suppose user select node Grp1, then there should be 3 columns for unit1, grp2, grp3

If user selects node grp2, then there should be 2 columns for unit2 and unit4

Please help. Any suggestions highly are highly appreciated.

Rgds

Sanjyot

[Former Member]

Surekha,

Try this.

Place heirarchy/characteristic in columns, under this place required keyfigure.

Restrict with variable.

Srini

[Former Member]

Thanks Srinivas !

I did the same.