Skip to Content
0
Former Member
Apr 28, 2009 at 07:40 AM

SAP BPC 5.1 Script Logic Issue

38 Views

Hi Guys,

I have a problem with Inventory Days script logic at the moment. Basically what the logic should do is:

1. Copy the required data across to a calculation category (SQL)

2. Calculate the last 12 months Cost of Sales for every entity in the selection for 3 years (MDX)

3. Use the Cost of Sales number and multiply it with the inventory days number (SQL)

The calc works fine for some of my smaller brands (200 - 500 entities), but when i run the logic for my big brand (2000 entities) the last step doesn't calculate correctly. I have done the following to try and fix the problem.

1. Every step has it's own COMMIT

2. I clear the data before writing anything

3. I use XDIM_MAXMEMBERS Entity = 500

Any ideas why the logic is acting like this? I don't know if I am allowed to post my code here, but if it will help i will 😊

Regards,

Andries van den Berg