3687930 - upload starter rejects transactional data when related master data is missing in the model

• Upload starter fails to bring transactional data into the model if the associated master data does not exist.
• Error message indicating missing master data during the upload process.

• Data Integration
• Data Export API
• Data Import API

1. Create a blank model with required dimensions and one measure.
2. Create an upload job using a data source, mapping all dimensions and the measure.
3. Create a story and insert a table.
4. Add the upload starter, select the upload job, and choose the data source.
5. Attempt to upload transactional data without pre-existing master data in the model.

• The upload starter does not automatically create master data members in the dimension table.
• Transactional data is rejected if it does not match existing master data in the model.

1. Ensure that master data is created and exists in the model before attempting to upload transactional data using the upload starter.
2. Refer to the online help documentation for detailed information on the behavior of dimensions without associated dimension tables.
3. If automatic creation of master data is required, consider using the Data Import API and custom code to create master data members prior to uploading transactional data.

Note: If using a Dimension without an associated dimension table (sometimes called single-column dimension), it is possible to import transaction data for this dimension for members that do not exist. In fact, this is the only way to define data for a single-column dimension. In this case the data only exists in the fact table and there is no associated metadata for the dimension.

• Refer to: SAP Analytics Cloud Help Documentation - Dimensions and Master Data
• Refer to: SAP Analytics Cloud Help Documentation - Upload Starter

upload starter, transactional data, master data, SAP Analytics Cloud, data import, dimension table, data integration, fact data, missing master data, upload job, data preparation , KBA , LOD-ANA-ML-DI , Data Integration, Data Export API, Data Import API , LOD-ANA-ML-MDM , Master Data Management , Problem