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     [CASE OPENED] ibiDataLayer for BubbleMap

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CASE OPENED] ibiDataLayer for BubbleMap
 Login/Join
 
Guru
posted
GM,
Trying to show 3 geographic layers using this bubble map chrolopleth map. But only last layer shows in the map for some reason.
Not sure if there is any syntax I'm missing here.. Please advise!
Attaching a screenshot. I was hoping to see 2 dots on each end of the line to represent my start and end points.
 -SET &ECHO=ALL;
DEFINE FILE HPOINTS
STARTPOINT/A200 = GIS_POINT('4326', OFFENDER1_LONG, OFFENDER1_LAT);
ENDPOINT/A200 = GIS_POINT('4326', OFFENDER2_LONG, OFFENDER2_LAT);
CONNECTION_LINE/TX80 (GEOGRAPHIC_ROLE=GEOMETRY_LINE) =   GIS_LINE(STARTPOINT, ENDPOINT);
END


GRAPH FILE HPOINTS
 PRINT
   OFFENDER1
   OFFENDER2
   DISTANCE_FT TIMESLOT 
WHERE OFFENDER1 EQ 488338

 ON TABLE PCHOLD FORMAT JSCHART
 ON TABLE SET LOOKGRAPH BUBBLEMAP
 ON TABLE SET EMBEDHEADING ON
 ON TABLE SET AUTOFIT ON
 ON TABLE SET STYLE *
  TYPE=REPORT, TITLETEXT='Map', PAGESIZE=E, CHART-LOOK=com.esri.map, $
  TYPE=DATA, COLUMN=N1, /*START_STATION_NAME*/
   BUCKET=tooltip, $
  TYPE=DATA, COLUMN=N2, /*END_STATION_NAME*/
   BUCKET=tooltip, $
  TYPE=DATA, COLUMN=N3, /*DISTANCE*/
   BUCKET=tooltip, $
   TYPE=DATA, COLUMN=N4, /*TIME*/
   BUCKET=tooltip, $
  *GRAPH_JS_FINAL
"legend": {"visible": true},
"extensions" : { "com.esri.map" :
  { 
  	"scalebar" :
	{
	    "scalebarUnit": "dual",
	    "attachTo" : "bottom-left"
  	},
  "baseMapInfo": {
       "drawBasemapControl" : true,
       "showArcGISBasemaps" : true,
            "customBaseMaps" : [
            {"ibiBaseLayer" : "gray"}
        ]
   },
  "overlayLayers": 
  [{ 
  "ibiDataLayer": {"map-geometry" :  {"map_by_field" : "STARTPOINT"}}, "title" : "Points1"},
{"ibiDataLayer": {"map-geometry" :  {"map_by_field" : "ENDPOINT"}}, "title" : "Points2"},
{"ibiDataLayer": {"map-geometry" :  {"map_by_field" : "CONNECTION_LINE"}}, "title" : "Lines"}] 
  }, 
"introAnimation": "{\"enabled\":false}"
}

  *END
 ENDSTYLE
 HEADING
  "Chart Geometry Lines and points"
END
 

This message has been edited. Last edited by: FP Mod Chuck,


-********************
Sandbox: 8206.10
Dev: 8201M
Prod:8009
-********************
 
Posts: 289 | Location: Houston,TX | Registered: June 11, 2004Report This Post
Virtuoso
posted Hide Post
Vaayu

Which map layers are you wanting to use? You have to have the appropriate JSON files definied to WebFOCUS when you make the selection.


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 2127 | Location: Customer Support | Registered: April 12, 2005Report This Post
Guru
posted Hide Post
The Define fields are JSON formatted as shown in this
example
Only problem is it only shows 1 layer, I need to show all 3 Fields as layers. Pls let me know
 
Posts: 289 | Location: Houston,TX | Registered: June 11, 2004Report This Post
Virtuoso
posted Hide Post
Vaayu

I don't have experience with this, hopefully someone else can chime in...


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 2127 | Location: Customer Support | Registered: April 12, 2005Report This Post
Expert
posted Hide Post
Like Chuck, I've no experience of this map but building an example on WF 8.2.01 against WF_RETAIL, I can generate a map using the GIS_LINE link that you supplied.

Once the map is generated, I only see one dataset within the scripting section of the output, and it is for the last "layer" specified.

Setting a single layer to STARTPOINT or ENDPOINT and I see the relative points Ok, so I can only assume that the chart is restricted to a single layer - despite what is implied by the "layer" control presented in the top right.

I would suggest approaching IB Tech Support to ask the question.

T



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, 2004Report This Post
Expert
posted Hide Post
Just in case anyone else is intrigued about this map, then you can try the following code against the WF_RETAIL table.

In 8.2.01 I only see a single point when using STARTPOINT (because the points are identical) or CONNECTION_LINE.

I also had to change the TX80 format for CONNECTION_LINE to alpha as the text format caused an error.

TABLE FILE wf_retail
  SUM COMPUTE STARTPOINT/A200 = GIS_POINT('4326', VENDOR_LONGITUDE, VENDOR_LATITUDE);
      COMPUTE ENDPOINT/A200 = GIS_POINT('4326', CITY_LONGITUDE, CITY_LATITUDE);
      COMPUTE CONNECTION_LINE/A300 (GEOGRAPHIC_ROLE=GEOMETRY_LINE) = GIS_LINE(STARTPOINT, ENDPOINT);
      COMPUTE DISTANCE/P33.11 TITLE 'Distance' = GIS_DISTANCE(STARTPOINT, ENDPOINT);
   BY COUNTRY_NAME
   BY CITY_NAME
   BY VENDOR_NAME
WHERE RECORDLIMIT EQ 10
WHERE VENDOR_NAME EQ 'Sony'
-*WHERE COUNTRY_NAME EQ 'United States'
-*WHERE CITY_NAME EQ 'New York'
ON TABLE SET ASNAMES ON
ON TABLE SET HOLDLIST PRINTONLY
ON TABLE HOLD AS TEMPHLD1
END
-RUN
-*-EXIT

GRAPH FILE TEMPHLD1 
 PRINT
   COUNTRY_NAME
   CITY_NAME
   VENDOR_NAME
 ON TABLE PCHOLD FORMAT JSCHART 
 ON TABLE SET LOOKGRAPH BUBBLEMAP 
 ON TABLE SET EMBEDHEADING ON 
 ON TABLE SET AUTOFIT ON 
 ON TABLE SET STYLE * 
  TYPE=REPORT, TITLETEXT='Map', PAGESIZE=E, CHART-LOOK=com.esri.map, $ 
  TYPE=DATA, COLUMN=N1, /*COUNTRY_NAME*/  
       BUCKET=tooltip, $
  TYPE=DATA, COLUMN=N2, /*CITY_NAME*/
       BUCKET=tooltip, $
  TYPE=DATA, COLUMN=N3, /*VENDOR_NAME*/
       BUCKET=tooltip, $
*GRAPH_JS_FINAL 
"legend": {"visible": true}, 
"extensions" : { "com.esri.map" : 
  { "scalebar" : 
{ 
    "scalebarUnit": "dual", 
    "attachTo" : "bottom-left" 
  }, 
  "baseMapInfo": { 
       "drawBasemapControl" : false, 
       "showArcGISBasemaps" : false, 
            "customBaseMaps" : [ 
            {"ibiBaseLayer" : "dark-gray"} 
        ] 
   }, 
  "overlayLayers": 
  [
  {"ibiDataLayer": {"map-geometry" :  {"map_by_field" : "CONNECTION_LINE"}}, "title" : "Chart"}
  ] 
  }, 
"introAnimation": "{\"enabled\":false}" 
} 
*END 
ENDSTYLE 
HEADING 
  "Chart Geometry Lines" 
END 


BTW, don't try this with a large number of output values! I found a limit of 10 was fine.

T



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, 2004Report This Post
Guru
posted Hide Post
quote:
TABLE FILE wf_retail
SUM COMPUTE STARTPOINT/A200 = GIS_POINT('4326', VENDOR_LONGITUDE, VENDOR_LATITUDE);
COMPUTE ENDPOINT/A200 = GIS_POINT('4326', CITY_LONGITUDE, CITY_LATITUDE);
COMPUTE CONNECTION_LINE/A300 (GEOGRAPHIC_ROLE=GEOMETRY_LINE) = GIS_LINE(STARTPOINT, ENDPOINT);
COMPUTE DISTANCE/P33.11 TITLE 'Distance' = GIS_DISTANCE(STARTPOINT, ENDPOINT);
BY COUNTRY_NAME
BY CITY_NAME
BY VENDOR_NAME
WHERE RECORDLIMIT EQ 10
WHERE VENDOR_NAME EQ 'Sony'
-*WHERE COUNTRY_NAME EQ 'United States'
-*WHERE CITY_NAME EQ 'New York'
ON TABLE SET ASNAMES ON
ON TABLE SET HOLDLIST PRINTONLY
ON TABLE HOLD AS TEMPHLD1
END
-RUN
-*-EXIT

GRAPH FILE TEMPHLD1
PRINT
COUNTRY_NAME
CITY_NAME
VENDOR_NAME
ON TABLE PCHOLD FORMAT JSCHART
ON TABLE SET LOOKGRAPH BUBBLEMAP
ON TABLE SET EMBEDHEADING ON
ON TABLE SET AUTOFIT ON
ON TABLE SET STYLE *
TYPE=REPORT, TITLETEXT='Map', PAGESIZE=E, CHART-LOOK=com.esri.map, $
TYPE=DATA, COLUMN=N1, /*COUNTRY_NAME*/
BUCKET=tooltip, $
TYPE=DATA, COLUMN=N2, /*CITY_NAME*/
BUCKET=tooltip, $
TYPE=DATA, COLUMN=N3, /*VENDOR_NAME*/
BUCKET=tooltip, $
*GRAPH_JS_FINAL
"legend": {"visible": true},
"extensions" : { "com.esri.map" :
{ "scalebar" :
{
"scalebarUnit": "dual",
"attachTo" : "bottom-left"
},
"baseMapInfo": {
"drawBasemapControl" : false,
"showArcGISBasemaps" : false,
"customBaseMaps" : [
{"ibiBaseLayer" : "dark-gray"}
]
},
"overlayLayers":
[
{"ibiDataLayer": {"map-geometry" : {"map_by_field" : "CONNECTION_LINE"}}, "title" : "Chart"}
]
},
"introAnimation": "{\"enabled\":false}"
}
*END
ENDSTYLE
HEADING
"Chart Geometry Lines"
END

Thank you all. I'm opening a case regarding multi-layer support.

Thanks as always!
 
Posts: 289 | Location: Houston,TX | Registered: June 11, 2004Report This Post
Guru
posted Hide Post
I think I saw in the documentation somewhere, that it only supports 1 map layer in the lightweight map support.


Webfocus 8
Windows, Linux
 
Posts: 258 | Location: Palm Coast, FL | Registered: February 05, 2010Report This Post
Guru
posted Hide Post
Thank you Mike,
I have a case open to make sure.
 
Posts: 289 | Location: Houston,TX | Registered: June 11, 2004Report This Post
Guru
posted Hide Post
This was the response on the case

Map charts do not have support for multiple layers currently - as you say, there is a limit of one layer. If you wish to create a map using multiple layers, you would need to use an option such as an ESRI map on an HTML page, which can have multiple distinct layers with their own settings.

In other words "no can't do"
 
Posts: 289 | Location: Houston,TX | Registered: June 11, 2004Report This Post
Guru
posted Hide Post
quote:
Originally posted by vaayu:
This was the response on the case

Map charts do not have support for multiple layers currently - as you say, there is a limit of one layer. If you wish to create a map using multiple layers, you would need to use an option such as an ESRI map on an HTML page, which can have multiple distinct layers with their own settings.

In other words "no can't do"


-********************
Sandbox: 8206.10
Dev: 8201M
Prod:8009
-********************
 
Posts: 289 | Location: Houston,TX | Registered: June 11, 2004Report 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     [CASE OPENED] ibiDataLayer for BubbleMap

Copyright © 1996-2020 Information Builders