Getting Duplicate Description in List

[mhmmd_srf]

Hi All,

I have Fact table is joined with Dim table on two fields. Item_Key and Product Group Major.

Dim_Item has Group Major Description.

If we put in simple List Box. I am getting two valid value for Description.

But if i make a Table Box using same fields, I am getting one extra records against all ProductGoupMajor code.

I am not getting this. How to resolve?

Please help.

Thanks,

Sarif

[PrashantSangle]

Hi,

Remove synthetic key by creating composite key.

then add composite key in table box

or

Using existing data model in your table box add ProductGroupMajor and Item_key Field.

Provide snip after adding above 2 fields.

Regards,

Prashant

[muthukumar77]

May be like this,

Com_fact:

Load

  Item_Key & Product Group Major as key,

  Item_Key ,

Product Group Major

.

.

from Com_Fact;

Dim_Item:

Load

  Item_Key & Product Group Major as key,

.

.

from Dim_Item;

[mhmmd_srf]

Hi Prashant,

Below is the snip after adding Item_Key:

Please help.

Thanks,

Sarif

[PrashantSangle]

So you can see due to item key  in you synthetic key you are getting 2 Group description..

confirm what is your key on which you need to associate table.

Regards,

Prashant

[mhmmd_srf]

If I use composite key it is coming like this:

Please help.

Thanks,

Sarif

[#7]

Hi Mohammad,

It is not best idea to use field which acts as a key in table (in your example you are using ProductGroupMajor). And doesn't matter if it is part of synthetic key or not.

In your case as they write before you should first avoid synthetic key by creating new field:

[Item_Key]&'_'&[ProductGroupMajor] as %Key

But of course you should remember to comment or rename fields Item_Key and ProductGroupMajor in one of the tables. And best approach is not to use field %Key in charts or tables.

BR,

Milosz

[mhmmd_srf]

No sir,

I do not have any synthetic now. See this

Thanks,

Sarif

[mhmmd_srf]

Hi Pranshant,

But using Composite Key also we are not able to resolve the issue.

Please help.

Thanks,

Sarif

[PrashantSangle]

Issue is not in key.

Please confirm, Is Item_key is part of Synthetic key.???

If yes then check GroupDescription is available for those combination in your source data.

Regards,

Prashant