Symptom
SAP HANA input parameter not recognized in SAP Analytics Cloud (formerly known as SAP BusinessObjects Cloud / BOC)
Environment
- SAP Analytics Cloud
- SAP HANA 1.00.122.11
Reproducing the Issue
- Create a Calculation View in SAP HANA
- Add an Input Parameter to the Calculation View
- Add a Calculated Column to the Calculation View that uses the Input Parameter
- Create an SAP Analytics Cloud Connection, Model and Story from the SAP HANA system and Calculation View
- Notice after a while that the value of the Input Parameter is replaced with the name of the Input Parameter
Cause
This SAP HANA issue has been identified and logged under SAP Note 2528439 - SAP HANA 1.0 SPS 12 Database Maintenance Revision 122.13
"Fixed an issue leading to incorrect results for calculated measures with generated calculation scenarios. The issue could occur when there was no REQUEST node on top of the generated scenario. This was observed especially in MDS scenarios when an equivalent SQL query could return the correct result."
Resolution
Update your SAP HANA system to 1.00.122.13
For SAP HANA On Premise Systems please follow: Updating the SAP HANA System
For SAP HANA SAP Cloud Platform Systems follow: Update SAP HANA Database Systems
See Also
- Help resources and free SAP Analytics Cloud content
- Help portal
- SAP Community (Questions & Answers / Direct Link to ask question / Blogs)
- SAP Community WIKI
- Improvement requests (on the SAP Customer Influence portal)
- Video tutorials
- Videos by topic areas: (Overview, Models and Connections, Stories, SAP Digital Boardroom, Planning, Collaboration, Administration)
- Training events
- Past event recordings
- New user handbook
- Roadmap
- How to connect to on-premise data
- 2487011 - What information do I need to provide when opening incidents with SAP Analytics Cloud
- Introducing SAP BusinessObjects Cloud: BI and Planning (SAP Press book)
Your feedback is important to help us improve our knowledge base.
Please rate how useful you found this article by using the star rating feature at the beginning of this article.
Thank you.
Keywords
EPM, SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Hana 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, connecting, conecting, conectando, conexão, modelo, SBOC, SAC, SAP BusinessObjects Cloud, Business Objects, SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, input, parameter, calculated, calculation, prompt , 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