Cognos Analytics

 View Only

Refining Map Locations in #Cognos Analytics

By KEVIN MCFAUL posted Mon November 13, 2017 10:06 AM

There is a subtle yet critical difference in refining data items. Let’s imagine you are mapping post codes which always[1] need country as the refining data item. Perhaps my data looks like this:

Country is in effect a parent item to Postal Code.

In a dashboard map, I would specify the parent data item first:

In a report map, the child item comes first:

If I had more complex data, perhaps I wish to map US counties, I might have data such as:

In this case, I might have two refining data items Country and State.

In a dashboard, I would specify:

I think most people would agree this is an intuitive order of grand parent, parent, child.

In a report:

This order is not all that intuitive child, grand parent, parent. In a future release, we will make report map data slots work the same as dashboards but in the mean time, be aware of the issue.

[1] Always means there is never an exception….. really.