Symptom
When opening a Story based on HANA Live Data Connection, the following error appears in the chart in SAP Analytics Cloud (SAC):
"Unable to retrieve data from the datasource. Error:[Caught exception : exception 42028: Invalid Object caught : Object of type N3mds3mdq4cube4CubE is invalid.]
Environment
- SAP Analytics Cloud 2019.4.5
- Live Data Connection to SAP HANA
Reproducing the Issue
- Logon to SAC.
- Open a Story which is based on HANA Live Data Connection.
- Notice that the charts show the above mentioned error message.
Cause
The underlying measure has been defined as a String measure with SUM aggregation type. The SUM aggregation type is not valid for a String measure.
Resolution
- Either switching the aggregation type to MIN or MAX
OR - Removing the measure from the model resolves the problem
See Also
- How to find User Assistance for SAP Analytics Cloud?
- Have a question? Ask it here on the SAP Community. Or reply and share your knowledge!
- 2487011 - What information do I need to provide when opening incidents with SAP Analytics Cloud (Hint: Use component LOD-ANA*)
- SAP Analytics Cloud > Learning > Guided Playlists
Your feedback is important to help us improve our knowledge base.
Keywords
SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, error, unable, retrieve, data, datasource, caught, exception, invalid, object , KBA , LOD-ANA , SAP Analytics Cloud (SAC) , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , LOD-ANA-PL , Planning , LOD-ANA-BR , SAC Boardroom , LOD-ANA-PR , SAC Predictive , Problem