Hi Team,
We have a business use case in a Strategic Customer project for an Actual vs Plan Report.
• Business users would like to use the ability to drill through and view the actual amount breakdown by Document Number. The Data source is SAP HANA and the data is available at a Document Number level via a View.
• The HANA view currently access tables with over 100 million records in the production environment and is created with parameters of fields such as Company Code, Fiscal Year, and GL Code to control the performance of the view.
• To retrieve data from this HANA view, it is mandatory to pass these parameters each time we query the view to replace the default parameter set in HANA view.
These parameters (COMPANY_CODE, FISCAL_YEAR, GL_CODE) are shown in the example below.
Drill Through Query :
SELECT
LEFT(CONCAT(RYEAR,POPER),'4')||RIGHT(CONCAT(RYEAR,POPER),'2') as Month,
BUKRS as Company,
BUKRS||''||PRCTR as Profit_Center,
ZZPlant as Plant,
KTOPL || '' || RACCT as Account,
LTRIM(MATNR,'0') as Material,
DOCNR as Document Number,
RH_HSL as Final Amount
FROM "_SYS_BIC"."bas.re.er2.fca.rbd/LINE_ITEM_3_PREV_YEARS_2024"
( 'PLACEHOLDER' = ('$$COMPANY_CODE$$', ''),'PLACEHOLDER' = ('$$FISCAL_YEAR$$', ''), 'PLACEHOLDER' = ('$$GL_CODE$$', '*' ) )
Note : The customer insisted that it would not be possible for them to convert the query into a staging table given the complexity of the view and the number of records. These filters need to be applied on the base tables via parameters to the view.
In a drill-through query, there is currently no way we can dynamically pass the parameter.
Can we extend the @Entity as a parameter to be used into the Drill Throughs (and by extension also Data Readers) via Manual Query or some other similar mechanism?
Cheers
