Hi all,
In a dimensional report, i need to set a prompt with two drop down list in order to represent a month range useful to filter report data.
Moreover i have two year filters in order to compare revenue for two different years.
So, i need to retrieve data for two years depending on the month range.
In my query, how can implement the month filters having a time dimension? I hope my explanation is clear.
Thanks a lot in advance.
Inviato dal mio LG-D802 utilizzando Tapatalk
Quote from: Rosanero4Ever on 23 Oct 2015 04:53:26 AM
Hi all,
In a dimensional report, i need to set a prompt with two drop down list in order to represent a month range useful to filter report data.
Moreover i have two year filters in order to compare revenue for two different years.
So, i need to retrieve data for two years depending on the month range.
In my query, how can implement the month filters having a time dimension? I hope my explanation is clear.
Thanks a lot in advance.
Inviato dal mio LG-D802 utilizzando Tapatalk
Hi,
If I was building this, I would forget all four prompts and replace them with a single tree prompt that allows users to select whichever year(s) and month(s) they desire from the hierarchy. Would your users go for this?
Cheers!
MF.
Hi, you're right bur user should select only two years. Is this possible?Moreover i need to intercept the selected years as parameters because my report has a calculated measures like difference and %diff that use the selected years
Many thanks for your help
Inviato dal mio LG-D802 utilizzando Tapatalk
Can anybody give me any other advice, please?
many thanks for your time!
You could limit the timespan selected using Cognos's javascript prompt API. There are options there for validation, which you can reject if they select more than two years.