Alternative for data point commenting column in SAP Analytics Cloud Planning
2023-10-21 05:31:18 Author: blogs.sap.com(查看原文) 阅读量:21 收藏

Use case:

In a Headcount planning scenario, while planning FTEs against a vacant job position in planning input table, HR user adds a new row in the planning table, using ‘Add Member’. User selects ‘Vacancy 1’ in the Employee column from master data. User needs a place holder in the same row to add a Job Description of the vacant position.

This information can be captured in a data-point comment column. However, data-point comment feature in SAC has some restrictions like follows:

  1. Comments cannot be copied from one public version into another public version through a data action.
  2. Secondly, data-point comment is only visible at the level of story / page filter selection it is added at. So, if the filter selection is removed or changed, the comment is no longer visible in the comment cell.
  3. Additionally, commenting does not work when a user selects a dimension member property by using a story / page filter on dimension property.

Solution:

Here is the step-by-step process to resolve this issue:

  1. Add a local Dimension, of type Generic, called ‘Ref Job Description’ in the Workforce model with Month and Year set as properties of the dimension.Add%20a%20new%20Local%20Dimension%20to%20the%20Planning%20Model
  2. Populate the dimension with default value of # (Unassigned) and save the model.
  3. Add the dimension in the Input table structure in the planning story.
  4. Right-click a member from Employee column in the table and then select Add MemberAdd%20New%20Member%20to%20insert%20a%20new%20vacant%20position
  5. An empty new line appears.
  6. Add existing but unbooked Vacancy member ID ex. 999001 in Employee column in the new line.
  7. Add the Job Description free text in the Ref Job Description dimension column. Since the text does not already exist in Ref Job Description master data, you will get the following message:Member%20does%20not%20exist
  8. Enter the text in Description. ID is auto populated. Add Input Month and Input Year in Properties.
  9. Click on Apply so that the Job Description data gets updated to the master data of the dimension.Job%20Description%20/%20Comment%20added

This dimension maintains job description text of the vacant position along with the month and year when it was added. These properties help maintain the data in the dimension. The older data that is no longer needed can be manually deleted from the Job Description dimension.

Conclusion:

  1. Planning User no long needs to maintain the job description in the data point comments column.
  2. The information can be viewed at any level of story / page filter selection and can be copied from one public version to another using data action.
  3. Also, there is no restriction on filtering the table with story / page level filter on a dimension property.

文章来源: https://blogs.sap.com/2023/10/20/alternative-for-data-point-commenting-column-in-sap-analytics-cloud-planning/
如有侵权请联系:admin#unsafe.sh