Focal Point
Time Dimension Label to the left.

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/1461084022/m/930100872

October 27, 2009, 01:29 PM
malapejohn
Time Dimension Label to the left.
When in a PMF Report such as Rolling 5 Period the left hand side lists all the dimensions. For the Time Dimension is their a way we can rename it ? If not possible is their a way we can change the display only ? My customer would like it in French and states it will be an issue if it stays with the literal of "Time"



Thanx in advance, John


-PMF 5.1.2
-WebFOCUS 7.6.9 on Windows 2003 Server
-MSSQL Server
October 27, 2009, 04:46 PM
Bob Jude Ferrante
In the release notes for PMF it states:

The Time Dimension itself will continue to be called Time in 5.1.1, but that only
affects a very small number of places.

Because Time's name is actually used in code in the 5.1.n track, the dimension cannot be renamed.

Workaround: In the dim_nav.mas file, you can add the following line at the very bottom of the first segment:
 
DEFINE D00_DIMENSION_TYPE/A20 WITH D00_DT = IF (D00_DT EQ 'T') THEN 'Temps' ELSE D00_DIMENSION_TYPE ; $


This will change the displayed value on the tree to 'Temps' with no apparent ill side effects (I did test this).

Note it doesn't change the default name for Time anywhere else except on the Tree-based reports. So Analysis Designer and the Dimension Loader still list the dimension as "time" but I'm assuming this isn't a critical problem since it's not end-user-visible.

Thanks to Eric for the technique!


Bob Jude Ferrante
Director of Business and Development
WebFOCUS Performance Management
Bob_Ferrante@ibi.com
917-339-5105

I'll take any questions about PMF - business or technical - anytime!

October 27, 2009, 04:53 PM
Bob Jude Ferrante
Regarding changing the level names (e.g., 'Quarter,' 'Month,' or whatever you have Time set for), if you're using Time AutoGen you have to do a couple small mods to the DB values. These are documented in the Release Notes which are embedded in the PMF New Features doc for your convenience.

If you're using a Custom Time Dimension, you can rename the levels right there in the Dimension loader. It's only auto-generated Time that requires you to mod the DB.


Bob Jude Ferrante
Director of Business and Development
WebFOCUS Performance Management
Bob_Ferrante@ibi.com
917-339-5105

I'll take any questions about PMF - business or technical - anytime!

October 29, 2009, 03:59 PM
malapejohn
This label change is working well. Thanx great help!!

Merci


-PMF 5.1.2
-WebFOCUS 7.6.9 on Windows 2003 Server
-MSSQL Server
June 27, 2011, 01:52 PM
Daryl H.
Hi Bob,
Sorry new to this forum, but can you point me to that document? Thank you.

quote:
Originally posted by Bob Jude Ferrante:
Regarding changing the level names (e.g., 'Quarter,' 'Month,' or whatever you have Time set for), if you're using Time AutoGen you have to do a couple small mods to the DB values. These are documented in the Release Notes which are embedded in the PMF New Features doc for your convenience.

If you're using a Custom Time Dimension, you can rename the levels right there in the Dimension loader. It's only auto-generated Time that requires you to mod the DB.



Daryl Hechanova
Systems Analyst
Fidelity Investments

WebFOCUS 7.6
Linux for x64 64 bit, All Outputs
June 27, 2011, 02:04 PM
Bob Jude Ferrante
It is included with PMF in /approot/mainstreet/documentation/

thanks
bjf


Bob Jude Ferrante
Director of Business and Development
WebFOCUS Performance Management
Bob_Ferrante@ibi.com
917-339-5105

I'll take any questions about PMF - business or technical - anytime!

June 30, 2011, 08:30 AM
Daryl H.
Hi Bob,
I have a AutoGen Time Dimension and want to change the labeling of Month and Quarter on the "Dimension Tree"
Could you help me find that mod to the DB?

Thanks!

[QUOTE]Originally posted by Bob Jude Ferrante:
Regarding changing the level names (e.g., 'Quarter,' 'Month,' or whatever you have Time set for), if you're using Time AutoGen you have to do a couple small mods to the DB values. QUOTE]


Daryl Hechanova
Systems Analyst
Fidelity Investments

WebFOCUS 7.6
Linux for x64 64 bit, All Outputs
June 30, 2011, 10:43 AM
Michael Paul
Hi Daryl,

This is a fairly straight forward mod, but make sure to backup your database before attempting!

There are two tables that need to be updated:

DIMENSIONS_SOURCE - {find the levels that you wish to update for dimension type 'T' and modify them)
update DIMENSIONS_SOURCE SET DIMENSION_LEVEL_NAME = 'My Quarter' WHERE DIMENSION_SOURCE_ID = XX

DIMENSIONS_TYPE - {mark the dimension of time to be regenerated by marking the DIMENSION_VIEW_FLAG to Y}
update DIMENSIONS_TYPE set dimension_view_flag = 'Y' where dimension_type = 'T'

Log off PMF and log back in. You will be prompted that your system is out of sync. Click to resync your system and the new level names should be propagated throughout.

I hope this helps,
Mike