Date prompt not filter year

[Chandrasekar]

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

[Lynn]

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.

[orbair]

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