Author Topic: MUN  (Read 464 times)

Offline bheemrao.walikar

  • Full Member
  • ***
  • Join Date: Mar 2015
  • Posts: 26
  • Forum Citizenship: +0/-0
MUN
« 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 ?

Offline MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 10,357
  • Forum Citizenship: +624/-10
  • Cognos Software Muppet
Re: MUN
« Reply #1 on: 23 Jan 2018 03:55:07 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!

Offline bheemrao.walikar

  • Full Member
  • ***
  • Join Date: Mar 2015
  • Posts: 26
  • Forum Citizenship: +0/-0
Re: MUN
« Reply #2 on: 21 Feb 2018 01:58:29 am »
Thank you so much for the reply. I will try this out.

 


       
Twittear