cancel
Showing results for 
Search instead for 
Did you mean: 

Passing Parameters with OpenDocument in SAP Design Studio

Former Member
0 Kudos

Hello everybody,

I have built 2 Design Studio dashboards. One Design Studio dashboard should act as an overview, the other Design Studio dashboard should act as a more detailed view. The detailed view is based on a BEx Query, which contains several mandatory variables. Now I want to jump from the overview to the detailed view an pass the chosen parameters from the overview dashboard to the detailed dashboard by setting the mandatory query variable with an OpenDocument link. I know that this works fine with other BusinessObjects tools like Web Intelligence, but I was not able to set the mandatory BEx Query variables using OpenDocument in Desing Studio. Does anyone know if this works yet, or maybe in further releases?

Thank you in advanced.

Best regards

Stephan Bucher

Accepted Solutions (0)

Answers (2)

Answers (2)

0 Kudos

Hi ,

   I am trying to open a child dashboard from the parent one, i have given URL link of the child alone on click of button event in the parent, i am getting a page which is asking me for user information (password for bi launchpad log on ), is there a way to bypass it or pass password through link

Thanks

Naveen

Former Member
0 Kudos

Hello,

yes, this is possible today, take a look at following tutorial:

Best regards,

Victor

Former Member
0 Kudos

Hello Victor,

thanks for your reply. I have already seen this tutorial. However, in this tutorial the parameters are passed directly to the Design Studio to set global script variables. In my case I want to set BEx mandatory prompt variables so that no prompt screen appears but the BEx mandatory variables are set by the OpenDocument link. And, unfortunately, I does not work for me yet. Did you ever tried to set BEx mandatory prompt variables in Design Studio using OpenDocument?

Best regards

Stephan Bucher

IngoH
Advisor
Advisor
0 Kudos

Hello Stephan,

to be able to pass the values to the variable your Design Studio app needs to receive it first.

so the Tutorial shows how to pass parameters between the two apps and you then can use the global variables to set the values in the BEx variables.

regards

Ingo Hilgefort, SAP

Former Member
0 Kudos

Hello Stephan,

it is easier to help you if you add some comments mentioning where exactly you are stucked at, and what have you tried so far. First follow the tutorial to get it working an optional variabl, then we will guide you into getting it working with the mandatory one.

If I remember correctly you might need to add a default value for the mandatory variable, this might be different nowdays though.

Best regards,

Victor

Former Member
0 Kudos

Hello Ingo,

thanks for your valuable reply. The Tutorial works really fine with optional BEx variables. My problem is that I try to set a mandatory BEx variables. When using a mandatory BEx variable the prompt screen appears as you have to define a value for this kind of variable, while using optional BEx variables the prompt screen does not appear as there is no need to define a value for an optional BEx variable.

Did you ever set a mandatory BEx variable with an OpenDocument link in Design Studio 1.1 or do you know if it is possible to set a mandatory BEx variable with an OpenDocument link in Design Studio 1.1??

Best regards

Stephan Bucher

rama_shankar3
Active Contributor
0 Kudos

Stephan,

Please try with optional variable and see whether you can create a separate version of the BEx query that is dashboard specific. If not ok with client, then make the optional variable working first and then try mandatory variable with a default value.

Ingo, is there any limitation on using mandatory variables for passing parameters between BO design studio apps using Bex queries? Please let us know. Thanks.

Hope this helps!

Rama

Former Member
0 Kudos

Hi Stephan,

I did set a mandatory BEx variable with an OpenDocument link in Design Studio 1.1, so yes it is possible to set the value for a mandatory BEx variable in the background without user interaction without the prompt screen appearing first.

  • Make sure that in the app with the mandatory bex variable you have set "Force Prompts on Startup" to "false".
  • Make sure that you have created a "global url parameter variable" in the app with your datasource containing a mandatory bex variable - this is the only way how to be able to receive and work with the value passed through the opendocument link in DS 1.1. Recommendation here: you could also set a default value for the global variable here in case that no value is passed over through opendocument, if you want to avoid the prompt screen to open in that case too.
  • Now comes a very important mandatory part: assign the mandatory bex variable the value that comes from opencodument link and is stored in your global variable in the "On Startup" Event of your Application: APPLICATION.setVariableValueExt("BEX_VAR_TECHNICAL_NAME", Xyour_global_variable);

If you did all the steps and your global variable contains a valid value for your bex variable, the prompt screen should not appear anymore.

Else I would ask you to append screenshots of:

  • definition of your global variables
  • "On Startup" Window containing your script
  • the prompt Window when it appears

Also please send the whole opendocument url that appears in the browser where your prompt screen appears.

Thanks.

David

Former Member
0 Kudos

Hi David,

I really appreciate your valuable answer.  However, it still does not work for me and I do not see what I am doing wrong. So I send you screenshots form the global variable definition from both the source and the target report and also from the OpenDocument link:

Variable Definition of Source Report:

Source Scripting for OpenDocument generation:

APPLICATION.openNewWindow("http://...../BOE/OpenDocument/opendoc/openDocument.jsp?sIDType=CUID&iDocID=AXukBBrNUetOgAm5Ap63adM&X..."+ X_DisChan);

The OpenDocument link does work, this means that I get to the wished destination report, the following URL appears in the browser:

http://.../BOE/OpenDocument/1309161651/OpenDocument/opendoc/openDocument.faces?logonSuccessful=true

&shareId=0&bttoken=MDAwRDJYS0FrRWNTZU0zaFRjQGNNVG5KRlBSb1ttNTAEQ&iDocID=AXukBBrNUetOgAm5Ap63adM&shareId=0

&X_DisChan=01

&sIDType=CUID

&isApplication=true

&appKind=OpenDocument

&vint_success=false

Variable Definition of Target Report:

Target Scripting for Mandatory Variable Setting:

APPLICATION.setVariableValueExt("DISCHAN_MANDATORY", X_DisChan);

Force Prompt set on "False" in Target Report:

As I mentioned before, I do not see what I am doing wrong. In my application the mandatory is not set and so the prompt screen still appears. Maybe you can give me some advise. I you need any further information please let me know.

Best regards

Stephan Bucher

Former Member
0 Kudos

Hi Stephan,

first thing to try - first candidate for possible "error":

&X_DisChan=01 - the value "01" looks to me like an internal key not external (but I might be wrong)

Did you try:

APPLICATION.setVariableValue("DISCHAN_MANDATORY", X_DisChan);

instead of:

APPLICATION.setVariableValueExt("DISCHAN_MANDATORY", X_DisChan);

in your "Target Report" "On Startup" Event?

Or instead of "01" as Default Value set the value "1" if it's a valid external key value and in the "Source Report" make sure that the variable "X_DisChan" contains the external key instead of the internal key.

Regards

David

Former Member
0 Kudos

Hi David,

the key value "01" is a valid value for the variable.

I tried both options in the "Target Report" "On Startup" for the variable setting (setVariableValue and setVariableValueExt) without results.

Did you set a default value for the mandatory variable in the BEx Query Designer or does the setting work without setting a default value in the BEx Query Designer?

Regards

Stephan

Former Member
0 Kudos

Hi Stephan,

sorry, I won't have much time in the coming days to do some further testing on my side.

The mandatory variable I was testing with has the following properties:

Hierarchy Node, Manual Input, Single Value, Mandatory, Variable is ready for Input, A hierarchy is activated in the BEx Query on the Characteristic and the Default Value is set to the first top level node of the hierarchy.

You could test what happens when you also assign a default value directly in the BEx Variable whether it makes a difference.

I haven't tested without default value in the BEx Variable.

Is the prompt screen launched in the target report only when opening it through opendoc url or does the prompt screen also open when the target report (bi app) is opened directly without opendoc url?

Here is how my opendoc url looks like:

APPLICATION.openNewWindow("http://server:80/BOE/OpenDocument/opendoc/openDocument.jsp?sIDType=CUID&iDocID=AS05ainRME1EkwhpHfOjq..."+"&Xvg_bd="+Xvg_bd);

Regards

David

former_member192236
Participant
0 Kudos

Hi All,

I am facing a similar issue here. My requirement is that users has to execute the Design Studio dashboard from the web browser by passing the parameters. Hence I am trying to achieve it using OpenDocument URL by passing the bex variable parameters in the URL. When they execute the dashboard they should not get the prompt screen which is what I am unable to achieve.

When the bex query has Optional Variables only, the setting 'Force Prompts on Startup = False' suppresses the prompt screen and the dashboard runs as per the parameters entered in the URL.

But when the bex query has Mandatory Variable, the setting does not suppress the prompt screen. I tried by giving Default Value in the Global Script variable for the mandatory variable and I have also tried the Default Value by setting in the variable properties inside bex. Both does not work and it still shows the prompt screen upon executing the URL.

My OpenDoc URL is shown below.

http://esesssapd31.ss.sw.ericsson.se:8080/BOE/OpenDocument/opendoc/openDocument.jsp?sIDType=CUID&iDo...

v_fper is mandatory variable and v_assid is optional variable. Below is my global script content and On Startup content.

setVariableValueExt also did not work.

Pls let me know if anybody has achieved it successfully when we have Mandatory Variable in bex query.

Thanks & Regards,

Kesavan.

TammyPowlas
Active Contributor
0 Kudos

Kesavan - this is an old thread; please create a new discussion and state which version of Design Studio you are using.  Thank you

Former Member
0 Kudos

Hi Kesavan,

You can go through this doc and might find it helpful:

http://scn.sap.com/docs/DOC-62190

Thanks,

Arpit