Dimensional Reporting - Date Range in the prompt page

[bwalikar]

Hi all,

Need your help with following scenario in the cube based report :

Source : Cube
Requirement : User can select a Date Range in the prompt page ( From Date , To Date)
Report list should show data for
Column 1 = Selected Date Range
Column 2  = (From Date - 7 days) to (To Date - 7 days)
Column 3  = From Date last year - To Date last year.
Column 4 = % change between Column 1 and Column 3

I believe to show all these columns on a single list we need to have a single final query. Can you please on how this can be achieved using the dimensional functions.

Any help is highly appreciated !

[Lynn]

Hi all,

Need your help with following scenario in the cube based report :

Source : Cube
Requirement : User can select a Date Range in the prompt page ( From Date , To Date)
Report list should show data for
Column 1 = Selected Date Range
Column 2  = (From Date - 7 days) to (To Date - 7 days)
Column 3  = From Date last year - To Date last year.
Column 4 = % change between Column 1 and Column 3

I believe to show all these columns on a single list we need to have a single final query. Can you please on how this can be achieved using the dimensional functions.

Any help is highly appreciated !

You might get more help if you describe your date dimension in more detail, including what the MUN looks like.