Skip to Content
0
Former Member
Jul 15, 2008 at 01:49 AM

Loading of data after modifying a script takes a VERY long time to complete

33 Views

Weu2019re working on a small POC. Below is the first script we added in default.lgl. This is supposed to calculate the account u201CService Feesu201D which is defined to be a product of the drivers Headcount and Allowance.

// Service Fees = Headcount * Allowance

*WHEN ACCOUNT

*IS E82101

*REC( FACTOR=GET(ACCOUNT="E82201"), ACCOUNT="E82001")

*ENDWHEN

*COMMIT

It took 2-3 hrs of processing dimensions and database, optimizing cubes in and out of console and running the package default formulas before it run well (i.e. schedules doesnu2019t hang and sending of data was successful). Aside from the processing and optimizing cubes and database, we also tried commenting out the script and even removing it completely but it still didnu2019t work. And when we added the script below (which is for pushing data from Sales to Finance), the same problem had occurred but now its worse. It took almost a day before it did run.

//Move Sales Force Opex (i.e. Service fees, Site Visit) accounts to Finance app

*DESTINATION_APP=FINANCE

*SKIPDIM=SALESFORCE

*ADD_DIM INTCO=NON_INTERCO

*ADD_DIM PRODUCT=NOPRODUCT

*XDIM_MEMBERSET=E82001,E82002

*WHEN ACCOUNT

*IS<>""

*REC(FACTOR=1,DATASRC="SALESAPP")

*ENDWHEN

*COMMIT

But all calculations turned out to be correct. We canu2019t see any problem in regards with the syntax. However, there is a problem with the time the system updates with the new calculations/script. It seems like the more script we add, the poorer the systemu2019s performance becomes.

Are we missing something to improve the loading of data after a certain script is modified? In our case, what happens is either it takes a couple of hours before data is loaded or BPC Excel simply does not respond afterwards.

Edited by: Melvin Alegre on Jul 15, 2008 3:50 AM

Edited by: Melvin Alegre on Jul 15, 2008 3:52 AM