Can we use 0INFOPROV as a selection in Load from Data Stream

152 Views

Hi,

We have implemented BW-SEM BPS and BCS (SEM-BW - 602 and BI 7 ) in our company.

We have two BPS cubes for Cost Center and Revenue Planning and we have Actuals Data staging cube, we use 0SEM_BCS_10 to load actuals.

We created a MultiProvider on BPS cubes and Staging cube as a Source Data Basis for BCS.

Issue:

When loading plan data or Actuals data into BCS (0BCS_C11) cube using Load from Data Stream method, we have performance issue, We automated load process in a Process Chain. Some times it take about 20 hrs for only Plan data load for 3 group currencies and then elimination tasks.

What I noticed is, (for example/) when loading Plan data, system is also reading Actuals Cube which is not required, there is no selection available in Mapping or selection tab where I can restrict data load from a particular cube.

I tried to add 0INFOPROV into databasis but then it doen't show up as selection option in the data collection tasks.

Is there a way where I can restrict data load into BCS using this load option and able to restrict on cube I will be reading data from ?

I know that there is a filter Badi available, but not sure how it works.

Thanks !!

Naveen Rao Kattela