COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: ratnalein on 20 Feb 2013 11:02:50 AM

Title: Map layer and feature
Post by: ratnalein on 20 Feb 2013 11:02:50 AM
Hallo everyone,

I have successfully transformed a map with ArcInfo-Shape-Format into .gst, which is importable in Report Studio.

At Map Manager I could open the .gst file it looks like in the attachment.

My question:
1. In Map Manager I can see the layer information(it is like a file name), and I can see "Feature":

Feature         Refine
01
02
03
04
05
06
..
..
..

Is Feature some kinda IDs? 

I will add the Alias information in my map layer my dimension table, so that Alias look like this:

Feature     Alias
------------------------
01             State_01
02             State_02
...
...

My Dimension table looks like this:

State_id           Name
----------------------------
State_01          Name_of_01
State_02          Name_of_02
...
...

In the report later on, I will have a report like this:

State                   #Population_with_own_car
---------------------------------------------------------
State_01             34930
State_02             93849
State_06                875
...

So, I want to compare the values of the measure across states using contrasting colors.  How can I achive this?

Thank you.

Regards,

Ratna