Print Page - Previous Year using Dimensional Model

Title: Previous Year using Dimensional Model
Post by: ajhuzky on 12 Mar 2009 04:05:52 AM

Hi!

Maybe someone can help me on how to create a Data Item for me to call the Previous Year data?

thanks.... ;D

Title: Re: Previous Year using Dimensional Model
Post by: Gollapudi on 12 Mar 2009 04:42:17 AM

Hi,

Your Question is not so clear... can you tell me what exactly your expecting..?

Thanks,
Gollapudi.

Title: Re: Previous Year using Dimensional Model
Post by: ajhuzky on 12 Mar 2009 07:37:42 PM

Hi,

I need to get the Current Year data and Previous Year data in one report.
ex.
Current Year (2009) Previous Year (2008)
154,209 USD ?

How can I get the Previous Year? It is easy getting it using a Relational Model but I need to get it using Dimensional Model. Previous Year was not set in the database that is why I need to do some work around in the front-end or in report studio version 8.3.

Hope you can help me with this to resolve my issues.

Thank you very much!

Title: Re: Previous Year using Dimensional Model
Post by: Gollapudi on 13 Mar 2009 01:24:44 AM

Hi,

Do you have any Time dimention in your model?, if yes, whatz the hirarchie structure..

Thanks,
Gollapudi.

Title: Re: Previous Year using Dimensional Model
Post by: ajhuzky on 16 Mar 2009 12:49:17 AM

Hi,

Hierarchy under Period is Year >> Half-Year >> Quarter >> Months.

thanks,

ajhuzky

COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Report Studio => Topic started by: ajhuzky on 12 Mar 2009 04:05:52 AM