how to get result without relation between two tables

[srinivas1921]

Hi All,

There are two tables that 'Dim_Customer' table(Master table)  and 'Dim_Currency' table.There is no relationship between two tables in my data model.

I created Straight table for customer information which is in the different alternate state(named as customer Info) and also created text objects using Currency from Currency table and Cus_state from Customer table.when I selected customer value from the straight table then the currency value is not showing in the text object  as per selected customer values.(because of there is no relation between two tables)

but I want to see the currency values in the text object as per my selection of customer values from the straight table without giving relation between two tables.(NOTE:I don't want resolve this issue by creating relation between two tables in my data model) even though I tried by using create variable but variable doesn't impact on this alternate state.

kindly provide me solution for above scenario.

many thanks for your great support.

[swuehl]

How do your two tables look like (most important field)? For example, which field from Customer table to you want to match to which field in Currency table to limit currency to correct one? If it's like a Country field, then try:

=Only( {<CurrencyCountry = CustomerCountry>} Currency)

which should work if only a single customer is selected and country field values match in both tables.