SAP Knowledge Base Article - Public

3100761 - Target data selection not reflecting the right types for fields in SAP Analytics Cloud for Planning (SAC)

Symptom

You configure the ADSO as per note 2838883 - SAC BW Writeback - Part 1 -> Configurations -> point 2.

However, available fields are all recognized as Dimension in the target data selection when you create an export job with OData Service to the BW system in SAP Analytics Cloud for Planning (SAC).

Environment

  • SAP Analytics Cloud (Enterprise) 2021.14.10

Reproducing the Issue

  1. Go to modeler
  2. Open a model.
  3. Under Workspace, select Data Management
  4. Under Export Jobs, create a new oData Job using an oData Connection.
  5. All fields are recognized as dimension.

Cause

This issue is due to the old odata cache.

Resolution

The odata metadata has a timestamp for cache. It is compared with the last modified time of all ADSOs in the maintenance view. If you add a new ADSO, it will update the time and regenerate the cache.

So please follow the steps below:

  1. add a new dummy ADSO in the maintenance view
  2. check if the issue is fixed
  3. remove the newly added dummy ADSO from the maintenance view

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Sac, Acquisition, Model, Connect, Story, Tenant, Import, Failed, Using, Working, Please select at least one dimension and one measure. , KBA , LOD-ANA-PL-PLI , Planning Integration (BPC import/export/writeback) , Problem

Product

SAP Analytics Cloud 1.0