COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Framework Manager => Topic started by: maruthi on 01 May 2006 04:22:24 PM

Title: day, month, quarter and year
Post by: maruthi on 01 May 2006 04:22:24 PM
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
Title: Re: day, month, quarter and year
Post by: MFGF on 15 May 2006 11:02:40 AM
Use calculations to extract the year, quarter and month from the date, group on these, and summarize your fact item in the report.

MF.