Symptom
The below error occurs when expanding a filter in SAC story:
"An error occurred while fetching the list of members.
{"code":"UNCATEGORIZED_SERVER_ERROR", "message":"No authorization","details":null}"
Environment
SAP Analytics Cloud
Reproducing the Issue
- Login to SAC.
- Open a story based on a live BW model using a restricted user.
- Expand a page filter.
- Observe the error.
Cause
- The issue occurs when authorization variables are used as dynamic filters (DFs) in BW queries.
- In these cases, dynamic filters are not applied during LOV (List of Values) queries when expanding filters in a story. As a result, users with restricted BW data access encounter authorization errors.
Resolution
- To resolve the issue, authorization variables should be moved to Fixed Filters instead of being used as dynamic filters.
- This ensures that authorization restrictions are consistently applied during LOV queries.
Keywords
SAC, SAP Analytics Cloud, Authorization Error, Filter Expansion, Cascading Value Help, BW, Hierarchy Authorization, UNCATEGORIZED_SERVER_ERROR , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem
Product
SAP Analytics Cloud 1.0