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 don't have a credit card but have more than enough to purchase it with itunes credit but when i try to sign up it asks me for a credit card or to redeem a gift card. How do I just use the credit I have?No. You may only use what they provide.Read ot [More]
Hello, I am using FrameMaker 11 in the Adobe Technical Communication Suite 4 and I need to find a script that will generate a list of paragraph and character styles from the book level. I am working with unstructured FrameMaker books, but will soon b [More]
How can I sync my calendars on the MacBook Pro, iCloud, iPad and iPhone? Since upgrading to the newest OS on each device, none of the calendars sync. Any suggestions?Hi silverk, Welcome to the Apple Support Communities! I understand the need for all [More]
I'm new to both Linux and Oracle. I've been working on an installion of Oracle 10g on a Red Hat Linux 5 Server for about 2 weeks. I've been doing a lot of reading about installing Oracle on a Linux environment. I finally got to the installation porti [More]
I has successfully setup new Dev ENV of SarePoint server 2013 in VMware with 2 servers running om OS: win server 2008 R2 Ent SP1, AD + Central Admin Application Server. After that the configuration of SharePoint App and WorkFlow Manager completed as [More]
Hello! i have accidently removed outlook from my dock. I can retrieve outlook?if you open the outlook application, it will come back onto the dock then hold the control key down while clicking on it's icon and you will get a small popup under the opt [More]
Hi, I am using JDeveloper 11.1.2.0.0 & Tested with HR Schema Issue Scenario: I am having a Employee View Object there is field called Departments and it is LOV which is coming from the Department table. I drag and drop a table with all editable compo [More]
Hi I am trying to export my passed/failed authentication log to MS-EXCEL . Since my log in acs is huge MS-EXCEL has a restriction on the number of rows and columns. How do i delete the old logs and have the logs between specified dates. Or is there a [More]
I lost the left column with the reduced text images and movement of images.  How do I get it back?I'm not sure what you are asking here. What left column and what do you mean by "reduced text images and movement of images". Also, you may want to [More]
Hi, I purchase a Compaq Presarior CQ41-209TX approx 2years ago, ago 1 year ago the DVD doesn't read or write DVD any more ( it does read CD, weird isn't it ). I try to update driver and every thing,however, not works so far. Is it dead ? Because i do [More]