How do I?

[#1]

My fact table has LastModifiedbyUser Code. When I use it as a list box to narrow the fact records down – I want to not see User Names from the User Master not the User Codes. I want to see the User Names in the List Box. I have the User master also loaded.I don't want to see the entire User Names - just the ones that have modified records in the fact table.

Appreciate the help.

[Jason_Michaelides]

Assuming your fact table has and ID field, you could use an expression in your list box like:

If(Not IsNull(FactID),UserCode)

Hope this helps,

Jason

[jagan]

Hi,

You can load only the User Names from master data which is having the LastModifiedbyUser code by using the Exists().  Check help file from example.

Ex:

LOAD

     LastModifiedbyUserCode AS UserCode,

      *

FROM Table;

Master:

LOAD

    UserCode,

     UserName

FROM Master

WHERE Exists(UserCode);

Hope this helps you.

Regards,

jagan.