Creating calender Year using transformer date wizard

[cognos05]

Hi ,

I have my data file having the current Month - APR 2015.

I am creating a time dim and using the above column as input.

SO First I will create a Month level then create a drill down to this level , one being fiscal year and other being calender year.

Attached the screen shot.

For fiscal year I give the start date as july 2014 and for calender year I give the start date as Jan 2014

Now My fiscal year shows 2015 and months statrting from july 2014 to jun 2015
But my calender year shows 2015 ,but months from jan 2015 to only jun 2015..why does this not go up to Dec 2015.

Any help is appreciated.

Thanks,
Nithya

[MFGF]

Hi ,

I have my data file having the current Month - APR 2015.

I am creating a time dim and using the above column as input.

SO First I will create a Month level then create a drill down to this level , one being fiscal year and other being calender year.

Attached the screen shot.

For fiscal year I give the start date as july 2014 and for calender year I give the start date as Jan 2014

Now My fiscal year shows 2015 and months statrting from july 2014 to jun 2015
But my calender year shows 2015 ,but months from jan 2015 to only jun 2015..why does this not go up to Dec 2015.

Any help is appreciated.

Thanks,
Nithya

I'd guess that in the data you are reading, June 2015 is the last month you have data for?

MF.

[cognos05]

No April 2015 is the last month that is present.
But since I have calender year and month is APR 2015, I will like to shoe from jan 2015 to Dec 2015.

Is there any property to show that.

Thanks,
Nithya

[bdbits]

I never use the built-in time dim (mine is based on tables), which I think is what you are using here. But normally, Transformer will only generate categories when there are related facts. So I am surprised you see any dates beyond Apr 2015.

If your time dim is based on a table, you can force inclusion on the property sheet for that level.