COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Transformer => Topic started by: damzI on 27 Jul 2016 02:53:04 PM

Title: How to refresh categories in selected dimensions in Transformer
Post by: damzI on 27 Jul 2016 02:53:04 PM
Hello Experts,
In Transformer I am looking to refresh categories from sellect dimensions except the Time Dimension.
The cube will be automatically scheduled to be completely refreshed every month - but the Time dimensions should not be refreshed.
Is there a way to select the dimensions to be refreshed completely during the cube build.
I am thinking there is a simple way to do this but it escapes me.
Thank you for your help - D
Title: Re: How to refresh categories in selected dimensions in Transformer
Post by: Francis aka khayman on 26 Aug 2016 04:51:44 AM
in the dimension properties in cognos transformer, there is an option to "Prohibit automatic creation of new categories". worth a try
Title: Re: How to refresh categories in selected dimensions in Transformer
Post by: Michael75 on 26 Aug 2016 09:42:25 AM
QuoteI am thinking there is a simple way to do this but it escapes me.

Surprising that it escapes you, because Cognostechie gave you the answer to the very same question when you last asked it here:

http://www.cognoise.com/index.php/topic,31244.0.html (http://www.cognoise.com/index.php/topic,31244.0.html)