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 !
Quote from: bwalikar on 15 Feb 2019 02:40:07 AM
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.