Skip to Content
0
Former Member
Dec 09, 2009 at 03:39 PM

MDX used in Universe for Prompt with a substring function (e.g. left)

47 Views

Hello,

I Try to solve the following Problem

I try do setup a prompt like Year (YYYY) = Year of Month (YYYYMM) where the user has to select a month. Out of his selection I want to extract the Year of the selected month.

I have the Dimension YYYYMM (e.g. 200903) ([0CALMONTH].[LEVEL01].[NAME])

I have the Dimbension YYYY (e.g. 2009) ([0CALYEAR].[LEVEL01].[NAME])

I have a Prompt on YYYYMM which works:

<FILTER KEY ="[0CALYEAR].[LEVEL01].[NAME]">

<CONDITION OPERATORCONDITION="Equal">

<CONSTATN CAPTION = "@PROMPT('YYYYMM','A',u2018D01 TIME\YYYYMM',MONO,CONSTRAINED)" />

</CONDITION>

</FILTER>

The following Filter doesn't retrun anything and i don't know why. Does anybody has a tip form me?

<FILTER KEY ="[0CALYEAR].[LEVEL01].[NAME]">

<CONDITION OPERATORCONDITION="Equal">

<CONSTATN CAPTION = "LEFT(@PROMPT('YYYYMM','A',u2018D01 TIME\YYYYMM',MONO,CONSTRAINED),4)" />

</CONDITION>

</FILTER>