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

[Former Member]

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

[former_member1379680]

Hi Naveen,

Do you use Value Type in the BCS transactional cube itself?

If so, what for?

otherwise I assume it is just for mapping.

Have you solved your issue / did you go with redesign?

[Former Member]

Hi,

I'm afraid that restriction the LFDS methods by infoprovider without big redesign is hardly possible.

But. Why do you need to make a restriction on 0INFOPROV only? There are must be the other chars by which you discriminate between plan and actual data, right? Something like a 'Data Type' or a special coding for FS items or somthing else.

You may use it in the restriction of the source (and/or target) data in the LFDS method config. That's what these tabstrips are stay for. Restriction by 0INFOPROV is usable in BEx queries. Not sure about BCS.

[Former Member]

Thanks Eugene,

We do have other characteristics like Value Type (10 = Actual and 20 = Plan) and Version (100 = USD Actual and 200 = USD Plan), but when I am loading data into BCS using Load from Data Stream method, the request goes to all the underlying cubes, which in my case are Planning cubes and Actual Cube, but I don't want request to goto Actual Cube when I am running only Plan load. I think its causing some performance issue.

For this reason I am thinking if I can use 0INFOPROV as we use in Bex queries to filter the InfoProvider so that the data load performance will improve.

I was able to to bring in 0INFOPROV into DataBasis by adding 0INFOPROV in the characteristics folder used by the Data Basis.

I am able to see this InfoObject Data Stream Fileds tab. I checked marked it to use it in the selection and regenerated the databasis.

I was expecting that now this field would be available for selection in data collection method, but its not.

So If its confirmed that there is no way we can use 0INFOPROV as a selection then I would suggest my client for a redesign of the DataBasis it self.

Thanks,

Naveen Rao Kattela

[former_member209721]

Sorry, I don't understand your case : if you have a cube for actuals data, why don't you define the Load from data stream method for actual data on this cube (only) ? Same for Plan flow ?

[Former Member]

Hi Naveen,

What if you add the actual and plan infoproviders to the source data basis individually as well and then try?

Regards

Shashi

[Former Member]

Thanks for you response.

This option would be a major change for our BCS design.

I am trying to avoid major changes to the DataBasis as we are already live since about 2 years.

Thanks,

Naveen Rao Kattela