How you are getting these 201404,201512 values when user selects APR-2014 to DEC2015?
I have a column in DIM_TIME called, CAl_YYYYMM, which i have added as a 'Descriptor ID of" to Fiscal Month Year Column in RPD. The value of CAl_YYYYMM is like 201404.
so if I Select MAY-2014, the PV will take the value of CAl_YYYYMM i.e. 201404.
As the Prompt is Month range so it will be comma separated. i.e 201404,201512
I don't know if there is other easily way, but I would try that:
Supose you has one PPT (prompt) and one Analysis (Report) linked between them
PPT (with month range) ---> Analysis (must receive PV calculated)
1 - Create a auxiliary analysis for receive PV and then calculate your months according you want
On this analysis you can use a month column and apply your PV from your PPT as a filter
Create a calculated column, union and so on for generate your Month Range + Aditional Month as you want
2 - Set this aux analysis as a filter for your Report using your calc column
It looks like that
Published (on a Dashboard) No Published (on a Dashboard) Published (on a Dashboard)
PPT (with month range) ---> AUX Analysis (calculate your Month Range) ---> Analysis (must receive PV calculated)
I hope this help
Thanks for your reply.
What I found, this concept might work in case of Dashboard, where we can link multiple analysis with a single dashboard prompt.
But In my case, I have to build it in Analysis page with analysis propmt.
is there any way out....
Then you have just one analysis with above logic and you wanna use inline prompts? is that ok?