COGNOiSe.com - The IBM Cognos Community

Planning & Consolidation => COGNOS Planning => Topic started by: sgan on 27 Feb 2010 10:55:56 AM

Title: Table layout Publish script
Post by: sgan on 27 Feb 2010 10:55:56 AM
Configured table layout publish by generating script in a database locked down environment.

If the elements are added to a dimension that has a publish running . do we need to generate updated script file each time when there is a change is a dimension. my environment does not have db creator rights.

Do the dba need to run the updated script file for table publish each time when there is a change is publish dimensions

Appreciate your responses
Title: Re: Table layout Publish script
Post by: ciaronk on 05 Mar 2010 06:13:26 AM
Adding new dimension members is fine aslong as they dont create a new level to the hierarchy.  If the members you add create a further level in the list structure then this will require a new column to be added to you published dimension table and then a script will be required.

Hope that made sense...