Good day, Guru's!
Maybe someone in advance how to create something like "measure set"?
I try to build a chart report that would enable the user to select the group of measures in value prompt and pass it to chart.
Try to explain:
Value prompt with static values:
Display | Use
-----------+------------------------
Group1 | set([Chart].[Measure].[Measure1],[Chart].[Measure].[Measure2],[Chart].[Measure].[Measure3])
Group2 | set([Chart].[Measure].[Measure4],[Chart].[Measure].[Measure5])
I write "set" function just for explaining, i understand that this didn't work with measures
Then user select Group1, chart would display 3 lines in Y axis with measures: Measure1,Measure2,Measure3.
I understand how to pass single measure in chart by value prompt (http://www.cognoise.com/index.php?topic=9158.0).
Thanks!
So, i just create conditional block and copy line chart for each measure group and give control to value prompt.
But question still interesting, set of measures, it is possible?