Hi,
I've defined rules in Account Transformation and I've written the following code in my script logic.
*RUN_STORED_PROCEDURE = SPRUNCALCACCOUNT('WJEFD','ACTUAL','LC','%SCOPETABLE%','%LOGTABLE%','CF')
I chose 2006.JAN and sent data. The stored procedure worked perfectly fine and I got my expected results.
------------------------- Building sub-query 1 ------------------------- Query Type:0 Max members: Executing SPRUNCALCACCOUNT 'WJEFD', 'ACTUAL','LC', 'SPSCOPE_671183','SPLOG_250566','CF' SPRunCalcAccount Version 7.105 1 Rows Calculated 1 Rows Updated Time to run stored procedure:13.5 sec. call 1 completed and data posted in 14.0 sec. Run completed in 14.1 sec.
However, when I chose 2007.INP, I could not get my expected result at all. From the following log file, I also saw that the stored procedure did not copy any data.
------------------------- Building sub-query 1 ------------------------- Query Type:0 Max members: Executing SPRUNCALCACCOUNT 'WJEFD', 'ACTUAL','LC', 'SPSCOPE_698645','SPLOG_816139','CF' SPRunCalcAccount Version 7.105 Time to run stored procedure:10.0 sec. call 1 completed and data posted in 10.3 sec. Run completed in 10.5 sec.
It's even weird when I chose 2006.INP from the Time dimension. There was a warning in the log file.
------------------------- Building sub-query 1 ------------------------- Query Type:0 Max members: Executing SPRUNCALCACCOUNT 'WJEFD', 'ACTUAL','LC', 'SPSCOPE_726660','SPLOG_585528','CF' SPRunCalcAccount Version 7.105 -Warning - Not existing time member, delete from #T_TIME where Calc_year = N'2006' and calc_period = N'Inp' And [time] = N'2006.INP' Time to run stored procedure:11.6 sec. call 1 completed and data posted in 12.0 sec. Run completed in 12.1 sec.
From the above test results, it seems that SPRUNCALCACCOUNT does not work with XXXX.INP time members. It this true? Or are there some properties in the Time dimension need to be modified in order to make it work?
BTW, I'm using BPC 7 MS version.
Thank you!
Sunny