7.0 Segmentation: Datasource, Attribute List using InfoSets.

[Former Member]

Hello All,

Issue: Target group based on attribute List built based on an InfoSet datasource not being populated in Classical Segmentation.

Steps:

1. Created InfoSet using table joins- BUT000, BUT020, ADRC, CRMM_BUT_FRG0041, CRMM_BUT_FRG0100.

2. Created Datasource based on InfoSet

- RFC Destination: CRM

- Infoset selected

Details

- Business Partner (BUT000-PARTNER_GUID)

- BP Category (BUT000-PARTNER_GUID)

(All other fields left blank)

3. Created Attribute List based on Datasource

4. Logged in CRM Web UI using Marketing Professional role

5. Created Profile Set -> Profile -> Create filter on Attribute List. Search returns zero results.

Created Query based on Infoset returns results as expected.

Any suggestions would be great? All above tables are standard with standard fileds. I do not think this will need any function module for conversion to be specified in creation of Datasource unless I am missing something.

Thank you,

Deepak

[Former Member]

Hi,

please check the Attribute List you have created based on Datasource

Regards,

Ashish

[Former Member]

Hi Deepak,

First can u try to create a very simple attribute list based on a single table. Are u able to create target group based on this attribute list ?

Then try building complex attribute lists.

rgrds,

Randhir

[Former Member]

Hi Ashish,

The Attribute List created is based on the appropriate Data Source.

Thanks,

Deepak

[Former Member]

Hi Randhir,

I created the Data Source based on standard infoset available CRM_MKTTG_BP_CENTRAL (BP Central Data) that is based on BUT000. Created the Attribute List and tried creating filter for BP Type, I still do not see any avalues available.

Thanks,

Deepak

[Former Member]

Hi Deepak,

I get a feel that since even the basic attribute lists are not working and you are not able to create target group, it looks like you are not creating the attribute lists in the right way.

To understand the issue which you are getting, i also tried creating infoset based on the table CRM_MKTTG_BP_CENTRAL.

Then i created data source based on this infoset.

Then i tried creating an attribute list based on the above infoset. And here i get the below error which shows that you are not choosing the right Field while creating the Data source. Did you also got the same error ??

***************************************

Enter a conversion module

Message no. CRM_MKTTG_DS_MISC037

Diagnosis

The business partner field BUT000-TYPE of InfoSet CRM_MKTTG_BP_CENTRAL does not return the business partner GUID. The Segment Builder therefore cannot generate a target group from this data source.

Procedure

In the business partner field for data source CRM_MKTTG_BP_CENTRAL, enter a field which returns the business partner GUID. Alternatively, specify a function module capable of converting the content of the field specified into a GUID.

********************************************************

After seeing the above error, you might have understood by now that you need a select such type of field which returns the business partner GUID.

Try using the field "BUT000-PARTNER_GUID" in the Filed "Business partner" in the Details assigment block while creating the Data Source. This time the Data source gets created properly without any error.

Now try to create target group based on some filter criteria set in this Attribute list. Make sure you have the relevant data. For simplicity try to create filter on the attribute "country".

rgrds,

Randhir

[Former Member]

Hi Randhir,

Thanks for the quick response. In my previous message, I did the exact steps that you mentioned.

1. DataSource Creation:

SOURCE

Segmenation Object = Business Partner

Origin Type = InfoSet

RFC Destination = CRM

InfoSet = CRM_MKTTG_BP_CENTRAL

Description = BP CENTRAL DATA

DETAILS

Business Partner = BUT000-PARTNER_GUID

BP Category =

Reference Object =

Reference Object Type =

Relationship =

Function Module =

OBJECT

Object =

Partner Function =

1. Attribute List Creation

Description = BP CENTRAL DATA

Category = Campaign Execution

Usage Id = Campaign

Segmentation Object = Business Partner

I click on Assign Data Source and select the 'BP Central Data' data source

I can see the values of filed available

Age

Business partner category

Business Partner GUID

Business Partner: Contacl Permission

Business Partner : Language

.... other fileds

When I right click and select for e.g. Business partner category from the above list I try and do an F4 to select a filter value I DO NOT SEE THE VALUES. I do not see the values for any of the above fields.

In the Classical Segment Builder when I look up the Attribute List and try and select any filed available and right click and create filter, again i do not see any values.

Do you have a number I can reach you on or an email id.

Thanks,

Deepak

[Former Member]

Hi Deepak,

While creating the Attribute list , you need to check the checkbox next to the available fields.

In my case , i checked the check boxes next to the attributes "Age, Business partner category, Business Partner GUID, Group Type, Nationality".

Then save this Attribute List.

Go to Segment builder application ( tcode:- crmd_mktseg)

Search your attribute list which you just created above in the drop down in the segement builder application.

Right click on the attribute "Nationality" and select "Display Distribution".

Now do u see any pie chart on the right with the distribution and some numbers ??

You can refer to my profile to see if you can get some help.

Note:- Please tell me if you are trying to create target groups for first time or you have already worked on this tool earlier as well.

rgrds,

Randhir

[Former Member]

Hi Randhir,

The attributes/fields are obviously checked in the Attribute List. I am able to see the Attribute List in the SAP GUI Segment Builder transaction and in the Web UI. When I pull down the List and do a right click --> Display Distribution n=0. This is for all fields.

However,I have some other Attribute Lists based on standard Marketing Attributes and BW queries that show the results. It's only incase of InfoSet that we face this issue.

In display distribution are you able to see results i.e. n=? FYI, we are on CRM 7.0 SP 06. What version are you on?

Yes, been working on SAP CRM solutions for the past 10 years.

Thanks,

Deepak

[former_member222766]

Hi Deepak,

Did you solve this issue? I'm facing the same situation. I have created an attribute list to use in my segmentation. The problem is, if I want to use a filter in any of the attributes, I can't see the values to choose from. And this only happens for the Z attribute list.

Bellow is an example of what appears when it is a standard attribute list:

How did you solve it?

Thanks!

[Former Member]

Hello Deepak,

Please let me know whether more than one filter is selected and what is the operation used between them. If it is AND operation then there is a SAP note to correct it.

regards,

Subash.

[Former Member]

Hi Subhash,

Thanks for your response. We would use more than one filter. But in any case when I use even one filter that results done show up. What support pack is the note relevant for? Please provide me the note and I'll see if it helps.

Thanks,

Deepak

[klaus_brengel]

Hi Deepak,

I believe BP Category field must not be set to BUT000-PARTNER_GUID. You will have to enter the field of your InfoSet that returns the category of the Business Partner (most likely BUT000-TYPE in your case).

Hope that helps

--klaus

[Former Member]

Hi Klaus,

Tried that. It does not work.

Thanks,

Deepak