SAP Knowledge Base Article - Public

3030595 - Input control in SAC cannot recognize hierarchy nodes from HANA

Symptom

  • The input control in SAC can't recognize hierarchy correctly.
  • If select one of value in input control, error happens below:

    Caught exception: exception 70000007: feature not supported: cannot support non-constant expression: _validation_(SQL Script function***)

Environment

  •  SAP Analytics Cloud 2021.2.8
  •  Live HANA on cloud connection

Reproducing the Issue

  1. Set permission to user in HANA to make user can see some of the nodes of hierarchy object.
  2. Create model based on live HANA on cloud connection.
  3. Create story and select the hierarchy object to make it display in table.
  4. Create input control for the hierarchy object.
  5. The hierarchy nodes are not recognized as hierarchy correctly in the input control selection.
  6. If select one of the value, error happens below:

    Caught exception: exception 70000007: feature not supported: cannot support non-constant expression: _validation_(SQL Script function***)


  7. If select all the values in the input control, the hierarchy structure are displayed successfully in the table.

Cause

This issue is currently under investigation by Development.

Resolution

This issue is currently under investigation by Development.

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, EPM-ODS, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, hierarchy, hierarchies, node, nodes, object, input, control, filter, filters, selection, selections, value, values, error , exception, feature, not , supported , KBA , LOD-ANA-LDC-HAN , SAC Live Data Connection HANA , Problem

Product

SAP Analytics Cloud 1.0