SAP Knowledge Base Article - Public

2821531 - RESTRICT Formula does not work in SAP Analytics Cloud (SAC) & SAP Digital Boardroom - 2019.15.1

Symptom

RESTRICT function does not give any result.

Environment

  • SAP Analytics Cloud 2019.15.1

Reproducing the Issue

  1. Cretae a story based on dimensions that use RESTRICT Formula
  2. Notice there is no data displayed

Cause

The specified formula RESTRICT([dim1],[d/dim2] =("Desc1", "Desc2") ) in the Model is incorrect, the user used description instead of IDs.

Resolution

Please correct the formula by either using the formula based on ID like as mentioned below:

RESTRICT([dim1],[d/dim2] =("ID1", "ID2") )

or if you want to use the formula based on the description please use it with property Description option(p/Description), which will be available, as value help, if you use CTRL+SPACE . Formula corrected below:

RESTRICT([dim1],[d/dim2].[p/Description] =("Desc1", "Desc2") )

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 , 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 Predicitive , Bug Filed

    Product

    SAP Analytics Cloud 1.0