Using hierarchy data in set analysis?

[#1]

I have a chart that uses hierarchy data. I would like the chart to maintain  two hierarchy/treeview items (Interest Income, Fee income,etc...) and have have the ability to change around regions (Which is also in a hierarchy/treeview, North, Northeast,etc...). I have the hierarchies in drill down groups also. Is there any way to do set analysis like Sum(${<measurement={Current hierarchylevel}>}Amount)?

If this is posted to the wrong place, please advise what place to send this to.

Thank You,

Frank

[kkkumar82]

Hi,

Sum(${<measurement={getcurrentfield(drilldowngroupname)}>}Amount)

Hope it solves the problem.

Thanks

Kiran Kumar

[jonathandienst]

Your high level requirement is clear, but the details are not clear. Please post your qvw or a represntative sample to and a more detailed explanation of what you require. For example, how should the set expression filter the data differently as you drill into the hierarchy?

[#4]

Sorry for the lack of detail, Jonathan.  It is an extremely large file. I am thinking about using a calculated dimension. IThe dimension would be the drill down group. The expressions would be the Sum of the current year, sum of previous year, monetary difference between current and previous year, and the percentage of the difference.  I want the expressions to be static with the dimension selecatble from a separate list box.

What you have Kiran is great but I do not need a Sum, since it would be a dimension.

THank you both for the responses.

[kkkumar82]

Hi,

I can help you on this, I had a same situation , I had ten charts where there are 3 expressions and 8 Dimension groups rather than creating 8 charts I created a variable dimension (which is calculated) and I had a input box with all the group names and when I select a value in the list box the chart will change to the group.

Is that what you required

Thanks

Kiran Kumar

[#6]

Kiran, this looks like what I might be after. To reiterate, create a variable that will hold the selections from a list box and use the variable as the dimension in the chart. Is that correct?

Thanks,

Frank

[kkkumar82]

Create a inline load(Data island)

as below for eg

Load * inline [

SNO, Group Name, Group Title

];

Now in the front end create a variable as vDynamicGroups

Next create a input box and add the above variable.

In the input box properties, goto Constraints->tab

See the attached pic and select the options like that

and for the concat function, concat(Group Name,SNO)

and lastly use the variable (vDynamicsGroups) in the chart.

Thanks

Kiran Kumar

[kkkumar82]

Yes

[kkkumar82]

PFA qvw file , I created three dimension groups and a input box for holding all those groups, check out the example. Let me know any modifications required.

Thanks

Kiran Kumar

[#10]

Kiran,

There is no file that I can open.

Thanks,

Frank