Community
Search Options
Search Options
Log in
Skip to main content (Press Enter).
Sign in
Skip auxiliary navigation (Press Enter).
Business Analytics
Topic areas
Cognos Analytics
Cognos Controller
Global Business Analytics
Planning Analytics
User groups
Events
TechXchange Day
IBM TechXchange Conference
Upcoming Business Analytics Events
IBM TechXchange Webinars
All IBM TechXchange Community Events
Participate
Community Manager's Welcome
Gamification Program
Post to Forum
Share a Resource
Share Your Expertise
Blogging on the Community
Connect with Business Analytics Users
All IBM TechXchange Community Users
Resources
IBM TechXchange Group
Data and AI Learning
IBM Champions
IBM Cloud Support
IBM Documentation
IBM Support
IBM Support 101
IBM Technology Zone
IBM Training
TechXchange Day
Marketplace
Marketplace
Business Analytics
Connect, learn and share with over 10000 users across the IBM Business Analytics.
Ask a question
Join us for IBM TechXchange Day: AI and Automation
Skip main navigation (Press Enter).
Toggle navigation
Search Options
Cognos Analytics
View Only
Group Home
Discussion
14.4K
Library
640
Blogs
689
Events
1
Members
5.1K
Share
VIDEO: How to use Maps in #Cognos Analytics Dashboards (11.0.6)
By
WILL BRANNEY
posted
Wed May 24, 2017 04:13 AM
0
Like
This blog and video is a step by step guide on how to use Maps in Cognos Analytics Dashboards
Video
In the video we will show you:
How to Model your data so the data is recognised as Geospatial.
How to use some of the key map features.
How to use the ‘Refine Regions’ data slot.
Environment
Cognos Analytics 11.0.6 with
Interim Fix 1
(This contains important updates to the mapping components)
The attached data file was used for the following examples:
Map Data
How to model your data so it is recognized as Geospatial
Step 1 - Upload the file
Save the attached data file map_data.xls locally. Open Cognos Analytics and go to
‘Upload Files’
and upload the file to your Cognos Analytics Server.
Step 2 - Create a Data Module from the uploaded file
Click on ‘
New’
then ‘
Data Module’
. Click ‘
Uploaded Files’
and search for your uploaded file. Click ‘
start’
then drag the file to the new module.
Expand the uploaded file and click on the ellipsis next to ‘
County’
and then select ‘
In the ‘
Represents’
drop-down box select ‘
Geographic Location’
and then select ‘
County’
.
Optional Step
: In the video example I limit the data to
California
in my data module. To do this Click the ellipsis next to ‘
State’
and select ‘
filter’.
Click the checkbox next to
‘California’
and click
‘Apply ‘.
Alternatively, you can use the entire file but please note this will be truncated to 3,000 rows which is the current data limit for maps
Save the data module.
How to use the Refine Regions data slot
Using the Data Module from the previous steps, drag ‘
County’
to
‘Regions’
and
‘Measure’
to ‘
Region Color’
.
You will see an
‘Ambiguous regions’
data warning in the top right of the widget. This means the listed counties will not be mapped. E.g.
Holmes County
is in both
Mississippi
and
Florida
so the widget will need more information to map successfully.
To resolve the ambiguity, drag
‘State’
to the
‘Refine Regions’
data slot and this will allow the Widget to determine exactly which County needs to be mapped. (
Please note - when adding a refinement region always try to add the applicable next level parent
.)
This will produce the following Map:
Please visit the IBM Cognos Analytics channel on
YouTube
.
#11.0.6
#CognosAnalytics
#CognosAnalyticswithWatson
#cognosanalyticssupport
#dashboarding
#Education
#ExpertPost
#GeneralInformation
#GettingStarted
#mapbox
#mapping
#Resources
#Support
#Tutorials
#Video
0 comments
40 views
Permalink
IBM Community Home
Browse
Discussions
Resources
Groups
Events
IBM TechXchange Conference 2023
IBM Community Webinars
All IBM Community Events
Participate
Gamification Program
Community Manager's Welcome
Post to Forum
Share a Resource
Blogging on the Community
All IBM Community Users
Resources
Community Front Porch
IBM Champions
IBM Cloud Support
IBM Documentation
IBM Support
IBM Technology Zone
IBM Training
Marketplace
Marketplace
Business Analytics
Topic areas
Cognos Analytics
Cognos Controller
Global Business Analytics
Planning Analytics
User groups
Events
TechXchange Day
IBM TechXchange Conference
Upcoming Business Analytics Events
IBM TechXchange Webinars
All IBM TechXchange Community Events
Participate
Community Manager's Welcome
Gamification Program
Post to Forum
Share a Resource
Share Your Expertise
Blogging on the Community
Connect with Business Analytics Users
All IBM TechXchange Community Users
Resources
IBM TechXchange Group
Data and AI Learning
IBM Champions
IBM Cloud Support
IBM Documentation
IBM Support
IBM Support 101
IBM Technology Zone
IBM Training
TechXchange Day
Marketplace
Marketplace
Powered by Higher Logic