Update latest date of Time Dimension automatically

[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