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
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