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. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at myibi@ibi.com and provide your corporate email address, company, and name.


Connect to myibi

Read-Only Read-Only Topic
Go
Search
Notify
Tools
30-CHAR LIMITATION
 Login/Join
 
Member
posted
Hi,

Is there any work-around for the below 30-char issue in PMF.
Assuming I have a Location dimension which has 4 hierarchy levels.
Level1 -> Country
Level2 -> State
Level3 -> Region
Level4 -> Branch

here Branch level contains data which is more than 30 char.
And I have a Measure "Sales" which uses this dimension.
I am facing data mismatch issue when dimension data(Branch) is greater than 30 char, as my database contains "Information Technology Outsourcing Center" where as PMF truncates this data automatically to 30 characters "Information Technology outsour".
one way is to truncate database value to 30-char and then compare, but I dont want to use this approach because my database has possible values like
"Information Technology Outsourcing Center - 1"
"Information Technology Outsourcing Center - 2"
which will again cause a mismatch issue.

any help is greatly appreciated.

Thanks in advance.

Ragards,
Keerthi


WebFOCUS 7.6
Windows, All Outputs
 
Posts: 21 | Registered: October 20, 2011Report This Post
Master
posted Hide Post
The simplest way to solve this is to abbreviate the level value. In your case for example, just using "IT" rather than "Information Technology" will give you the result you want. We don't hit the limit often and it's only really a problem when the level values are identical to 30 characters, such as yours is.

Another way to look at this is to think of your users... they aren't going to have a good time looking at the tiny differences between those two values:

Information Technology Outsourcing Center - 1

  • Information Technology Outsourcing Center - 2


  • IT Outsourcing Center 1

  • IT Outsourcing Center 2


  • SO... you get a friendlier dashboard.

    We deliberately set this 30 character limit on level values for *both* technical and practical reasons. At 4 levels per Dimension, you already have a Dimension path that maxes out at 124 characters; if you went to 16 levels it would be 495. So using more than 30 characters for a dimension level value is from a practical sense unreadable in a report or dashboard.

    Hope this is understandable and helps.
    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
    Guru
    posted Hide Post
    Hi Keerthi,

    I created a technique a while ago that might help with this situation:

    http://www.informationbuilders...opers/DescriptionPMF

    Cheers,

    Joey


    -WebFOCUS 8.2.01 on Windows
     
    Posts: 318 | Location: Los Angeles, CA | Registered: November 15, 2005Report This Post
    Member
    posted Hide Post
    I will have to take this discussion forward with our working group and decide on one of the best suitable ways as suggested by Bob.

    Thanks all for your help.


    WebFOCUS 7.6
    Windows, All Outputs
     
    Posts: 21 | Registered: October 20, 2011Report This Post
      Powered by Social Strata  

    Read-Only Read-Only Topic


    Copyright © 1996-2020 Information Builders