Using E() in Set Analysis

[pauljohansson]

Hi, If you have experience applying indirect Set Analysis please read. I have found a lot of material on Set Analysis but not on Indirect Set Analysis.

My case:

I want to create a SET consisting of all customers for the CURRENT SELECT that dont exists for currently selected PaymentDate using E(). I manage to create a SET of the customers that belong to currently selected PaymentDate:

count({$<sk_customer = p({$<PaymentDate>} sk_customer)>} sk_customer)

I would assume the inverted would be:

count({1<sk_customer = E({$<PaymentDate>} sk_customer)>} sk_customer)

However, this do not give me any results. Any advice are welcome or where I can find more information on indirect SET analysis.

Thanks in advance,

br Paul

[tresesco]

May be like this?

count({<sk_customer = E({1<PaymentDate>} sk_customer)>} sk_customer)

[chematos]

Why don't you resolve that in the script?

Create a table with all clients ID, join their PAYMENTDATE or all the info of the fact table and create a new FLAG:

If( isnull(PAYMENTDATE),  0,1) as Payment,

Then you can use the flag in your expression, I think I would do that but I don't know your data model.

Regards

[pauljohansson]

thanks for all the feedback!  Its  much appreciated

Ive decided to proceed with changing the DataModel. Now exclusion of PaymentDates includes all Customers.

However, i have one last thing that i dont manage to solve. I think its easy for Set analysis developers.

I now have two exclusion SET statements that works one by one.

Count({<PaymentDate=E(PaymentDate)>} sk_customer)

Count({<PaymentType=E(PaymentType)>} sk_customer)

I dont manage to merge them to one set though. As I understand it this can be done with a intersection operator (*).

Thanks in advance,

br

Paul

[pauljohansson]

tresesco, unfortunally, this statement does not return anything. br PAul

[Carlos_Reyes]

So, what are you trying to accomplish with those two sets?

Now there is a new field : PaymentType

If you want to get those customer that are excluded by your PaymentDate and PaymentType selections, then you should use this:

Count({<PaymentDate=E(PaymentDate), PaymentType=E(PaymentType)>} sk_customer)