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
where can i found the download software of oracle identity manager 9.1.0.1 Remote Manager . can any one help me. Edited by: user10545341 on Jul 29, 2011 8:19 AMAnd follow the steps to complete your task: Agents in Active Directory 9.1.0.2 hope this h [More]
My HP Photosmart C4385 printer only supports up to Windows 2000.  How can I connect a new computer to the network for my home.  It is wireless as wellHi there hayes54, Looks like the c4385 drivers go all the way up to windows 7. Take a look at this l [More]
Hi, experts. I tried to read a text file into oracle. Here is what i did: 1. Create a text file in the directory: C:\temp\New Text Document.txt 2. Run the following SQL in PL/SQL: CREATE or replace DIRECTORY sampledata AS 'C:\temp\'; grant read, writ [More]
Hi, I recently bought a iphone 4 and I notice that in default photo application there is not like the that should be. With albums, events, faces and places tab...and also I can't the camera roll photos because is back of Album name. Suppose that shou [More]
I have downloaded DNG Profile Editor 1_0_4 and prepared a profile which I can not see in my Camera Raw 6.0 (I have photoshop CS5). Could you please give me an advice?Uninstall Trusteer software http://www.trusteer.com/support/uninstalling-rapport-mac [More]
How to get "Themes" (Designs) for arranging my photos to email them in my iPhoto? Thank youHello bendercm, '''try Firefox Safe Mode''' to see if the problem goes away. Safe Mode is a troubleshooting mode, which disables most add-ons. ''(If you'r [More]
How do I getr past the error message Sign In Failed on my 2nd computer? I have signed out, uninstalled, and reinstalled to no avail.So I thought: let's try the link Carolyn Samit suggested. So I got to Apple - Support - FaceTime to find information I [More]
Hi experts, I'm building a custom project on Jdev where i need to use the com.sun.rowset.internal.row class to utilise the current createRow and insertRow methods. When i import this package into my source and compile it giver the following errors: E [More]
I searched (hopefully using the right keywords) but didn't find anything regarding this...how do you use numeric resources in your resource bundle? I'm just trying to reuse the message bundle from a different app...the bundle uses all numbers. 2260=M [More]
If I gave yahoo permission to be my homepage I didn't mean to. Now it is locked in as my home page. I would like to get rid of it. I was not sure which place to ask this question but this was as good as any. thank you, LindaYes, the mozilla.cfg file [More]