Geospatial segmentation in ymkt

[former_member201769]

HI Experts,

I was testing the Geo spatial segmentation .In the corporate accounts there is no latitude and longitude data is maintained.I tried maintaining the latitude and longitude directly in the root table and successfully maintained the data also.

In the segmentation screen while using the Geo location(longitude) field for Geo spatial segmentation ,the output of the segmentation is coming as zero.May be the system is not recognizing the field values.

Is there any proper format for the Geo spatial segmentation to work on here maps.

Regards

Rashmi Ranjan

[former_member201769]

Hi Akil,

Thanks for your valuable inputs.We have tried maintaining the attribute IC_LONGITUDE but could not find the attribute .There is one more attribute called IA_LONGITUDE.I maintained the attribute and selected it as GEOPT .I have enabled it as attribute over the screen.Now in the segmentation screen now we have two Geolocation . I have tried it with both the fields,but there are no customers showing in Map.

We have maintained the table entry as Latitude as 19.4326 and Longitude as -99.1332 and after saving the data system is appending zeros with <,>.

Please let me know if i have missed anything.

Regards

[Former Member]

Dear Rashmi,

We have geolocation working, so while looking at my environment I can see below values.

Values in the root table have a comma, unlike for instance Google Maps which uses dots.

In segmentation customizing, we are using the standard B2C e.g. segmentation object SAP_CONTACT_EGM_CONSUMER_11SP8. In SPRO, select <Assign SAP HANA Data Sources to Segmentation Objects>, and select above object and data source alias SAP_CONTACT_INTERACTIONS.

IA_LONGITUDE/IA_LATITUDE is only used in case your interaction has a geolocation. Since you mentioned you maintained the values in CUAND_CE_IC_ROOT, you would need IC_LATITUDE or LATITUDE in your system.

Which segmentation object are you using? Did you try using the default segmentation objects?

With regards,

Akil

[former_member201769]

Hi Akil,

Thanks for you quick response.

I tried with the segmentation object you suggested and bingo the customers were showing on the screen after clicking on clustering .

I am just thinking that as you mentioned we have to use IC_LONGITUDE if we are directly updating in the root table.Same i tried with some of the contacts i created and updated .I used the segmentation object you suggested and that worked like charm.

The segmentation object we are using is having all the data fro s/4 and the latitude and longitude fields are blank.In my real case i have to deal with SAP_COMPANY_ENGAGEMENT_OP object as i have my data in this object.

Please let me know your thoughts.

Expecting your quick response as always 🙂

Regards

Rashmi Ranjan

[Former Member]

Dear Rashmi,

I did some tests myself.

I made a company and contact both located in Belgium (exact same location). The data in the tables:

When looking at the contact geolocation (when using segmentation object SAP_COMPANY_ENGAGEMENT_OP and data source alias SAP_CE_IC_COMPANY, field names are IC_CONT_LONGITUDE, IC_CONT_LATITUDE). The geolocation for contacts does get shown correctly.

However, when trying to get the geolocation for the Company itself to show, it does not work (when using segmentation object SAP_COMPANY_ENGAGEMENT_OP and data source alias SAP_CE_IC_COMPANY, field names are LONGITUDE, LATITUDE).

I think the next advice would be to ask SAP to look at your system by creating an incident. I will create one myself too, and keep you updated on the response by SAP. With regards, Akil

[former_member201769]

Hi Akil,

Thanks a ton for your help.I will be also raising the incident to SAP and also will let you know the response.

Best Regards

Rashmi Ranjan

[former_member87164]

Hi Rashmi,

I think your missing configuration. Please check below step.

Note : For attributes of type ST_POINT or ST_GEOMETRY, the semantic type is automatically set

https://help.sap.com/viewer/307cdb0f1a69422bb23b9ee426bd39f7/1708%20YMKT/en-US/574da256ef15f82ae1000...

Br,

Keshav

[former_member234476]

Hi Keshav,

Thank you. Is it necessary that I need to have the data type as ST_POINT or ST_GEOMETRY? I have already maintained the following in the system as per the document url you have provided:

1. Two attributes, Longitude and Latitude, with data type as Decimal Points

2. In the Longitude field, I have maintained the semantic type as "GPT00 Geo Point" and dependent attribute as Latitude. Preview automatically updated to "SAP_CH_GEOSPATIAL_MAP".

3. In CUAND_CE_IC_ROOT table, maintained the coordinates for Longitude and Latitude in the customer record

4. Segmentation profile is reading the values from CUAND_CE_IC_ROOT table.

But still I am unable to segment the customer based on the coordinates provided in the map.

I am not sure if I am missing something.

Please let me know your thoughts.

Thank you in advance.

Regards,

Somanathan

[Former Member]

1. Seems fine
2. Try to maintain attribute IC_LONGITUDE as GEOPT
3. Necessary
4. Seems fine

Did you try pressing "Show Clustering" after you select Geolocation in your Segmentation? My colleagues seem to forget this a lot.

With regards,

Akil