Prompt Macro in DMR Crosstab

[raj_aries81]

Hi All,

Instead of filtering the Year, I want to use the below code in crosstab for comparing YTD Vs PYTD. I tried below two approaches.
However, I could not get it right. Is there something that is causing the issue

[Year]->#prompt('Param_Year','token','closingPeriod([Prod Level Cube].[Time Dim].[Report Period].[Year])')#

or

[Year]->#prompt('Param_Year','MUN','roleValue('_memberUniqueName',closingPeriod([Prod Level Cube].[Time Dim].[Report Period].[Year]))')#

Thanks & Regards
Raj

[Lynn]

Hi All,

Instead of filtering the Year, I want to use the below code in crosstab for comparing YTD Vs PYTD. I tried below two approaches.
However, I could not get it right. Is there something that is causing the issue

[Year]->#prompt('Param_Year','token','closingPeriod([Prod Level Cube].[Time Dim].[Report Period].[Year])')#

or

[Year]->#prompt('Param_Year','MUN','roleValue('_memberUniqueName',closingPeriod([Prod Level Cube].[Time Dim].[Report Period].[Year]))')#

Thanks & Regards
Raj

It might help if you explain what the issue is.

[raj_aries81]

Lynn,

For one of the reports, i have inline prompts in the report page.so whenever report is run it should not prompt the user to select any specific year.instead it should
run for current year and the values should be compared against previous year. I am trying to pass current year as default value using the below code in crosstab calculation

[Year]->#prompt('Param_Year','token','closingPeriod([Prod Level Cube].[Time Dim].[Report Period].[Year])')#

The above code works fine if i use = instead of -> but will not serve the purpose as the year gets filtered for the selected year 

[raj_aries81]

Can I set a default value for a prompt macro and use it in a crosstab node instead of filter.

eg:[Year]->#prompt('Param_Year','token','closingPeriod([Prod Level Cube].[Time Dim].[Report Period].[Year])')#

[raj_aries81]

It might help if you explain what the issue is.

Lynn,

[Year]->?Year? works fine, can I use prompt macro instead of ?Year?

[Lynn]

Lynn,

[Year]->?Year? works fine, can I use prompt macro instead of ?Year?

I don't see why not, although you shouldn't be using detail filters. This post provides some excellent advice on that subject: http://www.cognoise.com/index.php/topic,24931.0.html