COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Framework Manager => Topic started by: Joker on 30 Jul 2014 12:10:19 AM

Title: Layered Approach
Post by: Joker on 30 Jul 2014 12:10:19 AM
Hi,

We know that using a 3 layered approach is a good modelling practice. My doubt is about physical layer.
We are keeping the physical layer isolated and unchanged in our model and we are doing this so that the efficient queries are generated at the run time.
In what sense by keeping the Physical layer intact we can easily maintain the model??
Please give an example assuming that we had used 3 layers in our model once and now some change has occured in the database.Now What has to be done?

Regadrs,
Joker
Title: Re: Layered Approach
Post by: MFGF on 30 Jul 2014 10:40:30 AM
Quote from: Joker on 30 Jul 2014 12:10:19 AM
Hi,

We know that using a 3 layered approach is a good modelling practice. My doubt is about physical layer.
We are keeping the physical layer isolated and unchanged in our model and we are doing this so that the efficient queries are generated at the run time.
In what sense by keeping the Physical layer intact we can easily maintain the model??
Please give an example assuming that we had used 3 layers in our model once and now some change has occured in the database.Now What has to be done?

Regadrs,
Joker

Hi,

I think your best approach in getting a better understanding of how to model successfully in Framework Manager is to do some background reading. Here are a couple of articles from DeveloperWorks to get you started. They apply to Cognos 10 as much as Cognos 8 (for which they were written)

http://www.ibm.com/developerworks/data/library/cognos/page60.html
http://www.ibm.com/developerworks/data/library/cognos/page49.html

Cheers!

MF.
Title: Re: Layered Approach
Post by: Joker on 03 Aug 2014 11:13:14 PM
Quote from: MFGF on 30 Jul 2014 10:40:30 AM
Hi,

I think your best approach in getting a better understanding of how to model successfully in Framework Manager is to do some background reading. Here are a couple of articles from DeveloperWorks to get you started. They apply to Cognos 10 as much as Cognos 8 (for which they were written)

http://www.ibm.com/developerworks/data/library/cognos/page60.html
http://www.ibm.com/developerworks/data/library/cognos/page49.html

Cheers!

MF.

Thanks..:)