If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

URGENT: Prompt Macro as Text Default of another Prompt Macro

Started by Tore2015, 28 Jul 2015 07:10:00 AM

Previous topic - Next topic

Tore2015

I am in a bind, and need assistance if possible!!

Need to use another prompt macro as the value for the default text within another macro.  Here is the background:  I am trying to set the range for the x-axis of a chart to show a set number of months by default, and then the min and max months will be changed dynamically by prompts.  So the data item I am using for the range is as follows:

intersect(lastPeriods(-9999, (#prompt('p_Month1','memberuniquename','item(tail([People Pack EOP].[Time Dim].[Time].[Month]),0)')#)),
lastPeriods(9999,(#prompt('p_Month2','memberuniquename','item(tail([People Pack EOP].[Time Dim].[Time].[Month]),0)')#)))


The first part of this expression works as expected, but the 2nd prompt 'p_Month2', will need to have a default of 12 months back from the tail of the Month level.  Below is a separate expression that can get this member 12 months from the tail:

head(lastPeriods(12,item(#prompt('p_Month','memberuniquename','tail(members([People Pack EOP].[Time Dim].[Time].[Month]))')#,0)))

So my dilemma, is how to combine these expressions into one expression which will be used for the range,,which will be dynamic?????

First...does this make sense and Second...is there a solution?