COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Framework Manager => Topic started by: jive on 20 Jul 2010 07:11:09 AM

Title: Updating the SQL under dimension
Post by: jive on 20 Jul 2010 07:11:09 AM
Hi,

For some reason I have to modify the a query definition for one of my query subject. That subject is used as source in a regular dimension. My question is : When I change the query definition how can I change or update the regular dimension underlaying SQL. I was on the impression, this process is fully automatic.

Thanks.
Title: Re: Updating the SQL under dimension
Post by: blom0344 on 20 Jul 2010 09:42:04 AM
The model generates the SQL, so changing the model should be reflected by changes in the SQL generated. Yes, this should take place automatically when you change the source definition..