Fiscal years offsets

[collierd]

Hello

I am using Cognos v7.2

Within transformer I have a standard calendar year root within the date dimension.
This runs Year - Month - Day

How do I create the equivalent with a six month offset
Our financial year runs July to June

Thanks

Damian.

 

[jjb373]

collierd,

Since I do not have access to Transformer here, I am trying to remember the functionality it has...

Are you able to use functions when creating this?

If you can, you could use the add-months functions.

add-months (YourField(), 6)


-- JJB373 --

 

[almeids]

If you create your dimension using the date wizard, at one point it prompts you for the first day of a year - supplying a July date may do what you want.

 

[almeids]

I just took a peek in Transformer, the first day of year is a property of the drilldown (Time tab), so use the categories diagram to get at it if you are creating your dimension manually.