COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Transformer => Topic started by: cognoobie7 on 12 Jul 2014 07:15:44 PM

Title: Cube not showing new column added in DB
Post by: cognoobie7 on 12 Jul 2014 07:15:44 PM
Can someone please help? There was a column that was added in the DB which was automatically picked up in framework manager. So I didn't republish the package. The same package is being used in to build a cube ...but it's not picking up the additional column that was added in the DB.

Title: Re: Cube not showing new column added in DB
Post by: Lynn on 14 Jul 2014 07:44:55 AM
Try this exercise to see if it helps you understand things:

1) Create a new framework model and import one object.
2) Publish the package.
3) Use report studio to confirm you see only that one object.
4) Open the model and add another object. Don't publish the package.
5) Open the package in report studio again. You should still only see the first object, not the second. WHY? Because you didn't publish the package again after adding new meta data.

Now consider the above in terms of your current situation. How will the package show the updated meta data if you don't publish it?
Title: Re: Cube not showing new column added in DB
Post by: cognoobie7 on 14 Jul 2014 06:53:01 PM
thanks Lynn !!