Program CALC_ACCOUNT parameters

[Former Member]

Hi,

In clients model, the used dimension type C is not the standard one (CATEGORY), but a copy of it translated to portuguese (Categoria).

When I call standard program CALC_ACCOUNT, I try to set parameters like:

*RUN_PROGRAM CALC_ACCOUNT

Categoria=Realizado

TID_RA=%TEMPO_SET%

*ENDRUN_PROGRAM

But, the program runs for all category members (Members of dimension Categoria, in this situation), like no filter is applied.

My question is... is there a specific way of setting filter in CALC_ACCOUNT for members of a C-type dimension that isn't the standard dimension CATEGORY? Any extra configuration?

Best regards

[former_member186338 · Accepted solution]

There is no "standard" dimension CATEGORY, there is a standard dimension type - C in this case.

Look on help: Account-based Calculations as Script Logic - SAP Business Planning and Consolidation, version for SA...

*RUN_PROGRAM CALC_ACCOUNT

CATEGORY = %YourCategoryDimName_SET% //CATEGORY - standard name to be used!

CURRENCY = %YourCurrencyDimName_SET% //CURRENCY - standard name to be used!

TID_RA = %YourTimeDimName_SET% //TID_RA - standard name to be used!

CALC=A //ID of rule!

OTHER = [YourEntityDimName=%YourEntityDimName_SET%]// or OTHER=[YourEntityDimName=C1000] or [YourEntityDimName=%YourEntityDimName_SET%;YourIntcoDimName=%YourIntcoDimName_SET%...]

*ENDRUN_PROGRAM

Where:

YourXXXXXDimName - real name of your dimension!

CATEGORY,CURRENCY,TID_RA,CALC,OTHER - are just fixed parameter names!

[Former Member · Accepted solution]

Hi Vadim,

Hum... I get it! It makes a lot of sense. To me, what does not make any sense is it:

I tried to set parameter CATEGORY like:

CATEGORY = "Realizado" //Because I want to filter just one specific member

But, the system gives an error message that says it is not a base member. So, I created the member "Realizado" in dimension CATEGORY (just to give it try). Now the program works correctly, even though dimension CATEGORY is not even used in my model (remember that my C-type dimension is not CATEGORY, but Categoria). It seems like BPC validates members agaisnt dimension CATEGORY, but filters input records using C-type dimension of the related model.

Have you ever faced the same situation?

[former_member186338 · Accepted solution]

Sorry, once again:

CATEGORY in RUN_PROGRAM CALC_ACCOUNT

is not a name of C-type dimension, it's a name of parameter!

And you have to provide the member of C-type dimension to this parameters!

Same for other!

CATEGORY = Realizado //Correct syntax!

P.S. For example, if you want to get the member from user selection, then:

CATEGORY =%Categoria_SET%

[former_member186338 · Accepted solution]

Same idea for:

TID_RA=%TEMPO_SET%

TID_RA - parameter name for T-type dimension

[Former Member · Accepted solution]

Alright! Thank you.

[former_member186338 · Accepted solution]

How to check the syntax of *RUN_PROGRAM:

Use transaction SE24 - Class CL_UJK_RUN_PROGRAMS

Then look on the ABAP code of the required method.

Like: Method -  CALC_ACCOUNT

[Former Member · Accepted solution]

OK Vadim. Thanks for all the valuble information. Now I can use CALC_ACCOUNT properly...

[former_member186338 · Accepted solution]

For example I have found that in CALC_ACCOUNT you can use statement TIME instead of TID_RA with the same effect Never documented...