So I am confused on the creation of categories in Cognos Transformer. I have set up Cube Views based on certain categories and do not want these to be removed when I do a Clean House.
So how can I ensure that these categories do not go away when doing a clean house.
Related to the above is the category refresh on the Date dimension, where I have created special categories that are customized relative time categories. So what is the maintenance strategy to ensure they are not removed. Yet, they will be refreshed every month based on the Current Date in the data source.
Thanks, D
If you do not want to remove categories, why are you doing a Clean House? That is what it does by definition.
For your date dimension issue, I would persist your custom categories into a date table in a database and use that as the source for the Transformer date dimension.