Exsists function

[#1]

Hello everyone,

In my load data model i had a fact and two dimension tables, one for Customer and other of Ok_Customer. Both of these have customer ID in them.

I use to load

Fact:

Customer_Key

Ok_Customer_Key

Metrics

Dim1:

Customer_key

other details

where exists(Customer_key)

Dim2:

Ok_Customer_Key

other details

where exists(Ok_Customer_key)

Now i want to combine dim1 and dim2 . So how can i use exists function?

[Anonymous]

then the following Syntax should do as Long as field customer_cd is in both tables DIm1 and DIm2

left join(Dim1)

load

Ok_Customer_Key

other Details

resident Dim2

where exists(Customer_Key, OK_Customer_Key)

[#3]

What if i have already placed

Dim 1

join

Dim 2

in a qvd .

Now i want to use it in presentation layer with exists function?

[#4]

Can i use :

Load * from QVD where exists(Customer_Key) or exists(Ok_Customer_Key);??

[Anonymous]

can you explain more in Detail? what do you mean with presentation layer?

normally you would provide the datamodel in an own qvw and load it binary

in surface

what Special do you want to perfrom in presentation layer?

[#6]

You are correct that i should load in data model and do binary.

But for testing purpose i was doing it like this.

I just want to know whether if i use:

Load * from QVD

where

exists(Customer_Key) or exists(Ok_Customer_Key);??

Is the above approach correct?

Exsists function

[Anonymous]

it's okay for testing purposes (i do that as well)

Load * from QVD

where

exists(Customer_Key,Ok_Customer_Key);