Hi!
I have a rather serious problem.Using the standard YTD functions for calculating the current year measures , versus lat years the situation is as follows:
My current data are as of i.e. 15/5/2010.
I want proir YTD to be asof 15/5/2009 not as of today (18/5/2009)..
What i have to do? Create custom function in Transformer?
Sorry if my questions are stupid but i am very new to the Cognos game.
Thanksl.
Elias
First step would be to ensure that only your Fact dataset/query is setting the current time period. There is a checkbox in the property of the dataitem.
Next in Category viewer, you have to create a special time category. I believe YTD last year is an inbuilt option
"The only problem is that i want another date to be the current....but i think that i have found the solution...disable current year from my datasource and create another one to set the current date for the YTD function.