Sitemap

Amicuk Programming Answers

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

-0001-11-30   Views:1

Advertisement

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_S

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

The replay answer
Advertisement
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

Go to See the other 5 answers

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

Category:DefaultRelease time:-0001-11-30Views:130

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_S[More]

Default Script Logic Execution

Category:DefaultRelease time:-0001-11-30Views:130

hi friends I created script logic & placed in default logic. I created Input Schedule and saved, but default script logic is not executed BPC 7.0NW version. What might be the reason? JoeSave the input schedule means you just saved an excel file into[More]

SQL functions in Script Logic

Category:DefaultRelease time:2015-10-11Views:130

I want to build a script logic but the dimensions that I am testing do not have the fields I want in the format I want. In my case I would like to test the "Start" property in the Employee dimension. The property represents the employee start da[More]

How to send file as a parameter to php script

Category:DefaultRelease time:2015-10-11Views:130

Hi, Can any body help me to send the file as a parameter to php script. I am using the HttpURLConnection method. ThankString msg= "name=" + strName + "&surname=" + strSurname;                byte[] msgAsBytes = msg.getBytes(); I am[More]

How to use the current view in script logic - %DIMENSIONNAME_SET% not work

Category:DefaultRelease time:2015-10-11Views:130

Hello, I have the requirement to use the values from the current view in the script logic. User would like to use the members which were selected from the current view in the calculation. We are using SAP BPC 7.0 SP06 I have prepared the following sc[More]

Distribution in script logic

Category:DefaultRelease time:2015-10-11Views:130

Hello, all. I'm new in BPC. Please give advice, how can we realize following logic. We have a application Sales with following dimensions. Account, Category, DataSrc, Entity, Department, Prodline, RptCurrency, Time User send data to the DB in view: A[More]

Display entire log in script logic?

Category:DefaultRelease time:2015-10-11Views:130

When users run a script logic, eg to push data from one model to another, they get errors like: Invalid Members [ACCOUNT_DTL]=61500270 Invalid Members [ACCOUNT_DTL]=51301500 However these errors are at the very end of the log and the user cannot see[More]

Use Counter in Script Logic

Category:DefaultRelease time:2015-10-11Views:130

Hi guys, I have code in default logic which starts its run if one of several accounts data has been sent. However, when I send data for 2 accounts from *WHEN/IS condition, this script logic runs 2 times and result doubles, while I need it to work onl[More]

Use of Variable in Script Logic

Category:DefaultRelease time:2015-10-11Views:130

Dear All, We are working on a BPC Script Logic involving depreciation calculation, which calls an implementation of the BAdI BADI_UJ_CUSTOM_LOGIC. We are passing some parameters from the script logic to the BAdI. There are two parameters to be passed[More]

Multiple Script Logics in Default Logic.. order of execution... Commit

Category:DefaultRelease time:-0001-11-30Views:130

Hi, I have a situation where I need to perform two activities... i) Perform a multiplication operation on the data input by the user - Script Logic A ii) Send the data at a summary level to another application. - Script Logic B Both Script logics are[More]

Script logic from BPC 5 in BPC 7.5

Category:DefaultRelease time:-0001-11-30Views:130

Hi, I am trying to use some script logic from an appset in BPC 5 in BPC 7.5. When I validate the logic in 5 it works fine but in 7.5 I get validation errors. They relate to properties of dimension elements that are not currently used (neither in 5 no[More]

Hot
I want to permanently remove old deleted apps from the "purchased" list in the update section of the app store icon on my iPhone. These are apps that I tried and didn't like or didn't work or were useless or whatever. There does not seem to be a [More]
I'm tryin too use another iPhone too log into Gamecenter but I can't figure out how too log out the id that's in it nowChange here: Settings>Game Center.Read other 2 answers [More]
I have 15 QTVR movies in an external cast. Each is loaded from a Flash button menu to a QT sprite(2) using 'showvideo', and replaces the movie currently loaded to the sprite. Is there a way to unload the previous QT from memory before the new one loa [More]
Dear colleagues, I would like to pay by payment on behalf in TRM transactions, which the payment order payed by transaction F111. In TRM  I do not work with vendors and clients, I work with company code and BP and I do not know how to do it. I alread [More]
Need to obtain a replacement CD or Photoshop Elements to instal on my new computer, I lost the CDMohogfan wrote: Need to obtain a replacement CD or Photoshop Elements to instal on my new computer, I lost the CD You can do what Barb has said but you c [More]
Hi everybody, Our development server had a crash some weeks ago, forcing us to reinstall and resetup the Coldfusion server. Since then, where has been some problems. One of those problems occures in displaying the correct character set. German Umlaut [More]
Hi Experts, I had a requirement for which i have to end up building a snowflakt model in Physical layer i.e. One Dimension table with Three snowflake tables(Materialized views). The key point is the Dimension table is used in most of the OOTB reports [More]
I ve created a desktop database app with master and detail tables. I created new/edit/delete functions. I also added a new JDialog that has 2 tables. One of these tables has a foreign key that is primary key of the other table and another foreign key [More]
so my dad and I share an itunes account so all of the music that he buys shows up on my phone with a little cloud by it to download on my phone. I can click on the song and it will play so im not sure why the cloud button is there but is there any po [More]
Hi. A while back I had to reformat my Mac Mini. I've re-installed LE8 without too much incident, but I no longer have access to a set of sampler instruments I used to have and used a lot. I think they were part of the EXS24 offerings and were called [More]