Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: CognosBIUser1 on 13 Sep 2019 05:20:49 AM

Title: Using Between Two dates in DImesional reporting
Post by: CognosBIUser1 on 13 Sep 2019 05:20:49 AM
Hi,

Reaching out to see if someone has done this in there report before.
I have a crosstab report based on DMR model. I want to display a tree prompt which would give the user the option to choose a from date to To Date. I want to use this parameter values in my query to filter the data based on that.
relational I would write FiscalYear.Date between ?StartDate? and ?EndDate?.
How can I write this in Dimensional reporting ?

Second part of my question. I have a dimension called Dataset. It has SOC_ Nov as a member.
what I would like to achieve is that in a user in the prompt if a user select SOC_NOV member I would like the report to show the Data for GS_NOV as well in addition to the SOC_NOV.

Any help is appreciated.
Thanks in Advance!
Title: Re: Using Between Two dates in DImesional reporting
Post by: Francis aka khayman on 16 Sep 2019 02:37:02 PM
https://www.cognoise.com/index.php?topic=12731.0
Title: Re: Using Between Two dates in DImesional reporting
Post by: CognosBIUser1 on 16 Sep 2019 04:34:56 PM
I am using a Tree prompt and I could not get it to work using the solution given in the link last week. finally just made the date selection a multi select by putting in a set and asked the user to select year / month / date hierarchy wise.
Text only | Text with Images