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
- Login the instance
- Select a story report
- Select data source > Delete data source
- 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.
- Login
- Report Centre
- Open the affected story
- From the Tools menu > select Conditional Formatting.
- In the Conditional Formatting panel, expand the Story Defined section.
- Select Assign Colors.
- The Assign Colors panel appears, displaying a model, a dimension, and the dimension members.
- Choose your model.
- Choose a dimension.
- In the Dimension Members section, select a member's color option list and change the color.
- 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
SAP Knowledge Base Article - Public