Send parameter from one script logic to another. SAP BPC 7.5 NW.

[Former Member]

Hello!

Before i start, want to apologize for my English.

We work on SAP BPC 7.5 for NetWeaver.

In general, we want to send parameter from one Script logic file to another script logic file.

I will explain why :

1. We have parametr like %C_CATEGORY_SET% (and another four parameter, like groups, currency and etc.) that work on one script(next, i will named it A_Script).

We will send this parametr from BPC EXCEL (we will create button, then use command MNU_eData_SelectPackage(we also set parameters) and run package that we need, also before we set script for this package by the SAP Guide. We send some data, and this A_Script work good. Everything that we want from this script work correctly. )

2. Next we create another script(B_Script) , and we want use %C_CATEGORY_SET%, but we don't know how use this parametr, if we will just write this parametr on Script Logic, apears error ("C_CATEGORYDATAVALUE" is not assigned to the Data Administrator). We try to solve this problem by using System_Constants.lgf, but we get error.

Code:

*DIM C_CATEGORY          WHAT=%C_CATEGORY_SET%;             WHERE=<<<;                   USING=<<<;    TOTAL=<<<


*DIM C_ENTITY                 WHAT=%ENTITYSET%;                         WHERE=<<<;                  USING=<<<;      TOTAL=<<<


*DIM GROUPS                   WHAT=%GROUPS_SET%;                    WHERE=<<<;                  USING=<<<;     TOTAL=<<<
*DIM RPTCURRENCY         WHAT=%RPTCURRENCY_SET%;         WHERE=<<<;                  USING=<<<;      TOTAL=<<<
*DIM TIME                          WHAT=%TIME_SET%;                          WHERE=<<<;                  USING=<<<;     TOTAL=<<<

If we will change %C_CATEGORY_SET% for ACTUAL, and also change another parameters, script will work, package will run correctly. But we need using parameters, because we didn't exactly what will choose our client.

Our question have BPC Script Logic some kind of Globar Parameter(Variable), that we will set in A_Script, and then use them on B_Script?

How can we define parameter from another script logic, maybe we should send it?

Should we use System_Constants for solving this problem, if yes, how?

Any help will be appreciated

Best Regards,

Erlan Kadraliev

Edited by: Erlan Kadraliev on Feb 8, 2011 4:50 PM

Edited by: Erlan Kadraliev on Feb 8, 2011 4:58 PM

Edited by: Erlan Kadraliev on Feb 8, 2011 4:59 PM

[former_member200327]

Hi Erlan,

I'd think that %ENTITYSET% was just a typo in your posting because you said that with ACTUALS it works fine.

Main question is, as Ethan said, how those 2 scripts are connected? I can see multiple scenarios: 2 Packages in a Package Link, script B is SUB in script A, custom Process Chain that calls 2 scripts, etc. depending on the scenario solution will be different.

You can also try using RUNLOGIC BAdI described in [HOW TO IMPLEMENT THE RUNLOGIC KEYWORD IN SAP BUSINESS OBJECTS PLANNING AND CONSOLIDATION, VERSION FOR NETWEAVER|http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/b0ad38cf-9e0e-2e10-9d9a-fbf57e69cd40] and use keyword DIMENSION if you want to call script B directly from script A.

Regards,

Gersh

[esjewett]

Hi Erlan,

In your script code that you provide, you have variable %ENTITYSET%. If your dimension is named "ENTITY", then this should be %ENTITY_SET%. Is this the problem?

Are the variables you are using in Script B the same as the variables in Script A? Are you running the scripts using the same data manager package?

Cheers,

Ethan

[Former Member]

Hi Ethan Jewett

1. About %ENTITYSET% it is normal. Before this line i write :

*SELECT(%ENTITYSET%, "ENTITY", GROUPS, "[ID]=%GROUPS_SET%")

So it is not this problem. %ENTITYSET% just parameter, that i used.

2. Are you running the scripts using the same data manager package? I am running two different package for 2 different Script.

For example aPackage for aScript, and bPackage for bScript.

My questions was how can i send parametr from one script to another, for example i can run another script by using BADi command Runlogic, but how can send parameter that i need to used on another script. I have for example parameter %GROUPS_SET% (CG001) on aScript, but i can't get this parameter on another script, if i write %GROUPS_SET% i will get error ("GROUPSDATAVALUE" is not assigned to the Data Administrator)

OR

Maybe if you will answer for next question, i will be able solve problem , How can i send parameter CG001 (this is %GROUPS_SET%, for example it stay in EXCEL in cell A5) from excel to script logic by running package. Maybe i can get cell value on Dynamic Script Data Management?

My Dynamic Script on bPackage

PROMPT(RADIOBUTTON,%CHECKLCK%,"u0412u044Bu0431u043Eu0440 u0431u0430u0437u043Eu0432u043Eu0433u043E u043Fu043Eu043Au0430u0437u0430u0442u0435u043Bu044F.",1,{"u0412u0441u0435u0433u043E u0410u043Au0442u0438u0432u044B","u0421u043Eu0431u0441u0442u0432u0435u043Du043Du044Bu0439 u043Au0430u043Fu0438u0442u0430u043B","u0412u044Bu0440u0443u0447u043Au0430 u043Eu0442 u0440u0435u0430u043Bu0438u0437u0430u0446u0438u0438","u0414u043Eu0445u043Eu0434 u0434u043E u043Du0430u043Bu043Eu0433u043Eu0431u043Bu0430u0436u0435u043Du0438u044F u043Eu0442 u043Fu0440u043Eu0434u043Eu043Bu0436u0430u044Eu0449u0435u0439 u0434u0435u044Fu0442u0435u043Bu044Cu043Du043Eu0441u0442u0438"},{"BPAST_ALL","BPEQ","BPPROCE","BPOPIN_GO"})

INFO

(%EQU%,=) 
INFO

(%TAB%,;) 
TASK

(/CPMB/DEFAULT_FORMULAS_LOGIC,SUSER,%USER%) 
TASK

(/CPMB/DEFAULT_FORMULAS_LOGIC,SAPPSET,%APPSET%) 
TASK

(/CPMB/DEFAULT_FORMULAS_LOGIC,SAPP,%APP%) 
TASK

(/CPMB/DEFAULT_FORMULAS_LOGIC,REPLACEPARAM,CHECKLCK%EQU%%CHECKLCK%%TAB%) 
TASK

(/CPMB/DEFAULT_FORMULAS_LOGIC,LOGICFILENAME,MYTEST_145.LGF)

Best Regards,

Kadraliev Erlan

[former_member200327]

Hi Erlan,

I had a brief discussion with Ethan regarding your requirements and we are still not clear what you are trying to achieve.

First of all, your new option is more difficult to implement, if possible, that the original one unless cell A5 is mapped to your Current View. If it's a part of your CV, that DEFAULT.LGF would use it. Otherwise, there was a lot of discussion how to pass Front End value to the Back End, but I haven't seen anybody succeed in that.

Now back to your original question. It looks now that your 2 Packages are independent. In such case they can communicate via Transaction data only, i.e. first Package writes something to the Application and second Package retrieves it from there. So, it's cumbersome as well. Can you please confirm that there is no connection between those 2 Packages or explain what is the connection?

Thanks,

Gersh