Focal Point
Breadcrumb values

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

October 08, 2009, 11:25 AM
malapejohn
Breadcrumb values
Hello Im working on a PMF dashboard in French.
I noticed for the Prior vs Current report the breadcrumb value for
Période is Prior vs Current instead of Antérieures contre Actuelles

I noticed their is a fex called time_ranges_get fex. This reads the table and does a -READ on the save file to get all the time values.
Is the best way to change this via customization on my end? An example would be decoding the abbreviation value and storing 'Antérieures contre Actuelles' in the &TIME_RANGE_NAME variable?

Your thoughts

Merci en avance.


-PMF 5.1.2
-WebFOCUS 7.6.9 on Windows 2003 Server
-MSSQL Server
October 08, 2009, 12:32 PM
Bob Jude Ferrante
You can check the Time Range name in the Time Ranges panel on the Manage tab. If it's in English, rename it so it's proper. We'll confirm a switch of language properly renames this particular Time Range - we know it's working generally.

thanks


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 08, 2009, 06:50 PM
malapejohn
Hi Bob, I am troubleshooting the environment and have more questions.

The TIME_RANGES table, on the datamart I am using contains data in English, now on a different datamart , let's say pmf_datamart1 the TIME_RANGES table contains data in french.

Now questions, when does the TIME_RANGES table get populated? At installation of PMF? At the load of the time dimension? When I first logged on to PMF I did via the WF BID.

The ibi_wf_language was set to English(en), I logged onto PMF and began the load process of the time dimension.

Could this affect the entries in the TIME_RANGES table?

Merci.
John


-PMF 5.1.2
-WebFOCUS 7.6.9 on Windows 2003 Server
-MSSQL Server
October 09, 2009, 09:04 AM
Bob Jude Ferrante
How it works: When you switch to another language, it causes the PMF application to update all "factory-set" string values in your PMF production DB from the official translation tables (which are CSV files). If you switched PMF to English you'd have English values in the table. If you switched it back to French you'd have French values. There is only one active language at a time for these values. It may change in the future; this strategy was best for reporting performance.

PMF will not of course magically translate your Strategy objects, or any custom objects you added, including Time Ranges, nor replace any items you might have deleted.

So if you were contemplating editing the FOCEXEC to change language, that is not recommended. That would hardcode the strings you were using and disable auto language switching.


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 09, 2009, 09:29 AM
malapejohn
Thanks Bob.

I am and will not be hardcoding anything on the language in the focexec's.

I understand the flipping of the strings. What I need to get to the bottom is my breadcrumbs are appearing in English. Breadcrumbs read the TIME_RANGES MSSQL Server table. Those entries are in english.

In conclusion TIME_RANGES MSSQL table has entries in English how can I get them to French?

Example Rolling 5 Period should be - En continu sur 5 périodes


-PMF 5.1.2
-WebFOCUS 7.6.9 on Windows 2003 Server
-MSSQL Server
October 09, 2009, 09:36 AM
malapejohn
I got it!!!
In the Manage Tab, the display language was set to 'en' , then you change it to 'fr', then I reloaded the time dimension and the table is in its proper language.

Thanx Bob


-PMF 5.1.2
-WebFOCUS 7.6.9 on Windows 2003 Server
-MSSQL Server
October 13, 2009, 02:30 PM
malapejohn
I have another question on language.

When drilling on measure details the breadcrumbs create values of
Year
Quarter
Month

Can these string values be modified into french? Thanx


-PMF 5.1.2
-WebFOCUS 7.6.9 on Windows 2003 Server
-MSSQL Server
October 13, 2009, 02:42 PM
Bob Jude Ferrante
Only way to change these is to change them in the DB. Carefully.
There's doc on this - see the Release Notes.


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 13, 2009, 03:54 PM
malapejohn
First and foremost I will be backing up the database. Next I have isolated the TIME dimension table.


I have to perform an update on the following.
DIMENSION_LEVEL_NAME based on the dimension level value. Their I can change Year - Annee

Your thoughts.


-PMF 5.1.2
-WebFOCUS 7.6.9 on Windows 2003 Server
-MSSQL Server
October 13, 2009, 04:03 PM
Bob Jude Ferrante
It's the dimensions_source table where the level value names.

The info you need is in ibi\apps\mainstreet\documentation\PMF Rls Notes.pdf in the section "Additional Post-Switch Modifications – Time Dimension Levels"

thanks


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 16, 2009, 09:55 AM
malapejohn
Ok, a couple of lessons learned here.

When doing a backup , test to see if the restore works. I made the changes to the dimensions source table. My measures worked fine in the presentation. Only issue is all the measure loaders started to fail that contained Year Month.

1. Check the restore of the backup
2. Do a proper regression testing of the loads and other functions

After the abends I did a view source
What I saw in the source was DEFINE FILE ADD statement that tried to create a field called ANNÉÉ / ??? and MOIS /??? , the measure loader would always abend stating a format specification error.

Bob was their something that I missed after updating the dimensions_source table ?


I restored from a previous backup redid some work and all is well.


-PMF 5.1.2
-WebFOCUS 7.6.9 on Windows 2003 Server
-MSSQL Server
October 16, 2009, 10:23 AM
Bob Jude Ferrante
Are they using custom time? If they are, then you'd have to take that into account. Apart from that nothing jumps out at me.

Let me know if you discover anything so we can share it here.


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 16, 2009, 12:09 PM
malapejohn
No they are not using custom time. We reverted back to English for Year , Quarter, Month.
Now I question if the special acccent character in French could be causing a problem, ANNÉE

We will be testing it some more and I will upload the code when I can.

Thanx.


-PMF 5.1.2
-WebFOCUS 7.6.9 on Windows 2003 Server
-MSSQL Server
October 16, 2009, 12:34 PM
Bob Jude Ferrante
It could cause a problem if a setting for the DB is not set to allow its fields to have international characters, perhaps? Depends on the DB etc.


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 16, 2009, 12:35 PM
Bob Jude Ferrante
Also check the collation.


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!