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

[#2]

Hi Mohammand,

That is a basic data quality / data modelling problem. You need to think about data in both tables and relation between them. And don't believe in List Boxes because they don't show null values.

1. Maybe you should double check if you created "ItemGrpMjrKey" correctly (check density and subset ratios for the fields in the data model viewer). It seems that the key is not connecting tables properly.
2. Or maybe only field "Item_key" will be better to act as key in that case? Probably DIM_ITEM table has got one row per Item or at least it should have.

You need to check that because without seeing qvw file I cannot give you better support.

BR,

Milosz

[sasiparupudi1]

Drop Product Group Major field from the fact table

[sasiparupudi1]

Drop Product Group Major Field from your fact table

hth

Sas