Registration

Dear SAP Community Member,
In order to fully benefit from what the SAP Community has to offer, please register at:
http://scn.sap.com
Thank you,
The SAP Community team.
Skip to end of metadata
Go to start of metadata

CDS Query: Parameter used in Formula (OLAP Formula Variable)

ABAP Perspective in Hana Studio

Definition of CDS View

You can see that there are two formulas which use the parameter p_seats. As discussed in Simple CDS View Query with formulas and restrictions, the formula which uses the annotation AnalyticsDetails.query.formula is only interpreted by the Analytic Engine. Hence, when the DataPreview is used in the Hana Studio the corresponding column only contains 1.

Hana Studio: DataPreview

Transaction RSRT

When the query is executed in RSRT, all key figures deliver the correct values:

Please note, the the formulas (plus/minus 5) are calculated after aggregation(e.g. 9.975 + 5 = 9.980). This is the default of the Analytic Engine, see Formulas and Calculated Key Figures for more details.

 

  • No labels