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

BW Variables generated by annotation @Consumption.filter

Filter variables of the BW query can be expressed with @Consumption.filter annotations in CDS views. As an alternative to the filter annotation, you can introduce a parameter and use it in the where clause. See example Query using Parameter. Variables and Filters are always so called hard filters (characteristic restrictions, see OLAP Filter Handling)).

In the following we show a simple example:

ABAP Perspective in Hana Studio

Note that this variable is ignored by the Data Preview in the Hana Studio. We need to run the query in order to check this annotation.

Transaction RSRT

Whe we run this query in RSRT, a corresponding variable popup appears. We also use the debug function 'Disyplay SQL/SAP Hana Query' in order to get the Analytics API statement displayed: 

Query Result:

 

Note: In case a @Filter annotation is used for an element that is filtered in the WHERE condition as well, the filter annotation will be ignored!

 

 

  • No labels