SAP Knowledge Base Article - Public

2665239 - Value Help is not working for Prompts which has hierarchy in them , HANA Input Variable with hierarchy.

Symptom

  • Members are not getting displayed at all
  • An error appears on the User Inteface "Illegal State: stateful variable handling cannot be mixed with direct variable transfer - Error: Illegal State: stateful variable handling cannot be mixed with direct variable transfer"


2018-07-02 05:46:01.375000 getThreads - response returns CommentDataProvider
jquery.sap.global-dbg.js:999 2018-07-02 05:46:17.716000 Code: 42551 Text: The member doesn't exist in the hierarchy : The member '0006' does not exists or is not unique and will be removed from the selection for variableIV_HierarchySelection - 
K @ jquery.sap.global-dbg.js:999
jquery.sap.global-dbg.js:999 2018-07-02 05:47:01.323000 Illegal State: stateful variable handling cannot be mixed with direct variable transfer - Error: Illegal State: stateful variable handling cannot be mixed with direct variable transfer
    at Object.createIllegalStateException (https://assets.sapanalytics.cloud/production/uiAssets-2018.11.3/uiAssets/app.chunk.firefly-runtime-chunk.e720c692b09e1c6d9002.js:2:2061)
    at e.InAQueryManagerProvider.assertNotDirectValueTransfer (https://assets.sapanalytics.cloud/production/uiAssets-2018.11.3/uiAssets/app.chunk.firefly-olap-chunk.7491917656f718611619.js:2:487104)
    at e.InAQueryManagerProvider.processSetGetVariableValues (https://assets.sapanalytics.cloud/production/uiAssets-2018.11.3/uiAssets/app.chunk.firefly-olap-chunk.7491917656f718611619.js:2:487490)
    at e.InAQueryManagerProvider.transferVariables (https://assets.sapanalytics.cloud/production/uiAssets-2018.11.3/uiAssets/app.chunk.firefly-olap-chunk.7491917656f718611619.js:2:488630)
    at e.exports.sap.fpa.ui.control.dataproviders.variable.DimensionMember.sap.fpa.ui.control.dataproviders.variable.DimensionMember._prepareDimension (https://assets.sapanalytics.cloud/production/uiAssets-2018.11.3/uiAssets/app.chunk.9.slice_of_main-chunk.fc508d41420e56e1a5ad.js:2:461971)
    at e.exports.sap.fpa.ui.control.dataproviders.variable.DimensionMember.sap.fpa.ui.control.dataproviders.variable.DimensionMember.getData (https://assets.sapanalytics.cloud/production/uiAssets-2018.11.3/uiAssets/app.chunk.9.slice_of_main-chunk.fc508d41420e56e1a5ad.js:2:462315)
    at f.sap.fpa.ui.control.memberselector.MemberSelector._executeGetData (https://assets.sapanalytics.cloud/production/uiAssets-2018.11.3/uiAssets/app.chunk.8.slice_of_main-chunk.edf5d498969d9ba2d64c.js:2:107041)
    at f.sap.fpa.ui.control.memberselector.MemberSelector.prepareData (https://assets.sapanalytics.cloud/production/uiAssets-2018.11.3/uiAssets/app.chunk.8.slice_of_main-chunk.edf5d498969d9ba2d64c.js:2:80564)
    at f.sap.fpa.ui.control.memberselector.MemberSelector.generateContent (https://assets.sapanalytics.cloud/production/uiAssets-2018.11.3/uiAssets/app.chunk.8.slice_of_main-chunk.edf5d498969d9ba2d64c.js:2:27125)
    at Object.sap.fpa.ui.control.memberselector.MemberSelectorRenderer.prepareForm (https://assets.sapanalytics.cloud/production/uiAssets-2018.11.3/uiAssets/app.chunk.8.slice_of_main-chunk.edf5d498969d9ba2d64c.js:2:669305)
K @ jquery.sap.global-dbg.js:999
/sap/fpa/services/rest/epm/error?tenant=2:1 Failed to load resource: the server responded with a status of 500 ()
jquery.sap.global-dbg.js:999 2018-07-02 05:47:01.530000 error - 500 - error -  sap.fpa.ui.infra.service.ErrorService
K @ jquery.sap.global-dbg.js:999

Environment

  • SAP Analytics Cloud 2018.11.3
  • HANA Live Connection

Reproducing the Issue

  1. Connect to HANA via Live Connection
  2. Have a Calculation View with with input variable with hierarchy on it
  3. Create a story
  4. Try to fill out the prompt value
  5. Execute Value Help for the prompt with hierarchy
  6. Notice the error message

TCC Value Help HANA LIVE Input Variable with Hierarchy.PNG

Cause

This particular feature is not supported yet.

For more information https://help.sap.com/doc/00f68c2e08b941f081002fd3691d86a7/2018.11/en-US/6ac0d03d53f3454f83d41c6f51c2fc31.html

Resolution

Unsopported feature at this moment.

See Also

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

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 , KBA , LOD-ANA , SAP Analytics Cloud , LOD-ANA-BI , SAP Analytics Cloud - Business Intelligence (BOC) , LOD-ANA-PL , SAP Analytics Cloud – Planning (BOC) , LOD-ANA-BR , SAP Analytics Cloud - Digital Boardroom , LOD-ANA-PR , SAP Analytics Cloud – Predictive (BOC) , Problem

Product

SAP Analytics Cloud 1.0