SAP Knowledge Base Article - Public

3249180 - Distribute Value functionality ignores the unassigned (#) member in SAP Analytics Cloud for Planning (SAC)

Symptom

The following behavior occurs in SAP Analytics Cloud for Planning (SAC):

  • You would like to leverage the standard “Distribute Value” functionality to spread data from the top node to leaf members for a dimension.
  • Expected results would be to be able to distribute values on all leaf members, including the Not Assigned (#) member.
  • However, the current result is that the # member is ignored (i.e. values will be distributed to all the leaf members excluding #)

Environment

  • SAP Analytics Cloud (Enterprise) 2022.8.17

Cause

Most of the customers want to exclude the unassigned member when distributing among the dimension members. Therefore, we don't add it to the list of members for the system-generated suggestions. This is the designed behavior.

Resolution

This is the designed behavior.

The good news: you can easily add it manually. Just toggle the "add target" mode by clicking the hand icon in the header of the "Where to?" section and click the cell(s) you want to select (or deselect).

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, 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, sap analyst cloud, https://hcs.cloud.saphttps://hanacloudservices.cloud.saphttps://cloudanalytics.accounts.ondemand.comhttps://hanacloudservices-us.accounts.ondemand.comhttps://www.sap.comhttps://help.sap.com, predictive analytics (analysis), data analysis (analytics) tools, analytics tools, sap analytics cloud, data literacy, advanced analytics, data democratization, analytics software, real time analytics, self service analytics, advanced data analytics, analytics as a service, analytics cloud / cloud analytics, saas analytics, cloud bi, enterprise planning, cloud data analytics, cloud based analytics, analytics cloud platform, modern analytics, real time analysis, cloud analytics solution(s), what is sap analytics cloud, cloud analytics tools, analytics in the cloud, cloud analytics software, distribution, '#' , KBA , LOD-ANA-PL-DIS , Distribute, Spreading, Assign, Copy & Paste , Problem

Product

SAP Analytics Cloud 1.0