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

Custom YTD function?

Started by EarthDog, 18 May 2010 01:13:44 PM

Previous topic - Next topic

EarthDog

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

redmist

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

EarthDog

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