Loading data using bica
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?