COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Transformer => Topic started by: halkosj on 27 Jul 2012 01:14:21 PM

Title: Level is out of scope and unreachable
Post by: halkosj on 27 Jul 2012 01:14:21 PM
None of us here understands what scope is all about, and what to do when it says a level is "out of scope and unreachable".

I have a dimension with 3 levels. The middle level is in red (out of scope). Why would transformer single out that one level - there's nothing different about it than any other levels in the model.

If we change the second level and mark it as unique, then the red goes away - but the second level is NOT unique - isn't that the point of a hierarchy? Only the bottom level is ever unique.

Title: Level is out of scope and unreachable
Post by: MFGF on 30 Jul 2012 04:32:27 PM
It sounds to me like Transformer has a measure which links to the middle level of your dimension. I would imagine it must be in a separate data source from the dimensional data? What is the linking key value for the dimension in question if you look at this data source?

MF.

Sent from my iPad using Tapatalk HD