Compute Balance Sheet out of Balance through Script logic?

[Former Member]

Our app is built and it works fine. We are now focused on trying to reduce processing time.

We are looking for a faster way to compute the OutOfBalance amount for Balance sheets that have been loaded and the sum of the Balance sheet is not zero.

We are working with approximately 1500 entities so even a saving of a half second per entity adds up to significant savings!

All suggestions are appreciated.

[i045436]

Hello,

I don't know what BPC version are you using( I suppose you are using BPC for Microsoft)

In order to optimize your script logic, you have to start from your logic LOG file in order to find out where is the problem.

For example: if you have big queries which are taking a lot if time, you can use XDIM_MAXMEMBERS in order to split in small queries that can run faster.

The recommendations we give the administrator when trying to optimize logic can be summarized into ten Golden Rules:

1. Stay away from MDX logic

2. Load in memory only the required data

3. Carefully select the u201Ctriggersu201D of your calculations

4. Keep the logic structure as compact as possible

5. Minimize the number of COMMITs

6. Minimize the number of GO statements

7. Keep in default logic only the calculations that are absolutely required to be performed in real time

8. Carefully check what the LOG files say

9. Avoid refresh after send in Excel

10. Run a stress test before going live

Regards,

Mihaela