2525191 - SAP Analytics Cloud Best Practice: Troubleshooting Live HANA issue with SAP HANA Multi-Dimensional Services (MDS) query/trace

• SAP HANA Multi-Dimensional Services (MDS) is used to process multidimensional queries including aggregation, transformation and calculation in SAP Analytics Cloud (SAC).
• Through HANA MDS, queries are translated into a SAP HANA calculation engine execution plan or SQL, which is executed by the HANA core engines (see SAP Note 2670064).
• SAC will send MDS queries through HTTP/HTTPS requests to this service to get a response for live data connections.
• How to extract the MDS query as well as the response from HTTP/HTTPS trace?
• How to execute the MDS query to reproduce the problem in HANA in order to troubleshoot a SAC Live HANA issue?

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

• SAP Analytics Cloud (Enterprise)
• SAP HANA

  Service package	HANA revision
  HANA 1.0 SPS 12	122.12
  HANA 2.0 SPS 01	12.02
  HANA 2.0 SPS 02	21.00
  all subsequent releases
• Live data connection

query, InA, SAP Cloud for Planning, live, remote, sc4p, c4p, cforp, cloudforplanning,Cloud for Planning, EPM-ODS, Cloud for Analytics, C4P, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, HCP, C4A, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJ, BOBJcloud, BOCloud., BICloud, BO Cloud, SBOC, SAC, SAP BusinessObjects Cloud, Business Objects, SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, trace, mds, ina, CORS, debug, Live data source is showing different results in SAC compared to the data source, SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, connected, failure, stopped, sap analyst cloud, https://hcs.cloud.sap, https://hanacloudservices.cloud.sap, https://cloudanalytics.accounts.ondemand.com, https://hanacloudservices-us.accounts.ondemand.com, https://www.sap.com, https://help.sap.com, predictive analytics (analysis), data analysis (analytics) tools, analytics tools, sap analytics cloud, data literacy, advanced analytics, data democratization, analytics software, real time analytics, self service analytics, advanced data analytics, analytics as a service, analytics cloud / cloud analytics, saas analytics, cloud bi, enterprise planning, cloud data analytics, cloud based analytics, analytics cloud platform, modern analytics, real time analysis, cloud analytics solution(s), what is sap analytics cloud, cloud analytics tools, analytics in the cloud, cloud analytics software epm, business intelligence, , KBA , memory error when calling from sac , unable to retrieve data from data source , hana cannot allocate enough memory error , LOD-ANA-LDC-HAN , SAC Live Data Connection HANA , LOD-ANA-PL , Planning , LOD-ANA-BR , SAC Boardroom , LOD-ANA-DES , Story Design & Visualizations , How To