How to have control over hierarchy labels?

[halkosj]

We cannot figure out how to apply our own tags or labels to the dimension hierarchies. For example, for the "Time" dimension, transformer displays the Fiscal Year as "2008" and the Fiscal Quarter as "2008 Q 1".  We want these to be "FY2008" and "FY08 Q1", respectively.

How is this done?

[JGirl]

Hi,

Sounds like you've used the date wizard to build the time dimension.  If this is the case, you should be able to change the labels by double clicking on each level you wish to change.  This will open the level properties window.

Go to the Time tab, and click on the 'Modify Format' button.  In the Code: text box, type a suitable format here.

For the examples you gave below:
* For Fiscal Year change the format from YYYY to "FY"YYYY
* For Fiscal Quarter change the format from YYYY "Q" Q to "FY"YY "Q"Q

Hope this helps.

J

[halkosj]

Thats just what we wanted!  Thanx J !

[halkosj]

Oops - well, it works for Year and Quarter, but not for Month.

In the format specification, for Year and Quarter, "YYYY" is converted to the Fiscal Year.  For the Month level, "YYYY" is converted to a calendar year - how do we get a consistent display of Fiscal Year for all levels?