Transcript Composite Applications: Google Maps and Active Reports

Enterprise Mashups: WebFOCUS for Google Maps
Adam Lotrowski
Copyright 2008, Information Builders. Slide 1
Why Google Maps?
The Mashup trend!!!!!
Copyright 2008, Information Builders. Slide 2
What is a Mashup?
 Multiple online resources that when
integrated creates a new tool.
 Data is the glue that pieces separate
independent sources together
Copyright 2008, Information Builders. Slide 3
How Mashups Work
 Data Provider
 RSS Feeds
 Databases
Data
Service
 Service Provider
Browser
 Communicate via APIs
 Flexibility with JavaScript
 Web Browser
Mashup
 Cross platform
Copyright 2008, Information Builders. Slide 4
Past, Present and Future Trends
 Not a new term
 Increased interest over the last year
 3,000 Mashup applications, 500 in the
last 6 months (ProgrammableWeb, May 2008)
 By 2010 Mashups will be the
dominant model for creating
composite enterprise applications
(Gartner Research 2007)
 2008 Top 10 Strategic Technology
(Gartner Research 2007)
 Convergence of Portal and
Mashup technologies
Copyright 2008, Information Builders. Slide 5
What is a Composite Application?
 Software that utilizes two distinct services in order to
create a new service that otherwise would not exist
 Composed of enterprise data and processes
 Underutilizes publically accessible information and
architecture
Copyright 2008, Information Builders. Slide 6
Composite Application + Mashup = Enterprise Mashup
 Data and Applications
seamlessly bind together
 Data transformed into
information
 Widespread information
understanding
 Logical progression of the
Mashup evolution
Copyright 2008, Information Builders. Slide 7
Copyright 2008, Information Builders. Slide 8
Why Google Maps?
Why we started with MAPS!!!!!
Copyright 2008, Information Builders. Slide 9
Geography is Knowledge
 Geographic data is about visually understanding relationships in
information
 85% of corporate data can be tied to geography
 Leverage strategic value by identifying
trends and predict outcomes
 Segments of information analytically
tied to the physical world
Copyright 2008, Information Builders. Slide 10
Providing Geographic Awareness
 Decentralizes analytics
 Information for the masses
 Creates insight and knowledge
 User centric reporting
 Leads to innovation
Copyright 2008, Information Builders. Slide 11
Limitations
 Geocoded data
 http://geocoder.us/
 http://www.ontok.com/geocode/jsapi
 Technical skills required
 Effective visualizations required
Copyright 2008, Information Builders. Slide 12
Why Google Maps?
WebFOCUS For Google Maps Advantages!!!!!
Copyright 2008, Information Builders. Slide 13
Advantages Using WebFOCUS for Google Maps
 Understand complex and abstract data with visual cues
 Overlay maps with BI data and reports
 Geographic insight to business trends and opportunities
 Develop without any coding
 Quick turnaround
Copyright 2008, Information Builders. Slide 14
WebFOCUS for Google Maps
 Load Google Maps using WebFOCUS
Procedures
 Enhances analysis intuitively
Good
 Promotes rapid application
development
 Free to use
Fast
Cheap
Copyright 2008, Information Builders. Slide 15
WebFOCUS for Google Maps Features
 GUI-driven development
 Dashboard integration
 Conditional map styling
 Interactive map navigation
 Navigate Google Maps
 Robust selection tools
 Parameter prompting
 Advanced application
customization
Copyright 2008, Information Builders. Slide 16
WebFOCUS GIS: ESRI vs. Google Maps
Feature
ESRI
Google Maps
Layer specific selection
Point Layers
Line Layers
Polygon Layers
Map to Report Drill Down
Report to Map Drill Down
Data Security
Calculate Distance in a Report
Internet Connection Required
User Familiarity
Time to Develop
Copyright 2008, Information Builders. Slide 17
Requirements

WebFOCUS 7.6.5
Google Maps API Key

Geocoded data
Copyright 2008, Information Builders. Slide 18
Using WebFOCUS for Google Maps
A Step By Step Illustration
Copyright 2008, Information Builders. Slide 19
 Navigate or zoom in and
out
 Different map types
 Hover the mouse over a
Marker to see the tooltip
Copyright 2008, Information Builders. Slide 20

Select points individually

Use the mouse to draw an
area around a set of points

Distinctly draw, in free-hand
fashion, any geometrical
area imagined
Copyright 2008, Information Builders. Slide 21
Move selection shape
Copyright 2008, Information Builders. Slide 22
 Click on a Marker to
drill down to a report
filtered by values
selected
Copyright 2008, Information Builders. Slide 23
 Zoom and navigate to
the selected location
Copyright 2008, Information Builders. Slide 24
 Zoom and navigate to
the selected address
Copyright 2008, Information Builders. Slide 25
WebFOCUS for Google Maps Development
Copyright 2008, Information Builders. Slide 26
Insert > Google Map
Copyright 2008, Information Builders. Slide 27
Draw Google Map
Copyright 2008, Information Builders. Slide 28
 Set default center point
 Configure default map settings
 Assign map drill downs
Copyright 2008, Information Builders. Slide 29
 Bind multiple layers
 Assign images and tooltips
 Assign Marker drill downs
Copyright 2008, Information Builders. Slide 30
WebFOCUS for Google Maps Procedures
Copyright 2008, Information Builders. Slide 31
Populate a Google Map with WebFOCUS
 Latitude and Longitude coordinates
 MARKER column for logical grouping of map markers
 Any additional fields to be designated as tooltip
Copyright 2008, Information Builders. Slide 32
Set Default Center for Google Maps
 Pass one set of Latitude
and Longitude
coordinates
Copyright 2008, Information Builders. Slide 33
Drill Down to Google Maps
Parameter
Name
q
Parameter Value
Address
OR
lat
Latitude value
lng
Longitude value
Copyright 2008, Information Builders. Slide 34
Navigate Google Maps
JavaScript
Function
panToPoint
Parameter Value
Latitude value
Longitude value
Unique Identifier for
the targeted Google
Map
Zoom Level (0 and
18)
panToAddress
Country,
State/Region,
Address and/or
Zip/Region code
Unique Identifier for
the targeted Google
Map
Zoom Level (0 and
18)
Copyright 2008, Information Builders. Slide 35
Drill Down to WebFOCUS Procedure
 Prompt for the amper
variable:
&COORDINATES
Copyright 2008, Information Builders. Slide 36
Product Roadmap: WebFOCUS for Google Maps
Q2, 2008

Product Launch
Q3, 2008
Q4,2008

Integrated Help

Cluster Distance

Radius Distance

Information
Layers

NLS Support

Layer & Marker
Visibility
2009

Active Report
Dynamic
Integration
Copyright 2008, Information Builders. Slide 37
Advanced Customization
** Provided Matthew Lerner
Copyright 2008, Information Builders. Slide 38
Learn More …
WebFOCUS for Google Maps: Rapid Mashup Development
By:
Matthew Lerner
Day:
Time:
Wednesday
8:30-9:30am
Where: DELTA D
Type: HANDS ON LAB 2
Copyright 2008, Information Builders. Slide 39
Thank you!
Copyright 2008, Information Builders. Slide 40