How to create seperate Objects in MDX Universe?

[Former Member]

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

[Former Member · Accepted solution]

Hi,

You just need to create one restricted meassure for each value of "MSTH YTD GROUPED" dimension, it should look like this:

"Net Value YTD" expression:

([Measures].[MyMeasure], [MSTH YTD GROUPED].[YTD])

"Net Value Last YTD" expression:

([Measures].[MyMeasure], [MSTH YTD GROUPED].[Last YTD])

"Net Value Plan YTD" expression:

([Measures].[MyMeasure], [MSTH YTD GROUPED].[Plan YTD])

This is just a sample, please check technical name for the measure et the "MSTH YTD GROUPED" values.

Didier

[Former Member]

Hi Didier,

thanks a lot for the fast and capable answer! It works fine with:

<EXPRESSION>
([Measures].[OINV INVOICE NET VALUE], 
[Period].[YTD Grouped].[MSTH YTD GROUPED].[YTD])
</EXPRESSION>

Kind Regards

Jens