Print Page - Date prompt not filter year

Title: Date prompt not filter year
Post by: Chandrasekar on 30 Jun 2014 08:45:57 AM

Hi All,

I am creating sales revenue report using cognos 10.2 dimensional model.

In prompt page have starting date and ending date using date prompts . If i give the period of years not filtered in report page, report will be displayed in all the years.

Please give me the solution quickly.

Thanks and regards,
Chandrasekar

Title: Re: Date prompt not filter year
Post by: Lynn on 08 Jul 2014 11:29:07 AM

Quote from: Chandrasekar on 30 Jun 2014 08:45:57 AM
Hi All,

I am creating sales revenue report using cognos 10.2 dimensional model.

In prompt page have starting date and ending date using date prompts . If i give the period of years not filtered in report page, report will be displayed in all the years.

Please give me the solution quickly.

Thanks and regards,
Chandrasekar

I don't understand your requirement. What does your date dimension look like? A report that prompts for a start and end date sounds relational to me rather than dimensional.

Title: Re: Date prompt not filter year
Post by: orbair on 08 Jul 2014 11:55:47 AM

HI, I have tried to use member of DMR for filtering, and worked. Please put the year which is under the member folder.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Chandrasekar on 30 Jun 2014 08:45:57 AM