Symptom
- When attempting to convert this classic story to optimized design, the following warning message is displayed:
- "Something went wrong while converting the story to Optimized Design Experience. Invalid flexible granularity: Date.PATTERN_FISC_CALWEEK".
Environment
SAP Analytics Cloud 2024.15.6
Reproducing the Issue
- Log in to the SAC tenant;
- Access the story;
- From the tool bar select "Convert to Optimized story experience";
- Choose "Save" or "Save as" option;
>> Notice the error message: "Something went wrong while converting the story to Optimized Design Experience. Invalid flexible granularity: Date.PATTERN_FISC_CALWEEK"
Cause
- The issue lies in the caching of the conversion mechanism. Some metadata required by conversion mechanism is missing.
- If the story contains hidden pages may this KBA can be used as the cause and resolution: KBA 3518474 - Error: "Something went wrong while converting the story to Optimized Design Experience" in SAP Analytics Cloud (SAC)
Resolution
Click on every single tab of the story before converting it. Clicking on every tab forces loading of all required metadata and conversion can complete successfully.
See Also
- KBA 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
- KBA 2487011 - What information do I need to provide when opening a case for SAP Analytics Cloud?
- KBA 2511489 - Troubleshooting performance issues in SAP Analytics Cloud
- SAP Analytics Cloud Connection Guide
- SAP Analytics Cloud Get More Help and SAP Support
- Need More Help? Contact Support
Keywords
SAC, Story, Convert, Optimized, ODE, Save, Warning, Error, Something went wrong, caching, metadata , KBA , LOD-ANA-DES , Story Design & Visualizations , LOD-ANA-TAB , Table , Problem
Product
SAP Analytics Cloud 1.0
SAP Knowledge Base Article - Public