Hi Ritesh,
If you take a look at the source file for this particular model, you'll see that the map is simply inserting the YTD data via a Row Insertion type.
For example ( / indicate cell breaks in between columns):
Region 1 / 123 / 456 / 789
Region 2 / 987 / 654 / 321
For the map's Source Data property, you would bind it to everything from "Region 1" to "321".
Set Insertion Type to Row
Bind Destination to a row of cells that you'd want the map component to insert to
Bring a Pie Chart to the canvas
Bind the Pie Chart's Source Data to the same range of cells that you bound the Map's Destination range to, minus the Region Name column.
When you Preview the model, selecting Region 1 should plug in 123, 456, 789 into each of the different slices, respectively. Likewise, the same behavior will occur when selecting Region 2 on the map.
In the posted model, it looks like the creator made a row of data for each state. Within each state, there's a section for YTD data, as well as Product Share percentages. He/She simply bound the map's Source Data to the entire block, and has it designed to insert into one row, which is read by the Pie Chart.
Here's the source file: http://resources.businessobjects.com/support/cx_present/samples/u.s%20visual%20sales%20model/source%...
Open that and click on the "Display1" tab. You can also click on each component and analyze the property sheets for each component and see how they interact with one another.
One thing to note about using the maps: In order for regions to be selectable, your source data's first column / row (depending on your insertion type) must match those that are defined in the Region Keys property.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.