Cube taking a long time to move data
Posted: Wed Feb 22, 2012 5:17 am
I have a cube that has rules that reads data from 4 other cubes and comes with feeders. I created a process to move data from one element to another within that cube and the cell that contains the value is not reference by the rules. The data that needs to be moved is not much. But it seems like during the process is executed, what i saw on tm1top is the rules is process over and over again and it has been 1 hour and 30 mins and the process is not finish yet. What may cause this issue ? Is there a code where i can un attach the rules before running the process and attach the rules back in once the process is done ?
Code: Select all
Run:R(p_Job_Title_Rate)-(Rule) ProcessExecuteEx (R)1(IX)0(W)0 (R)38(IX)51(W)0 3263
Run:R(p_GWAC_Consumption)-(Rule) ProcessExecuteEx (R)1(IX)0(W)0 (R)38(IX)51(W)0 3265
Run:R(p_Actuals)-(Rule) ProcessExecuteEx (R)1(IX)0(W)0 (R)38(IX)51(W)0 3267
Run:R(}ElementAttributes_SalesHierarchy_Reporting)-(Cube) ProcessExecuteEx (R)1(IX)0(W)0 (R)38(IX)51(W)0 3269
Run:R(CustomerHierarchy)-(Dimension) ProcessExecuteEx (R)0(IX)0(W)0 (R)38(IX)51(W)0 3271
Run:R(}ElementAttributes_p_GL_Account)-(Cube) ProcessExecuteEx (R)1(IX)0(W)0 (R)38(IX)51(W)0 3273
Run:R(p_Value_Add_Reporting)-(Rule) ProcessExecuteEx (R)1(IX)0(W)0 (R)38(IX)51(W)0 3275
Run:R(p_Order)-(Dimension) ProcessExecuteEx (R)0(IX)0(W)0 (R)38(IX)51(W)0 3277
Run:R(p_SystemControl)-(Rule) ProcessExecuteEx (R)1(IX)0(W)0 (R)38(IX)51(W)0 3279
Code: Select all
IF ( CellisUpdateable(vCube, p_GL_Account, SalesHierarchy_Reporting, CustomerHierarchy, p_Time, Sector, p_Site, p_Version, p_Scenario, p_Value_Add_m
) = 1);
CellPutN (Value, vCube, p_GL_Account, SalesHierarchy_Reporting, CustomerHierarchy, p_Time, Sector, p_Site, p_Version, p_Scenario, p_Value_Add_m)
;
ENDIF;