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

Update latest date of Time Dimension automatically

Started by khoinh, 07 Sep 2010 09:37:37 PM

Previous topic - Next topic

khoinh

Hi
   I defined the Time dimension (D_Time) in my cube that was created by Transformer tool. This cube is rebuild every week by below script.

cogtr -n2 -c -g -s -m"C:\Cognos\Transformer\ABC.pyj"

Before the script is started, I must access to my cube and update latest date information of D_Time to the current date. How can I set latest date to reflect today's date automatically?

Thanks

RobsWalker68

Hi,

If you have a look in your Transformer model, click on a data source and then the general tab you will notice that there is a item called "Sets the current period".

The way I personally handle it is to create a seperate source called Current period with a calculated item that is set to todays date and make sure that the "Sets the current period" is checked.  On all other data source feeds I uncheck the Set current period.

Rgds

Rob