US MAP and a Heat Map and Cognos Reports or Workspace Advanced

[gosoccer]

Hi everyone,
Here is something fun to do with Cognos. :) :) :o

Does any body knows a way to use a US MAP I guess using the MAPS option of Report Author, to come up with a report.
The different colors present different Total Numbers of Population per State?

Please see attached,

Thx in advance for your time.

[MFGF]

Hi everyone,
Here is something fun to do with Cognos. :) :) :o

Does any body knows a way to use a US MAP I guess using the MAPS option of Report Author, to come up with a report.
The different colors present different Total Numbers of Population per State?

Please see attached,

Thx in advance for your time.

Hi,

What part are you struggling with? Maps are coloured based on a measure by default - you simply need to redefine the three "standard" colours in the palette and add extra variants for the ranges you desire. As long as you have the relevant data (ie states and population figures) it should be easy.

Cheers!

MF.

[gosoccer]

I guess it's more my ignorance than anything else. I'll review the user guide or utube to see if I can create a simple one so I know how it works.
If you know of a good document or link, could you please let me know. :)
Thx a lot for your time.

[MFGF]

I guess it's more my ignorance than anything else. I'll review the user guide or utube to see if I can create a simple one so I know how it works.
If you know of a good document or link, could you please let me know. :)
Thx a lot for your time.

It's just like creating a chart - you add your measure to the "Color" field (to drive the "heat"), you add your region attribute to the Location field (to tie in with the regions/states in the map), you click on the "Region layer" in the map, find the Palette property, and from there you can change the colours/percentage thresholds/add new colours/thresholds etc.

It would take you longer to read about it than it would to play with it and pick it up :)

MF.

[gosoccer]

OK, I'm getting much closer. For some reason, many of the states are showing the same color while I have many different colors assigned in the Paulette. Please see attached.

I'm also not sure how to change the Legend so it would just show the States and their Colors?

Thx so much for your time. :) :)

[MFGF]

OK, I'm getting much closer. For some reason, many of the states are showing the same color while I have many different colors assigned in the Paulette. Please see attached.

I'm also not sure how to change the Legend so it would just show the States and their Colors?

Thx so much for your time. :) :)

The palette colours are driven by percentage thresholds of the measure values within the total - if states have the same colour, it means their percentage value is the same or similar. You could try changing the percentage thresholds to be finer and adding more colours, maybe?

MF.

[gosoccer]

Thank you! I'll try that.
One more question:

I take it if I make a Prompt for State or dollar values for example, the user can select specific State or Dollar values
and display the map accordingly? Can this Prompt selection occur automatically so as soon as the user selects the
the checkbox, it'll automatically show only Maryland without using Active Reports? So basically, no need for using the SUBMIT?

Thx again.