Use the redline tool: see the tutorial at /mapviewer/fsmc/tutorial/samples/redLine.html of your mapviewer deployment.
Or use the first (Long, Lat) and second (Long,Lat) to construct a line and display it as a feature-of-interest
e.g. see code below using shipments as an example
var theShipments = new Array();
var aShipment = new Object();
aShipment.id = 1;
aShipment.name = 'Six Sixty Center';
aShipment.value = 300.75;
aShipment.longitude = -122.39607;
aShipment.latitude = 37.7725;
theShipments = aShipment;
var lineFOI = null;
var lineFOITheme = new Array();
var numPoints = shipments.length;
var ordArray = new Array();
var totalValue = 0.0;
var shipmentIdList = "" ;
var xmlDef = null;
var lineStyle = null;
I will convert the Obiee result set into XML data set and feed it into mapviewer as datasource.
Based on the dataset the map will generated.
eg: I have created map with all the states in a country.
My Obiee rquest have all the state details, and the map will displayed for all the states.
when I am filtering based on 2 state values, then only those two states will be colored differently.That already did.
Now I want to connect between the cities I want using lines.
So that when I am doing filtering based on the new dataset the lines between the cities on the states only visible
because only that filtered dataset passed in.
The whole display a report result on a map stuff works on the premise that the report essentially contains
a LocationIdentifier followed by values of interest for that location.
Like a State name and year-to-date sales for that state.
In your case it sounds like you have Place1 and Place2 as the location ids.
So I'm not sure how to do this. Maybe others will have better suggestions.
Am assuming that this (i.e. what you want to do) is something like the following.
You have a obiee report which contains, lets say,
Origin Destination ValueOfInterest e.g.
DEL BLR 1,500,000
BLR BOM 11,475,000
etc and you want to a line between DEL-BLR, and BLR-BOM and use the valueOfInterest to color the line or show up in an info-window when the user clicks on the line.
If that is similar to your use case then it'll likely have to be in client side code.
Unless all possible city pairs are well-defined and limited.
Assuming they're too many possible pairs and you decide to use MVFOIs( i.e. client side code) then the report should actually be something like
Origin, XY_for_Origin, Destination, XY_for_Destination, ValueOfInterest, i.e. contain the X,Y for the cities too.
If the list of city pairs is not too large (say a million rows or less) you could create a table like
city_pair_id, city1, city2, line_between_the_two. e.g.
DEL_BLR, DEL, BLR, sdo_geometry(...) using a query like
select a.english_name||'_'||b.english_name city_pair_id,
a.english_name city1, b.english_name city2,
sdo_geometry(2002, a.geometry.sdo_srid, null,
b.geometry.sdo_point.x, b.geometry.sdo_point.y)) LineBetweenCities
from wom_poi_city_center a, wom_poi_city_center b
where a.iso_country_code='IND' and b.iso_country_code='IND' and
a.english_name <> b.english_name and rownum < 6