 |
|||||
|
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
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 TopicGo | Search | Notify | Tools |
| Breadcrumb values | Login/Join |
| Platinum Member |
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 | ||
|
| Master |
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! | |||
|
| Platinum Member |
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 | |||
|
| Master |
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! | |||
|
| Platinum Member |
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 | |||
|
| Platinum Member |
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 | |||
|
| Platinum Member |
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 | |||
|
| Master |
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! | |||
|
| Platinum Member |
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 | |||
|
| Master |
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! | |||
|
| Platinum Member |
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 | |||
|
| Master |
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! | |||
|
| Platinum Member |
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 | |||
|
| Master |
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! | |||
|
| Master |
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! | |||
|
| Powered by Social Strata | Page 1 2 |
 | Please Wait. Your request is being processed... |
Read-Only TopicCopyright © 1996-2020 Information Builders
| View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |