SAP Knowledge Base Article - Public

3078590 - Set 'default value' is not supported in SAP Analytics Cloud (SAC)

Symptom

  • Issue with defining default value for filters: Models - Importing data from file (CSV) - "Map to Target" - "Set default value..."
  • Unable to search more default members from specific search terms.
  • Hovering over "Set default value..." for some dimensions, there is a tooltip displaying "Set default value is not supported for this target."
  • By selecting "Set default value..." only the first 100 members are listed.

Environment

 SAP Analytics Cloud (Enterprise) 2021.13.03

Reproducing the Issue

  1. Login to SAC tenant.
  2. Create a model based on Import data from file (CSV).
  3. Go to "Data Management" Workspace.
  4. In the list of "Import Jobs" find the prepared CSV import job e.g. "Example.CSV" and click "Set Up Import".
  5. Select "Map to Target".
  6. Find one of the dimensions in the "Target" panel and try to set a default filter value:
    • in the "Source" panel next to the selected dimension, click on the "..." , then hover over "Set default value..." => a tooltip is displaying "Set default value is not supported for this target."
    • by selecting "Set default value..." only the first 100 members are listed.

Cause

This issue is currently under investigation by development.

Resolution


This issue is currently under investigation by development.

Workaround:
  • Create a column by using custom transform where all rows contain the value that should be set as default, and perform column mapping to the target dimension instead of using a set default value option.

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, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, connected, failure, stopped , KBA , LOD-ANA-DE , SAC Data Wrangling , Problem

Product

SAP Analytics Cloud 1.0