MUN Error

[cognos05]

Hi All,

Version : Cognos 10.2.1
Getting this error on trying to open an existing report .

"you must update analysis because it refers to items that are either no longer present in the model or inaccessible because of security restrictions"

Missing Item DimensionA->Team->abc~1234      New Item DimensionA->Team->abc~3456

There was no change in the specific element abc and the data for this dimension is unique.

I wanted to know what could have caused this issue?

I see the solution as  update your Transformer model to define category codes rather than allowing the codes to be automatically generated from the source values. Once you map a column to the category code you should have unique category codes which will not change during cube builds.

But my questions is I dont have duplicate values in my column  and my doubt is say I have moved elements from one level to other, will this cause forming duplicates.This is the only thing I am doing.And the solution updating your your category code is to just select all the levels and check on unique key right.

Thanks,
Nithya

[MFGF]

Hi All,

Version : Cognos 10.2.1
Getting this error on trying to open an existing report .

"you must update analysis because it refers to items that are either no longer present in the model or inaccessible because of security restrictions"

Missing Item DimensionA->Team->abc~1234      New Item DimensionA->Team->abc~3456

There was no change in the specific element abc and the data for this dimension is unique.

I wanted to know what could have caused this issue?

I see the solution as  update your Transformer model to define category codes rather than allowing the codes to be automatically generated from the source values. Once you map a column to the category code you should have unique category codes which will not change during cube builds.

But my questions is I dont have duplicate values in my column  and my doubt is say I have moved elements from one level to other, will this cause forming duplicates.This is the only thing I am doing.And the solution updating your your category code is to just select all the levels and check on unique key right.

Thanks,
Nithya

When Transformer encounters a non-unique category code within a dimension (not just a level - the whole dimension) it makes the code unique by appending a tilde ~ followed by a randomly generated number. If you regenerate categories, this can lead to all sorts of issues in your reports, including the one you are reporting here, since the category code becomes the last part of the MUN for the catagory (member) in your reports.

The fact that you have category codes containing tildes confirms that you have non-unique IDs. Marking a level as Unique will not necessarily fix your issue - the duplicate code may be at a different level. Let me give you an example

You have a Product dimension with three levels - Product Line, Product Type and Product

On the Product Line level you have a category for Camping Equipment, with a category code of 1
On the Product Type level you have a category for Cooking Gear, with a category code of 1
On the Product level you have a category for Trailchef Water Bag with a category code of 1

In your dimension, Transformer does not allow non-unique category codes, so it makes them unique by adding ~nnnn to all but the first (where nnnn is a random number).

The fix to this is to assign your own, unique category codes in Transformer. You could perhaps use a combination of both Product Line Code and Product Type Code at the Product Type level, and a combination of Product Line Code, Product Type Code and Product Code at the Product Level?

Cheers!

MF.