COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Framework Manager => Topic started by: ghostraider on 07 Apr 2008 10:56:13 PM

Title: Modelling in FM
Post by: ghostraider on 07 Apr 2008 10:56:13 PM
Hi, i have some Impromptu catalogs which have been migrated to 8.2. Do these catalogs need remodeling in Framework Manager? If yes, what would be the main things that i need to modify or look into and what are the drawbacks if these catalogs are left as they are.

Thank you all for your responses  :)

Title: Re: Modelling in FM
Post by: rockytopmark on 08 Apr 2008 08:15:08 AM
Nothing different than modeling from scratch... follow best practices and look for problems like multiple join paths, etc.  8.3 has a built in Model Advisor tool that will point all those potential pitfall areas out.

You Datasource queries should be "Select * from ..." only to allow minimized SQL.

Too many specific things to list.