on 10-07-2013 12:56 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
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
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.
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:
Also please send the whole opendocument url that appears in the browser where your prompt screen appears.
Thanks.
David
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
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
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
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
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.
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.
Hi Kesavan,
You can go through this doc and might find it helpful:
http://scn.sap.com/docs/DOC-62190
Thanks,
Arpit
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.