Not possible to push on Hana the Bex Background filters on BW 7.4 on Hana

[former_member557379]

Hello Gurus,

We are facing some troubles with background filters in a bex query that exploit an HANA composite provider built on a Calculation View. When we apply a background filter on a dimension (using Analysis for Office to view the query built using Bex), the query applies that filter to the data already extracted (instead of pushing down on the Hana level the calculation and reextract the result). We require that the data are re-extracted from the HANA composite provider considering the applied background filter (i.e. they should be working as Input Parameters).

We already tried with the following code:

Call Application.Run("SAPSetRefreshBehaviour", "Off")

Call Application.Run("SAPSetFilter", "DS_1", "DIMENSION", "P01";P02")

Call Application.Run("SAPSetRefreshBehaviour", "On")

Call Application.Run("SAPExecuteCommand", "Restart", "DS_1")

But these are not fulfilling our requirement.

How can we get the background filter working as Input Parameter hence pushing down every time the calculation of our KPIs on HANA level?

Thank you