I’m with a trouble using the List Object on Query Studio. Cognos are replicating data in all rows. The question is that the problem don’t occurs when I use a crosstab. Follow the pictures with the problem are attached.
April 12, 2011, 2:32pm
Which Cognos version do you use? and what is the datasource? a cube?
I’m accessing directly a database.
All objects and all relationships are created in Framework Manager.
need you more additional informations?
April 19, 2011, 10:32am
In framework under the dimension_regional ? or whatever its called set determinants
Country (Order BY)
Regions (unique level)
We are using a regional hierarchy composed by the followed structure:
ie: Regional has many Municipality and Municipality has many Districts.
Can anybody send me a printscreen showing how a hierarchy must be created in Cognos 8.4.1?
April 26, 2011, 10:14am
As u are using query studio, u can NOT build it on a regular dimension in dimensional view.
So u need to set determants in the first namespace (layer) also u need to connect (prolly by districtkey) this dimension to the fact.