day, month, quarter and year

[maruthi]

Hi Friends,

I am using Cognos 8 Report studio.

Here the I need some solution. The fact ietem from the database is coming on day dimension and we need to show the fact  for day, month, quarter and year.

any solution?

Thanks in Advance,
- Maruthi

[MFGF]

Use calculations to extract the year, quarter and month from the date, group on these, and summarize your fact item in the report.

MF.