Symptom
- Data source (query) is greyed out and cannot be accessed in embedded SAP Analytics Cloud (eSAC) - SuccessFactors (SFSF) story report
- When opening affected story report noticing the error: 'Server Error: The table failed to initialize: You do not have the correct permissions to open that model.'
-
Affected Data source is greyed out under the 'Data source' menu option
-
Duplicating gives the following error: Please contact your administrator.
This filter is no longer usable because the data source, dimension, selected hierarchy or custom group no longer exists; the dimension has a missing required hierarchy; or the dimension type has changed.
An error occurred while fetching the list of members - Error found in HAR - Network traces > contentlib -> Preview tab: No properties - no model can be found
Environment
- Embedded SAP Analytics Cloud 2024.2.3
- SAP SuccessFactors (SFSF)
Reproducing the Issue
- Login to SAC tenant
- Login to SuccessFactors (SFSF)
- Navigate to Reporting in SFSF
- Select the affected story report
- Run the affected Story report
- Switch to Edit mode
- Notice
- the error in the table: 'Server Error: The table failed to initialize: You do not have the correct permissions to open that model.'
- the greyed out data source in Edit mode
- after duplication: Please contact your administrator.
This filter is no longer usable because the data source, dimension, selected hierarchy or custom group no longer exists; the dimension has a missing required hierarchy; or the dimension type has changed.An error occurred while fetching the list of members.
Cause
Data source that wouldn't open in the story no longer exists in the database.
Resolution
- Add the same Data source again and set the Data source of the table.
- Or remove the table and re-add both the table and Data source.
See Also
- 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
- Have a question? Ask it here and let our amazing SAP community help! Or reply and share your knowledge!
- 2487011 - What information do I need to provide when opening an incident for SAP Analytics Cloud?
- SAP Analytics Cloud > Learning > Guided Playlists
- SAP Analytics Cloud > Learning > Guided Playlists > Getting Support
- Need More Help? Contact Support or visit the solution finder today!
Your feedback is important to help us improve our knowledge base.
Keywords
Data source, query, cannot, unable, inaccessible, not accessible, SuccessFactors SFSF, embedded SAC, embedded, eSAC, SAP Analytics Cloud, Analytics Cloud, SAP Analytic Cloud, Analytic Cloud, story, report, error, Server Error: The table failed to initialize: You do not have the correct permissions to open that model, Server Error, The table failed to initialize, You do not have the correct permissions to open that model, not have the correct permissions to open, greyed, grey, Duplicating, Please contact your administrator. This filter is no longer usable because the data source, dimension, selected hierarchy or custom group no longer exists; the dimension has a missing required hierarchy; or the dimension type has changed., Please contact your administrator, This filter is no longer usable, hierarchy or custom group no longer exists, missing required hierarchy; or the dimension type has changed, the dimension type has changed, An error occurred while fetching the list of members, HAR file, HAR, Network traces, Network, traces, contentlib, Preview tab, No properties - no model can be found, No properties, no model can be found, reporting, Edit mode, Edit view, Edit, no longer exists in the database, no longer, not, exist, database, , KBA , LOD-ANA-OEM , Embedded usage of SAP Analytics Cloud , Problem