If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Security in Transformer Cube using Cube Views

Started by damzI, 11 Aug 2016 10:55:58 AM

Previous topic - Next topic

damzI

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

bdbits

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.