SDI integration to BW4HANA: not possible to specify filter

[dzianis_anishchanka2]

Hello!

We have following scenario: data from Oracle replicated to BW4HANA with the help of OracleLogReaderAdapater of SDI. So remote source system created in HANA used as a basis for BW source system of type HANA SDA and then datasources as replication tasks.

When using SDI directly to HANA, there is a way to set an sql filter on replication task. But in our case in HANA studio we cannot find a place for setting a filter on BW datasource (so that only filtered data initialized and replicated).

If I open the datasource via BW4HANA Cockpit, there is a field Static Filter (SQL) but this interface doesn't allow to edit datasources and raises a message, that editing has to be performed using BW modelling tools. But in BW-MT there is no such field on datasource maintenance.

So does anyone know how to set an sql filter for SDI replication tasks, which created as BW datasource on HANA SDA source system?

Best Regards,

Denis.

[GordonW]

Hi Dzianis,

a static filter condition (SQL) is already available for Hana Datasources:

https://help.sap.com/viewer/107a6e8a38b74ede94c833ca3b7b6f51/2.0.6/en-US/75af177bf3ee437c8a4fe0cf10c...

It is available since SAP BW 7.5.

Grüße

Gordon.

[dzianis_anishchanka2 · Accepted solution]

Hi,

The problem is solved by adding parameter 'F' into field DP_SETTING of table RSLOGSYSDB for the corresponding BW source system. After that the SQL filter option appears on every datasource. This was reply from SAP.

Best Regards,

Denis.

[paulvatter · Accepted solution]

Hi Denis,

really intuitive! 🙂

But thank you very much, you helped us a lot - (and Greta would be thankful as well for saving quite some energy while replication)!

Best regards

Paul

[erdempekcan]

Hi,

It's possible to set filters on datasources based on SDA Source Systems. Did you try this option already?

Regards,
Erdem

[paulvatter]

Hi erdempekcan

thanks for your answer...

To my understanding this selection option is only applicable in the DTP which is based on the datasource.

My question is targeting to the transaction RSDSHANA for SDI, where we first need to start the replication of the source tables into the target tables in BW/4, which is then the basis of the (delta-enabled!) DTPs...

I would expect an option at least on the datasource to define a SQL-filter (e.g. MANDT='100' or even BUKRS <> 'CH99') to already filter the replication itself and not only in the DTP above...

Thanks and best regards

Paul

[erdempekcan]

That screenshot is from the datasource. However, you're right, the usage option is available through DTP only.

That kind of filtering was never possible at datasource level. I expect a similat usage at Composite Provider as well 🙂

I think that's something to define at flowgraph. I didn't experince it a lot but I'm sure it provides a filtering object, right?
https://www.youtube.com/watch?v=F0h7aZ-uM8o

[paulvatter]

Hi Dzianis, Jeff and other SAP BW experts...

do you know if there any update on this topic maybe in BW/4 2.0?

Still wondering whether there is any editing option for this setting here - have not found any neither:
https://help.sap.com/viewer/107a6e8a38b74ede94c833ca3b7b6f51/2.0.5/en-US/75af177bf3ee437c8a4fe0cf10c...

If anyone found an edit option for the created remote subscriptions this of course might also be interesting...

Thanks and best regards
Paul

[dzianis_anishchanka2]

Nope, the topic is still open.

[jeff_k]

Hi Denis,

There are a few approaches to this, I think the clearest way might be to make the replication task yourself in HANA Workbench and include the filter there, then just have BW/4HANA consume the target table of that replication.

Even if you are having BW/4HANA create the reptasks & subscriptions for you, I think they should be available in the HANA Editor for tweaking. So you can check there and make changes then save and it should be respected by BW.

• https://help.sap.com/viewer/107a6e8a38b74ede94c833ca3b7b6f51/1.0.11/en-US/fc72c2f2478e4d75a16e688bc7...
• https://help.sap.com/viewer/71c4a6e6b4dc4a5ab3e17bb1d7e98104/2.0_SPS03/en-US/cc832d5253c54ff4ae86b02...
  

Regards,
Jeff K - SDI Support

[dzianis_anishchanka2]

Hi Jeff,

Sorry for delay in answer.

I thought so too, that it would be possible to find these replication tasks via HANA workbench and modify. But I don't see them in any package.

You mentioned, that there are several approaches. What are the other ones?

Best Regards,

Denis.

[former_member231709]

Hi! Did you solve problem with filter?