Symptom
- When a new import model is created via “User Predefined Model”, the Data being represented with technical id’s instead of actual data in SalesForce.
Environment
- SAP Analytics Cloud
Reproducing the Issue
- Create a connection
- Creating a SAC Model using the Salesforce Connection
- Select Source Report from Salesforce
- Below we observed that for each of the dimensions, the ID is showing as ‘0’ Members
- Imported data in the SAC Model
- ID field mapping from Sales Force contains ID of date object.
- In modeler Data Foundation is populated with object ID instead of date (data is being stored in Description)
- Unable to modify the data type of the date field at the model level.
Resolution
- This is a product limitation that Dev is aware of and is currently on their roadmap to be address, but there is no timeframe for when it could be accomplished.
Keywords
SalesForce , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem
Product
SAP Analytics Cloud 1.0