Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Page 1 2 

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Breadcrumb values
 Login/Join
 
Platinum Member
posted
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
 
Posts: 127 | Registered: March 02, 2009Report This Post
Master
posted Hide Post
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!

 
Posts: 919 | Registered: March 26, 2003Report This Post
Platinum Member
posted Hide Post
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
 
Posts: 127 | Registered: March 02, 2009Report This Post
Master
posted Hide Post
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!

 
Posts: 919 | Registered: March 26, 2003Report This Post
Platinum Member
posted Hide Post
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
 
Posts: 127 | Registered: March 02, 2009Report This Post
Platinum Member
posted Hide Post
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
 
Posts: 127 | Registered: March 02, 2009Report This Post
Platinum Member
posted Hide Post
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
 
Posts: 127 | Registered: March 02, 2009Report This Post
Master
posted Hide Post
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!

 
Posts: 919 | Registered: March 26, 2003Report This Post
Platinum Member
posted Hide Post
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
 
Posts: 127 | Registered: March 02, 2009Report This Post
Master
posted Hide Post
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!

 
Posts: 919 | Registered: March 26, 2003Report This Post
Platinum Member
posted Hide Post
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
 
Posts: 127 | Registered: March 02, 2009Report This Post
Master
posted Hide Post
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!

 
Posts: 919 | Registered: March 26, 2003Report This Post
Platinum Member
posted Hide Post
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
 
Posts: 127 | Registered: March 02, 2009Report This Post
Master
posted Hide Post
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!

 
Posts: 919 | Registered: March 26, 2003Report This Post
Master
posted Hide Post
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!

 
Posts: 919 | Registered: March 26, 2003Report This Post
  Powered by Social Strata Page 1 2  

Read-Only Read-Only Topic


Copyright © 1996-2020 Information Builders