calcaccount procedure - account transformation business rules

[Former Member]

Hi I have a question concerning the calcaccount procedure.

I already made some Cashflow accounts

I already filled in some lines in the account transformation business rules

But now I was wondering how to run these business rules:

I have made the following calcaccount logic, but when I run it I get nothing for the moment

*XDIM_MEMBERSET INTCO=GLTOT

*XDIM_MEMBERSET GROUPS=C_WDP

*XDIM_MEMBERSET ENTITY=E_TOTAL

*IGNORE_STATUS

*RUN_STORED_PROCEDURE = SPRUNCALCACCOUNT([FINANCE],[%CATEGORY_SET%],[C_WDP],[%SCOPETABLE%],[%LOGTABLE%],[CF])

*COMMIT

I don't have a clue if this logic is even correct or not

Please help me

[Former Member · Accepted solution]

Hi Benjamin,

Below a working example:

*run_stored_procedure=spruncalcaccount('finance','%category_set%','LC','%scopetable%','%logtable%')
*commit

Hope this helps,

Alwin

[Former Member · Accepted solution]

Hi Alwin,

I tried this but it doesnt work

*XDIM_MEMBERSET INTCO=GLTOT

*XDIM_MEMBERSET GROUPS=C_WDP

*XDIM_MEMBERSET ENTITY=E_TOTAL

*IGNORE_STATUS

*RUN_STORED_PROCEDURE = SPRUNCALCACCOUNT([FINANCE],[%CATEGORY_SET%],[C_WDP],[%SCOPETABLE%],[%LOGTABLE%])

*COMMIT

I have the following in the formula log:

Start time --->3:36:33 PM - Date:9/24/2008 (build code:254)

****************************************************************************************************

User:WDP\Administrator

Appset:WDP_ONTWIKKELING

App:FINANCE

Logic mode:1

Logic by:

Scope by:

Data File:

Debug File:D:\BPC\Data\Webfolders\WDP_ONTWIKKELING\FINANCE\PrivatePublications\Administrator\TempFiles
DebugLogic_7_.Log

Logic File:D:\BPC\Data\WebFolders\WDP_ONTWIKKELING\FINANCE
..\AdminApp\FINANCE\Calcaccount.lgx

Selection:D:\BPC\Data\WebFolders\WDP_ONTWIKKELING\FINANCE\PrivatePublications\Administrator\TempFiles\FROM_7_.TMP

Run mode:1

Query size:0

Delim:,

Query type:0

Simulation:0

Calc diff.:0

Formula script:

Max Members:

Test mode:0

Is Modelling:1

Number of logic calls:1

-

---

Call no. 1, logic:D:\BPC\Data\WebFolders\WDP_ONTWIKKELING\FINANCE
..\AdminApp\FINANCE\Calcaccount.lgx

-

---

signeddata is YTD

-

---

Building sub-query 1

-

---

Query Type:0

Max members:

Executing SPRUNCALCACCOUNT [FINANCE],[ACTUAL],[C_WDP],[SPSCOPE_312035],[SPLOG_394894]

SPRunCalcAccount Version 2.06

2 Rows Calculated

2 Rows Updated

Time to run stored procedure:26.5 sec.

call 1 completed and data posted in 26.7 sec.

Run completed in 27.3 sec.

****************************************************************************************************

End time --->3:36:59 PM - Date:9/24/2008

As you can see he doenst post records to the cashflowaccounts..

Do you know what is wrong?

[Former Member]

Hi Benjamin,

From your logfile I can see that the sp has calculated two records.

Executing SPRUNCALCACCOUNT FINANCE,ACTUAL,C_WDP,SPSCOPE_312035,SPLOG_394894

SPRunCalcAccount Version 2.06 
2 Rows Calculated 
2 Rows Updated 

So it seems to work. You now have to research the calculated records by looking at the account transformation rules and the created records in SQL. I mostly do this by optimizing the application (lite) so that the wb table has no records. Then I enter amounts in the source accounts/subtables, run the logic and then look to the wb table to see what records are created.

By the way, the lines

*XDIM_MEMBERSET INTCO=GLTOT 
*XDIM_MEMBERSET GROUPS=C_WDP 
*XDIM_MEMBERSET ENTITY=E_TOTAL 


*IGNORE_STATUS 

are totally irrelevant and can be removed, the sp calls don't look to these lines.

Alwin

[Former Member]

Hi Alwin,

I already deleted those lines and now the package seems to work

Thanks for your help