If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

MUN

Started by bwalikar, 23 Jan 2018 02:19:57 AM

Previous topic - Next topic

bwalikar

Hi All,
In what cases does transformer generate a different MUN in different enviroments. I am using the MUN in a slicer and the report is failing in QA.

Example :
MUN in Dev : ABC
MUN in QA : ABC~47
MUN in Prod : ABC~188.

Can you also please let me know the workaround for this issue ?

MFGF

Quote from: bheemrao.walikar on 23 Jan 2018 02:19:57 AM
Hi All,
In what cases does transformer generate a different MUN in different enviroments. I am using the MUN in a slicer and the report is failing in QA.

Example :
MUN in Dev : ABC
MUN in QA : ABC~47
MUN in Prod : ABC~188.

Can you also please let me know the workaround for this issue ?

Hi,

In Transformer-speak, a MUN is a Category Code. Every category code in a dimension needs to be unique, and if it isn't, Transformer will make it unique by appending a ~ and a number. The workaround is to make sure that the category codes you use are unique for every category - you can often do this by concatenating multiple codes if necessary. Imagine a scenario for this in the sample GO Sales data, in the Products dimension - eg:

Product Line Code: 1
Product Line: Camping Equipment
Product Type Code: 1
Product Type: Cooking Gear
Product Number: 1
Product: TrailChef Water Bag

If you were to create a Products dimension in Transformer with levels of Product Line, Product Type and Product, and use the codes as the category codes, you can see that the category codes would not be unique. You could make them unique by combining the codes into a concatenated category code, so for the Product Type level, the category code could be [Product Line Code] + '*' + [Product Type Code], and for the Product level, the category code could be [Product Line Code] + '*' + [Product Type Code] + '*' + [Product Number]

In the dimension you would then have
Category Code: 1
Category Label: Camping Equipment
Category Code: 1*1
Category Label: Cooking Gear
Category Code: 1*1*1
Category Label: TrailChef Water Bag

Notice I used asterisks to separate the codes. This is to prevent unintended further uniqueness issues, eg 1 + 11 vs 1 + 1 + 1

Cheers!

MF.
Meep!

bwalikar

Thank you so much for the reply. I will try this out.