AND function with filters from two different data sources

[Former Member]

Hello Team,

In marketing segmentation CRM 7.0 Ehp1 , is it possible to use AND function with  filters from two different data sources using different info sets ?

I have observed that when we select filters from different data sources and drag on modeler , system links these two filters with OR operator and it's not possible to use AND function.

AND function is only possible for filters with same data source / infoset.

Is there any way to use AND function in this scenario?

Thanks,

Anagha

[kavindra_joshi]

I would take this example

for all the BPs which are Organizational and have customer blocks , create a target group . To achieve the same you can choose the option Keep and apply the filter value ( Org. Unit ) on the customers and then again you choose the option Keep and apply the filter value ( choose the individual filter type and subsequent filter value ). This is equivalent to an AND operation.

This should work I guess. Try out and let me know.

Regards,

Kavindra

[Former Member]

Hello Kavaindra,

I have tried it and was able to create and function. But the TG does not give any result , please find the attached screenshot for reference.

Basically in my TG I want list of all BP's which has specific sales representative linked as an relationship based on sales org.

I am using CRMM_BUT_FRG0081 table with BUT000 where by passing BUT000-PARTNER (Sales rep) + partner function (is responsible sales rep) + sales org

Thanks,

Anagha

[kavindra_joshi]

Hi Anagha ,

Please flip the order of the filters. Have the Sales Org 1st , Partner Function 2nd and then your specific BP.

Try this and then let me know.

~Kavindra

[Former Member]

Kavindra,

Sequence doesn't matter. I got the problem cause. In table join I have used alias table

BUT00_PARTNER which is copy of BUT000.

The infoset & related query works only when BUT000_PARTNER_PARTNER field is used to pass the BP ID of sales rep. With BUT000_PARTNER field query fails.

with I try to assign infoset as data source in attribute list , infoset do not show BUT000_PARTNER-PARTNER field for selection. That's why TG doesn't result anything in segments.

Any clue why this field is missing as data source ? even when it's included in infosets field group?

Thanks,

Anagha

[kavindra_joshi]

hi anagha,

sequence does matter.for e.g. you would like to do a segmentation on all bps which are for e.g.organizations and have partner func. = xyz rather than vice versa.I have no idea why they are not shown.