SAP Knowledge Base Article - Public

3732446 - Unable to delete a data source in Story Report - "This data source is in use. You must remove on Story level - Assigned Colours".

Symptom

User cannot delete a data source, getting error "This data source is in use. You must remove the following items that use this data source before deleting it. Story level - Assigned Colours."

Environment

  • SAP SuccessFactors HCM Core 2505
  • Platform - Story reporting

Reproducing the Issue

  1. Login the instance
  2. Select a story report
  3. Select data source > Delete data source
  4. an error occur :   "This data source is in use. You must remove the following items that use this data source before deleting it. Story level - Assigned Colours."

Cause

The story has a conditional formatting with assigned colours 

Resolution

User must delete first Conditional Formatting before deleting the data source.

  1. Login
  2. Report Centre
  3. Open the affected story
  4. From the Tools menu > select Conditional Formatting.
  5. In the Conditional Formatting panel, expand the Story Defined section.
  6. Select Assign Colors.
  7. The Assign Colors panel appears, displaying a model, a dimension, and the dimension members.
  8. Choose your model.
  9. Choose a dimension.
  10. In the Dimension Members section, select a member's color option list and change the color.
  11. If you do not want to assign a color to a member, clear the check box. That member will now use the color palette from the chart builder.

When you have finished assigning or removing colors, click Apply.
To close the Conditional Formatting panel, click Done.

See Also

see also on portal : https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/00f68c2e08b941f081002fd3691d86a7/6a656677cdcd4da3a292c9ee9cde5a39.html

Keywords

Story, Error, delete, data source,, story level, conditional formatting, colors, panel, Assign Colors.  , KBA , LOD-SF-ANA-SAC-QDS , Query Designer - Filter, Calculated Column, Params , Known Error

Product

SAP SuccessFactors HCM Core 2505