cancel
Showing results for 
Search instead for 
Did you mean: 

Pass current view selections to ScriptLogic

Former Member
0 Kudos

Hi Expert,

I'd like to run a script using some of the parameters that the user selects in the current view parameters. So far I know that I can use the option PROMPT(SELECTINPUT to allow the user to enter parameters in the package. However, what can we do to actually read some parameters from the current view?

So if a user is working for Entity "US" I just want to pass this value into the package without asking the user to manually enter it before running the script.

Thanks,

Alberto S.

Edited by: Alberto Sabate on May 27, 2009 5:43 PM

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Alberto ,

use...%DIMNAME%...

here is what the help has to say..

The keyword %DIMNAME% can be adjusted to return only the prefix or the suffix of a member name.

For example, if the passed member set for the TIME dimension contains the member: 2001.JAN

The keywords: will return:

%TIME% 2001.JAN

%TIME_PREFIX% 2001

%TIME_SUFFIX% JAN

Here is an example that uses the prefix keyword to perform an allocation:

*RUNLOGIC

*DIMENSION TIME=descendants([time].[%TIME_PREFIX%.total],99,leaves)

*LOGIC=AllocationLogic

*ENDRUNLOGIC.

Chek the how to use BPC scripting logic for more details...

hope this helps.......

Former Member
0 Kudos

Vishal,

Thank you very much for your answer.

I just wrote a quick test based on your explanation which I'm not sure that is really working, although is generating some data.

Would you say that we could use %DIMNAME% as in the logic code below?

*XDIM_MEMBERSET DATASRC= %DATASRC%

*WHEN *

*IS *

*REC(factor=1/2)

*ENDWHEN

Thank you,

Alberto

Former Member
0 Kudos

Alberto,

To be honest...i'm a lil week on the script logic side boss

i looked up the available keywords in SQL logic for your criterion and posted it .

looking at your code

You are for sure missing *COMMIT to write the values generated to the db.

hope this helps...

Former Member
0 Kudos

Vishal,

Thanks for your reply. The *COMMIT statement is not necessary. The *REC statement is enough to write to the db.

Regards,

Alberto Sabate

Former Member
0 Kudos

well!!!..thank you alberto..for that tip...

i'll test that up..

Edited by: Vishal Mahawadhi on May 29, 2009 5:10 PM

Former Member
0 Kudos

Alberto

Did that work for you? We are working on a solution to the same issue.

Passing the currentview member into the script logic.

Please let us know if you have resolved it. Thanks, Max

Edited by: Maximilian Weisheit on May 30, 2009 12:24 AM

Former Member
0 Kudos

From: alberto.sabate

Sent: Wednesday, June 03, 2009 3:46 AM

To: Maximilian Weisheit

Subject: Re: SAP Forum Thread (CV to Script Logic)

Hi Maximilian,

... I'm working in my own BPC system trying to evaluate how good BPC is compare to the "former" SAP planning tools.

Anyway, regarding your question, there is just no document whatsoever that actually shows this done. I was surprise that my question was not answer as I find this requirement very simple. I'm guessing that the dstx file requires a command like "Execute formulas,REPLACEPARAM...." to pass the variables from the package to the script.

However, I'm starting to think that maybe the system is not able to read the user selected variable values while running a script, because they are locally stored. You probably neeed to pass them to the package and then pass them to the script.

Anyway, I'm still working on it and testing a few things. If I get something useful I'll let you know. If you do, please also let me know.

Regards,

Alberto Sabate

(Thanks for the info! --- as replied, we also working on it. and will keep us updated how the matter will beresolved. - Thanks again, Max)

Edited by: Maximilian Weisheit on Jun 3, 2009 4:30 PM

Answers (0)