Issue with FSM Data

[JoelleS]

Hi everyone,

we recently connected SAP Fieldservicemanagement (FSM) with SAP Datasphere.

We have two tables that are extracted from FSM, both displaying the data correctly in the preview:

1. BusinessPartners (containing ID, and Name)

2. ServiceCalls (containing ID ServiceCall, ID BusinessPartner and a measure, in this case number of minutes used)

The goal is to show the Measure with the Number of minutes used.

Therefore we prepared the data as followed

1. BusinessPartners (Local Table) -> BusinessPartners (Dimension) 

The Name has the semantic type "Text" and is the Text Association for the ID.

2. ServiceCalls (Local Table) -> ServiceCalls (Fact View)

An Association between the BusinessPartner ID and the ID (from the BusinessPartner Dimension View) is created.

Now an Analytic Model is created.

The data preview presents the ID two times. Presentation selected is ID & Description.

In SAP Analytics Cloud the description equals the ID. If name is selected as poperty, the column will be empty.

Thing we tried to solve this issue (without success):

*Creating calculated columns for the ID and Name which will have the exact same value (tried that in different variations)

*Creating a seperate Text View and associate it with the Dimension 

*Making the Local table a relational Dataset and than making it a view (tried that in different variations)

Hope the issue is described well enough, otherwise feel free to reach out. Thank you very much!!

Best, Joelle

[saalbrecht]

How did you connect FSM and Datasphere?