Data Presentation error with List Object

viniciusuliana · April 12, 2011, 2:29pm

Hello.

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.

Thanks!

VinÃcius Uliana

Guru · April 12, 2011, 2:32pm

Which Cognos version do you use? and what is the datasource? a cube?

viniciusuliana · April 12, 2011, 2:35pm

Version 8.4.1.

I’m accessing directly a database.

All objects and all relationships are created in Framework Manager.

Some idea?

viniciusuliana · April 13, 2011, 3:02pm

Guru,

need you more additional informations?

Thanks.,

Vinicius

Ferran · April 19, 2011, 10:32am

In framework under the dimension_regional ? or whatever its called set determinants

Country (Order BY)
Regions (unique level)

viniciusuliana · April 19, 2011, 5:09pm

We are using a regional hierarchy composed by the followed structure:

Regional
Municipality
District

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?

Thank you!

Ferran · 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.