Day to Month to 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

[Blue]

Have you done any dimensional modelling?

A typical data mart will contain a time dimension.  This may have at the lowest grain a day (date).  The fact table will contain a foreign key to the dimension table (either a surrogate or actual date value).  By referencing the fact table by the time dimension you will have the ability to filter by any level in the dimension - day, month, quarter, year, etc. 

If you are using Report Studio against a cube data source then the cube probably contains a Time dimension with at least Year, Quarter, and Month if  not Day/Date as well.