Just to share my way on how to build a GeoMap with our existing MicroStrategy configuration:
1 1) “Big Flat Table Design Thinking” – To begin designing your own GeoMap dashboard, you need to prepare the required data input. A typical GeoMap will require the following attributes and metrics:
Attributes & Metrics
a) Country Name/Area Name
b) Country Code
c) Latitude
d) Longitude
e) Dimension of the Metrics
f) Metrics
Just to imagine the required data as a Big Flat Table as below:
|
Month
|
Country
|
Latitude
|
Longitude
|
Dimension of the Metrics |
Metrics
|
22 ) From the above, you may start building your Relational Database data model with the defined data definition:
3) After running the query in Oracle Hyperion, export the SQL script and paste on MicroStrategy Type a Query template:
44 ) As the Hyperion table doesn’t expose Longitude and latitude in the Country table, we work around by adding the country table in MicroStrategy (The longitude and latitude is in the MicroStrategy Country Table) and link it to the data set we imported from Hyperion SQL script. Generally we will choose to link by “Country Code” Field. In this case, I link by country name and it still working fine.
5 ) After the cube is created and saved, create a GeoMap dashboard as below
It's Very informative blog and useful article thank you for sharing with us , keep posting learn more about BI Tools<a href="https://onlineitguru.com/tableau-online-training-placement.html" title="Tableau Online Training | Tableau Online Course in India | Online IT Guru\” rel=\”nofollow\”>Tableau Online Training