Skip to Content
avatar image
Former Member

Loading data using bica

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,


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jun 02, 2015 at 01:23 AM

    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.

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



    Add comment
    10|10000 characters needed characters exceeded