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 email@example.com for further assistance. Reference the community FAQ to learn more about the community.
I have set up a heat map in WebFocus that graphs invoice $'s from an excel spreadsheet on a US map by state. When I put the cursor over each state, the correct $ amount is displayed, but the $ amount on the legend that is being displayed is incorrect. For example, when I place the cursor over Texas, it shows the invoice amount to be 517.1M (which is correct) and it is green in color, but the legend is showing the green to be 6B. Are we correct in thinking that 517.1M is 517,100,000 (or 517 million)? Shouldn't the legend be showing the green to be 600M? Has anyone ever run into this before? Is there something I am missing on this? We are using WebFocus 8.005. Thanks!This message has been edited. Last edited by: <Kathryn Henning>,
Lana, did you (or Advanced Graph Assistant) add this to the graph style: setY1LabelFormat(n) ? Depending on which n you choose, what you describe can occur. Read the "Graphics" manual for the different values you can use for setY1LabelFormat.
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
Thank you for your feedback on this issue. The setY1LabelFormat(n) was not set, so I tried setting it as you suggested. I tried different values for n - such as -3, -2... and nothing seemed to change. I'm not sure if I was doing something incorrect with this.
I ended up simply setting the setScaleMaxAuto(getY1Axis(),false) and giving it a max of 600M. That seems to give me what I was looking for. Thanks again for your help.
Ok, I'll try and step you through making that chart. I will use the Retail sample database as it has a table with some geographic data of the type that the cloropleth chart requires. It is also an HTML5 type chart so you'll need to use a browser that supports HTML5.
For the Retail sample data, you will need to be able to create the database and tables for the Retail sample (MS SQL server or MS Access only I think).
Assuming all is OK, go to the RS console (server:8121) and click on an application directory - I created a new one and called it WF_RETAIL.
Right click on this folder and select new / samples. From the list click on WebFOCUS - Retail Demo and then check the other options as necessary.
I'm assuming that you are using Dev Studio. Create a new procedure (using the GUI of course ) and then within that create a chart using the "Map" type with a source of WF_RETAIL (which is a cluster join). The left hand of the two maps is the one for cloropleth (hover over to see the tooltip), so select that one and a territory of US of A and the colour scale that you like (wear your sunglasses for the bottom one ).
Under Measures / Sales, double click Revenue, then under Dimensions / Customer / Customer / State / Attributes, double click "State,Code" to add it to the "Location axis". This will launch a dialog asking for the location type - in this case it is "State Abbreviation". Click OK and then run your procedure.
Now, how easy was that? I counted a total of 22 left mouse clicks in creating just the procedure (double click = 2 obviously )
Let me know how you get on.
In FOCUS since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2
WebFOCUS App Studio 8.2.06 standalone on Windows 10
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004
We don't have the Retail sample database so I tried it with data off our own. (the data includes the attributes Latitude and Longitude) But starting with the procedure, I can't find the chart type MAP. Do you know if this is a standard WF feature.
I'll find out the status of maps in InfoAssist and licensing.
Mark, regarding your WebFOCUS versions, the WebFOCUS Client and Developer Studio should be at the same release and can be lower than the Reporting Server but not higher. It is recommended that they all be at the same release. Since your version of Developer Studio (and possibly WebFOCUS Client) is higher, this may account for why you're not seeing the map icon. Please see: