my KPI Net Value has different characteristics, depend on the dimension MSTH YTD GROUPED. There are Values for
MSTH YTD GROUPED= "YTD" MSTH YTD GROUPED= "Last YTD" MSTH YTD GROUPED= "Plan YTD"
In Webi I am able to separate the objects with the following formular:
=[Net Value] where [MSTH YTD GROUPED] = "YTD"
But I want to separate the KPI in the Universe, as single objects, like
Net Value YTD Net Value Last YTD Net Value Plan YTD
Of couse, if I create single objects and create a simple filter like
<FILTER KEY="@Select(YTD Grouped\MSTH YTD GROUPED)"><CONDITION OPERATORCONDITION="Equal"><CONSTANT CAPTION="YTD"></CONSTANT></CONDITION></FILTER>
But than, I will not able to get the three objects together in one query.
How can I separate the objects in a MDX universe and get all objects in one Query?
Thanks for helping!