Loading data using bica

[former_member510577]

Dear friends!

We builds the first scorecards with 20 kpis. We load the data from bw using bica. We build bex 9  bexs for loading the data.

1.For every kpis with the same dimensions we builds one query. For  kpis  with differents dimension we builds different bexs. If there is limit in quantity of bex query?If it quantity of bex queries influence on the performance of loading? what the best practice to divide the kpis on the bex?

2.we want to schedule automatically loading the bex queries using bica. Every month we want to load new data to the the pas differentially.What the best practice for this case - loading the full data or differentially?

BEst regards,

ORit.

[former_member220935 · Accepted solution]

Hi Orit,

For the 1st question, here is a bica best practice document for the earlier 7.x version but it should also apply to the current 10.x versions. And there should be some relevant information in this document.

http://scn.sap.com/docs/DOC-4188

As I remember, if multiple queries are imported to a PAS model, the performance of direct load from bw might be affected.

Regards,

Alicia