Cognos Transformer 7.1 Question

[Sidney786]

Hi

I have an existing cube, just pointed the source data to another database, identical setup.

When building my cube i have a region hierichy with countries within the cube.

Example Europe -- UK , France , etc

in my cube i have Europe with its nested countries
then drill to UK i get a number of locations counts under UK, this is ok, buth other measures are showing 0.

But at the default level i get

Europe -- UK, France
UK
France

some measures appear in UK
They are suppose to all appear Europe --> UK

any suggestions where im going wrong?

Regards

Sid

 

[drlex]

It sounds as though your transactional data with country reference is either slightly different between databases (e.g. trailing spaces means that 'UK ' is not the same as 'UK') or that the properties of the country level are not set to 'unique' and 'move' to correctly associate & scope the data (e.g. hierarchical data source to arrange the region category and transactional data sources need unique sub-categories to make the true relationship).

soi là, soi carré