Create query on customer table to include dimensions

njward

Hello,
I'm trying to create a query showing customer records and also a dimension that is added to each customer. I looked at the customer table but can't see where I can link to the dimension tables.

This is probably quite simple but I'm quite new to this so any help would be greatly appreciated.

Thanks

Nick

geordie

Hi, in your query you need to join the table Default Dimension filtering by "Table ID" = 18 and No. = Customer No.