Skip to Content
0
Former Member
Oct 26, 2010 at 03:48 PM

How to create seperate Objects in MDX Universe?

12 Views

Hi,

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!

Kind Regards

Jens