"From month" "to month" dimensional filter

[Rosanero4Ever]

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

[MFGF]

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.

[Rosanero4Ever]

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

[Rosanero4Ever]

Can anybody give me any other advice, please?
many thanks for your time!

[bdbits]

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.