3753876 - Dimension filter shows "unable to retrieve data from its source" when selecting hierarchy from datasphere in live model (sap analytics cloud)

Profit center used as a story-level filter works in flat presentation but fails when hierarchy is selected.

Error displayed in the story filter: "Unable to retrieve data from its source."

HAR/log messages include: "exception 42111: SQL Error: An error occurred while executing the DDL statement. The server name: <Sever> General error;258 insufficient privilege: Detailed info for this error can be found with guid 'XXXXXXXX' The problematic query: CREATE LOCAL TEMPORARY COLUMN TABLE ..."

The issue does not happen in SAP Datasphere Analytic Model preview.
And if you go to SAP Datasphere -> Tenant Configuration -> Database Access -> HANA Cockpit -> Security and User Management -> Insufficient Privilege Details, nothing is found with above GUID.

“Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.“

• Product: SAP Datasphere, SAP Analytics Cloud
• SAC Story
• Analytic Model

1. Log in to the analytics application using a live connection to a Datasphere analytic model.
2. Open any story based on the live model.
3. Switch the story to edit mode.
4. Add a story filter for the Profit center dimension.
5. Change the filter presentation from Flat to Hierarchy, choose the desired hierarchy, select All members, and apply.
6. Open the filter value selection; the error appears: "Unable to retrieve data from its source."

The missing privilege happens in the remote source instead of in the SAP Datasphere HANA Cloud.

To find the remote source, go to SAP Datasphere -> Tenant Configuration -> Database Access -> SAP HANA Database Explorer.
See Create a Database Analysis User to Debug Database Issues | SAP Help Portal.

In the SAP HANA Database Explorer, go to Catalog -> Remote Sources, search for the Server name logged in the error message.

Open the remote source, click on "Edit" button, you can have the host of the remote HANA Cloud Database: <host>.hana.prod-xxxx.hanacloud.ondemand.com.

Go to the HANA Cockpit, open the related remote server based on the information found above. Then you can search for the GUID in Security and User Management -> Insufficient Privilege Details, find the insufficient privilege details and assign privileges.

• How to parse the GUID string in insufficient privilege error message of the database (Note 3271174)
• How to collect a HTTP archive (HAR) file and Console Log file in SAP Analytics Cloud (Note 2280022)

profit center hierarchy, story filter error, unable to retrieve data from its source, insufficient privilege 258, exception 42111, remote source privilege, live connection, datasphere analytic model, hierarchy not found, hierarchy path attribute, sac hierarchy filter , KBA , DS-MD-AM , Analytic Model , HAN-CLS-HC , HANA Cloud Services HANA Cloud , LOD-ANA-DES , Story Design & Visualizations , How To

SAP Analytics Cloud all versions ; SAP Datasphere all versions