SAP Knowledge Base Article - Public

3387638 - "Member is already booked" when adding an existing member in a table in SAP Analytics Cloud (SAC)

Symptom

When you add a new line and select an existing member with the "Add member" option, the error "Member is already booked" is displayed.

Environment

  • SAP Analytics Cloud (Enterprise)

Reproducing the Issue

Case 1: 'Unbooked Data' is turned on:

  1. Go to a story which at least one dimension not ticked with the unbooked option.
  2. Right click a dimension header in the table.
  3. Add member.
  4. Add an existing member.
  5. It works.
  6. Show unbooked for all the dimensions of this table.
  7. Add the same member in step 4.
  8. Error "Member is already booked" is displayed.

Case 2: 'Unbooked Data' is turned off:

  1. Go to a story which all dimension ticked with the show unbooked option.
  2. In the table, there are more than 3 dimensions in the column. For example, the original table is as below: 
      TimeApr 2026
    Region (Outer dimension)Product (Middle Dimension)Color (Inner Dimension) 
    GermanyShoesWhite100
  3. Right click the Product member Shoes in the middle and add a new line
  4. A new line is added
      TimeApr 2026
    Region (Outer dimension)Product (Middle Dimension)Color (Inner Dimension) 
    GermanyShoesWhite100
    Germany White 
  5. Move your mouse to the cell of the inner column in this new line and change it to another member that is unbooked
      TimeApr 2026
    Region (Outer dimension)Product (Middle Dimension)Color (Inner Dimension) 
    GermanyShoesWhite100
    Germany Red 
  6. Move your mouse back to the cell of the middle column in this new line and select the same member as the line above
      TimeApr 2026
    Region (Outer dimension)Product (Middle Dimension)Color (Inner Dimension) 
    GermanyShoesWhite100
    GermanyShoesRed 
  7. Error "Member is already booked" is displayed.

Cause

Cause of case 1:

Whe all the dimensions of a table are enabled with the Unbooked option, all existing members are already shown in the table. 
In this situation, we cannot add an existing member via add member and error "Member is already booked" is displayed.
It's the designed behavior. We cannot add repeated members via add member.  

Cause of case 2:

When checking whether the member is already booked / repeated, the system only checks the current dimension and the outer dimensions. It does not check the inner dimensions.

Resolution

In both cases, it works as designed.

For case 2, if you would like to add a new line with same Region and Product dimension member and different Color dimension members, please right click the Color member to trigger the "Add member" feature.

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, MOF, members on the fly, member-on-the-fly, member on-the-fly , KBA , LOD-ANA-PL-MOF , New Line and Member on the Fly , Problem

Product

SAP Analytics Cloud all versions