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.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] GEOGRAPHIC_ROLE not being applied?

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] GEOGRAPHIC_ROLE not being applied?
 Login/Join
 
DWaybright
Platinum Member
posted
We are testing to upgrade to 8.2.06 and trying to create maps using the new Designer, my state abbreviation field isn't being recognized. I have GEOGRAPHIC_ROLE=USSTATE_ABBR in the master file but when I run my map with that field as the location, I see a blank map and "51 Unknown" at the bottom. When I click on that it lists all the state abbreviations. I get that it might not like our abbreviation for Washington, DC, but it should recognize the other 50 since we use the official postal service abbreviations. What am I missing?

Thanks,
Deb

This message has been edited. Last edited by: DWaybright,


WebFOCUS 8.2.03 (production), 8.2.06 (testing)
AppStudio, InfoAssist
Windows, All Outputs
 
Posts: 183 | Location: Indiana | Registered: December 05, 2017Report This Post
BabakNYC
Virtuoso
posted Hide Post
Do you have the state associated with a country? Even though USSTATE_ABBR has a geographic role, when I try to map it in InfoAssist, I first right click and select Map As, State/Province which opens a dialogue that has me define what it depends on. In this case, the Geographic Role of State Depends on Geographic Role of Country which can be stored as either another Field or hard coded to say United States.

BTW, to avoid all of these extra clicks, just change the column name to US_STATE_ABBR and add a COUNTRY of United States to the table.

This message has been edited. Last edited by: BabakNYC,


WebFOCUS 8206, Unix, Windows
 
Posts: 1853 | Location: New York City | Registered: December 30, 2015Report This Post
DWaybright
Platinum Member
posted Hide Post
@BabakNYC
I tried changing it from USSTATE_ABBR to US_STATE_ABBR and it does have a country associated with it but that didn't help.
In InfoAssist I do get the popup window to choose the geographic role and set the country role, but I don't get that in Designer. None of it works. Frowner


WebFOCUS 8.2.03 (production), 8.2.06 (testing)
AppStudio, InfoAssist
Windows, All Outputs
 
Posts: 183 | Location: Indiana | Registered: December 05, 2017Report This Post
BabakNYC
Virtuoso
posted Hide Post
I just tried it in 8206.05 and US_STATE_ABBR worked in designer. Does your master have a business view? I have a BV and COUNTRY and STATE are in a geography dim.

Also, what gen of 82xx are you running? You may need to open a case with IB tech support.


WebFOCUS 8206, Unix, Windows
 
Posts: 1853 | Location: New York City | Registered: December 30, 2015Report This Post
DWaybright
Platinum Member
posted Hide Post
We have 8206.09 installed. We don't use Business Views.
I think you are correct about opening a case.
Thanks.


WebFOCUS 8.2.03 (production), 8.2.06 (testing)
AppStudio, InfoAssist
Windows, All Outputs
 
Posts: 183 | Location: Indiana | Registered: December 05, 2017Report This Post
BabakNYC
Virtuoso
posted Hide Post
I just tested it without a BV and it's not working. I believe a BV Hierarchy would be necessary in the Master file if you want to use Designer for now. Alternatively, you can use InfoAssist which as you mentioned will prompt you for the hierarchical relationship between Country and state.


WebFOCUS 8206, Unix, Windows
 
Posts: 1853 | Location: New York City | Registered: December 30, 2015Report This Post
DWaybright
Platinum Member
posted Hide Post
BabakNYC,
Thanks for testing that out. It will certainly inform our path moving forward.


WebFOCUS 8.2.03 (production), 8.2.06 (testing)
AppStudio, InfoAssist
Windows, All Outputs
 
Posts: 183 | Location: Indiana | Registered: December 05, 2017Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] GEOGRAPHIC_ROLE not being applied?

Copyright © 1996-2020 Information Builders