Linking two unlinked dimensions

[Karl_Hart]

Hi,

I'm not sure how to explain this but I'll try my best.

I have two fields that I need to keep separate in the script, for example, CustomerID and SupplierID

For multiple cases the CustomerID and SupplierID will be identical and effectively, I want to a chart to return some info from the Supplier Table when I have the CustomerID selected.

For example,

Customer Table

CustomerID               1234

Supplier Table

SupplierID                1234

Supplier Address      123 ABC Street

I want to create a straight table in the front end that will show me

CustomerID          Supplier Address

1234                     123 ABC Street

Is there a way I can do that using calculated dimensions or set analysis in the expressions?

Many thanks

[jonathandienst]

You say 'unlinked' but its not clear what you mean by that. Are they from two separate, unassociated tables?

I think you need to post more information on your data model and where you mean to use the expression. The best way is to show that in an uploaded qvw.

[Karl_Hart]

They are linked via a third table. Obviously the above is a simplistic version of the issue, I'll see if I can build a qvw that has the relevant info in it

Thanks