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
Use calculations to extract the year, quarter and month from the date, group on these, and summarize your fact item in the report.
MF.