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
My family has  4 devices sharing the same apple ID.  We use icloud,   Is there any concern that my family could see actual messages i send or receive in imessage or whatsapp?i should add, that i mean messages i send other people from my device. Of co [More]
Hello All: We are receiving the following error when we navigate to details->classification for all of our content resources in KM. An error occurred during classificationError while classifying resource [our resource here] for taxonomy Explore.com.s [More]
Need help to fix. No support where i am presentlyReboot to the recovery partition and repair the OS X partition from there.Read other 2 answers [More]
Obviously LR seems to use some of the lens correction information it gets from Micro Four Thirds cameras. This shows when compared to results from RAW converters that don't. I have noticed this for my Olympus OM-D and the 12-50 mm zoom. Is that the r [More]
I don't know what's going on with my phone!  Two days ago it slowed right down and there's a black clock popping up every time I press a key with a minute hand moving......I can't figure out what's going on....I tried deleting old texts and messages [More]
hi gurus, I have a cost center report for one user the reports gives output in local currency and for the another person it gives in group currency . is there any thing to do with user setting. as the report is very old and SAP developed one ...Premr [More]
I had briefly looked into Crystal Reports within my Visual Studio 2008 solution. However since the project needed to be done quickly I removed the report and the references to Crystal.  Now I have deployed my application using Publish onto my QA serv [More]
Dear all, I want to understand how it is possible the procedure of automatic posting in different depreciation areas. Exemple: I post a specific movement via ABAON, and automatically the system creates another document (with sequencial number, becaus [More]
Hi all, I am going to dual-boot Windows 7 and Lubuntu on my Satellite A505-S6009. I am sure some people severely disagree with dual-booting, but this is what I want to do with my machine (my mind is made up). I have installed and used Linux before. I [More]
Hello in the past I used MII 12.2 SendMail action I used it with: - AttachmentContent (a generic string, like "My attachment text") - AttachmetFile (a generica file name, like "A.TXT") and the result was an e-mail with an attachment ca [More]