Mapping makes understanding and visualizing data much easier, much easier than showing it on an Excel sheet.I have always loved this component of Xcelsius, Map component in Xcelsius provides probably the easiest way to plot data on a Map.Map Component is probably not as straightforward to use as some of the other components but, once mastered, it lets you create a whole range of maps. Let’s get started and make this particular dashboard.
- 1. Preparing the Spread Sheet: This is the most important part in map based dashboard creation. We need to organize the data in our sheet properly before we jump onto the dashboard creation. Xcelsius comes with an Excel sheet ‘MapRegion.xls’ (Find it here: ‘C:\Program Files\Business Objects\Xcelsius\assets\samples\User Guide Samples’ or you can download it from here) which makes it easy for the user to connect the Data to a subdivision (subdivision can be states in a countries Map or Countries on a Continent’s map etc) on the map
Each subdivision in the map has a defined Region Code (Example given below). When Source Data, Display Data, or
- 2. Map has two Insertion types (i.e. two ways to subset data): Row and Column (Yes, ‘Filtered Rows’ is not available).
This entry was posted on Jun 8, 2010 at 10:10 PM and is filed under Xcelsius, Xcelsius-Basics, Xcelsius-Map Alerts, Xcelsius-Map Component, Xcelsius-Training, Xcelsius-Tutorial. You can follow any responses to this entry through the RSS 2.0. You can leave a response.