How to pass a filter value of a dtp to the input parameter of a calculation view in source system?

[lin_huang_b]

In our BW4/HANA System, we have a datasource which is connected to a claculation view with input parameter in the source system. Is it possible to pass a filter value of a dtp from our BW system datasource to the input parameter in the source system?

[Anand71]

Is your DTP filter values are fixed or manual value or with routine?

[lin_huang_b]

DTP Filter values are fixed.

[dushmanta_das8970]

Hi,

In BW/4HANA, it is not directly possible to pass a filter value from a Data Transfer Process (DTP) to an input parameter of a calculation view in the source system. The DTP in BW/4HANA is primarily designed for data extraction, transformation, and loading into the BW system, and it does not have direct integration capabilities with calculation views in the source system.

However, there are alternative approaches you can consider to achieve the desired outcome:

create a composite provider on top of the calculation view or Modify the Calculation View: If you have access to the source system and the necessary privileges, you can modify the calculation view directly in the source system to include the required filtering logic. This way, the calculation view itself can perform the filtering based on the specified conditions, and the filtered data can be retrieved by the DTP in BW/4HANA.

[Abhishek_Hazra]

Hi lin.huang_b,

Datasources built directly on calculation views do not support their extracting DTPs to pass filter values through the input parameters. If you need to do so, you have to create a composite provider on top of the calculation view & use that as the source of DTP extraction, then you can use the input parameters as DTP filters.
Hope this answers your question.

Best Regards,
Abhi