cancel
Showing results for 
Search instead for 
Did you mean: 

Question on WAD

12-08-2008 3:31 PM
1219 views 28 comments Go to solution
0 Likes
SAP Managed Tags
Subscribe

Hi,

I need to develope a webpage or something else, where we need to provide a drop down box for a list of WAD reports we have. If the user selects reports, then each report shud be executed in a separate different sessions ! Please guide me on how to start!

0 Likes

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Likes

Hi Rahul,

I sent to you my solution if you have any questions please inform me.

Regards

Erwin

Former Member
0 Likes

Hi Rahul,

Did you try Erwin's Solution? If that does not work then I can post mine.

Datta.

Former Member
0 Likes

Dattatraya,

I'm trying Erwins solution. Will let you know if it works. Between, can you also post your solution, so that I/we would know different ways of approaching the task.

Thanks,

Rahul.

Former Member
0 Likes

Ok here you go.

I started by Creating a blank Template in WAD for 3.5

In the Head section of the Web Template add the following Code as Javascript.

Create a Function in Javascript.


fun  dropdown( myval ) 

start with a curly bracket
      var surl, smess 
      
     surl = web site string 
     e.g http://server:port/sap/bw/BEx?sap-language=EN&bsplanguage=EN&CMD=LDOC&TEMPLATE_ID=
     smess =  Please Choose a Report to Run
    
     Check if the value in myVal is X 
         incase it is X then show an alert message to user and then return false 

     in case it is not X then you have the template to run 
   
     append the value in myval to surl and use a open method of the window to run the url 
     in a separate window 
     and return true 
end with a curly bracket.
 

In the Body Section of the Web page please create and HTML Drop down box using the select Tags of HTML.

First Option will be X and text for that will be choose a report

Next Option store the Value as Technical Id of the Template and the Description for Dropdown.

Then create an INPUT Button with and onclick to call the function

onclick will then call the javacript function with gourl.value as a parameter.

Since we cannot post the code please google up the syntax for SELECT and INPUT Button incase you don't know that.

You can pretty up the Page by Adding Heading and Logo and Table Etc.

Try with Couple Templates before you add all the Templates in the Dropdown list.

Save the Template and you should be ready to go.

Hope this helps. Not sure why we can preview code and then it won't post. I think some characters of the code are causing it to fail.

Datta.

Former Member
0 Likes

Thanks Dattatraya.

Im trying Erwins solution for now and will let you know how your solution goes!

Thanks,

Rahul.

Former Member
0 Likes

Erwin,

Your solution worked for me, but I have few questions which I drafted in a email to you. Please let me if you have time!

Thnx,

Rahul.

Answers (9)

Answers (9)

Former Member
0 Likes

in 7.0 it is much easier, you don't have to use javascript. Here you can use commands:

at first you need to create dropdown_item. By Data Binding (dropdown_item) you should choose Fixed List of Option. Here you can write names of your web applications. After that you can use command wizard and the command: SET_TEMPLATE for each web template.

By SET_TEMPLATE please choose "Open in New Window"

Regards

Erwin

Former Member
0 Likes

Hi

Thanks a lot...will try it out & send an email tomorrow for sure..if it is such easier...then far better..

Thanks

BI Learner...

Former Member
0 Likes

Hi

Could you help me using variables in text web items..& what commands i can use to display based on characteristics.???

Thanks

BI Learner

Former Member
0 Likes

sorry my solution is only for 3.5, but read this thread from the beginning I gave some tips for BI7.0 too.

Regards

Erwin

Former Member
0 Likes

hi

so you dont have solution for BI7.0????is it not possible to apply half of it in 7.0 as well....

if cannot apply, why such a vast difference with 3.5 & 7.0....looks really difficult...

Thanks

BI Learner...

Former Member
0 Likes

Hi Erwin,

Do you mind sharing your solution you can send it to my info on my Business Card if you don't mind

Thanks

Datta.

Former Member
0 Likes

Hi

Do you also use WAD 3.5?

Regards

Erwin

Former Member
0 Likes

Hi

Nope I am using BI7.0...my id is bi_sap21 at yahoo dot com

Thanks

BI Learner

Former Member
0 Likes

Hi Rahul,

sorry but I was yesterday not available.

Thanks for your fast reply. The code works for me, but I need to tweak it a bit for a better look. You can see the format of the output I get in the attchment.I need to change the format like:

...

It would be better if you can provide me material on formatting the Script with colors/lines/font.

Please guide.

You should use CSS (Cascading Style Sheets). Check this link, you can find there a lot of examples:

http://www.w3schools.com/css/css_examples.asp

Regards

Erwin

Former Member
0 Likes

Erwin,

I tried with your link to find the syntax, but it didnt help me out. Can you please check your email to see my detailed message and reply back!

Thanks

Rahul.

Former Member
0 Likes

Hi,

You can use something like this,

Start a new Web application in the main window

SAPBWSetOpenerUrl(SAP_BW_URL_Get() + "&CMD=LDOC&TEMPLATE_ID=NewTemplate");

Please go through the link below, its the Web API Ref for WAD 3.5 and this will surely sort out your problem. You can search for dropdowns or search for commands to open up reports in new window.

https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/b1089290-0201-0010-288c-98e4d264...

Even i had some problem in posting a code, pls go through the Web API. Hope this helps.

Former Member
0 Likes

I don't know why but I can't send you the code. If you want you can send me an ma-l l: check my Business Card

I will send you per m.

Regards

Erwin

Former Member
0 Likes

Hi Rahul,

here you have some simple example:

you have to adjust technical names of your web applications




...

...

I have some problems to send a code

Regards

Erwin

Edited by: Erwin Buda on Dec 8, 2008 9:27 PM

Former Member
0 Likes

Maybe the code needs to be "commented - out" so we could see it?

Former Member
0 Likes

Hi Erwin

Could you please give the code how to do with that..I too have dropdown with different query selections to be brought...by selecting the query from dropdown it should display the Output of that selection...??

Thanks

BI Learner

Former Member
0 Likes

sorry you can forget it. It refers to WAD 7.0

Former Member
0 Likes

Hi,

at first you need to create dropdown_item. By Data Binding (dropdown_item) you should choose Fixed List of Option. Here you can write names of your web applications. After that you can use command wizard and the command: SET_TEMPLATE for each web template.

By SET_TEMPLATE please choose "Open in New Window"

Regards

Erwin

Edited by: Erwin Buda on Dec 8, 2008 3:49 PM

Former Member
0 Likes

Erwin,

Im on 3.5 version.

By following your steps, I could create a Drop Down web item, but we need to assing some query to this before we change any property right! My requirement is to have a list of WAD reports in 1 page, so that we can select which report we want to run! And I didnt understand your steps:

"By Data Binding (dropdown_item) you should choose Fixed List of Option. Here you can write names of your web applications. After that you can use command wizard and the command: SET_TEMPLATE for each web template. "

By SET_TEMPLATE please choose "Open in New Window"

Please guide!

Former Member
0 Likes

Hi Rahul,

Is creating a simple HTML Page with Dropdown Box an Option ?

If so then using WAD you can create a Page with Java script Drop down box and use URL to Templates by doing window.location = url you should be able to launch the web report in separate window.

I am going to try this will post back.

Hope that gets you started.

Datta.

Former Member
0 Likes

Hi Dattatraya!

I thought a web page with Drop Down box as 1 option for my task! If you have any other ideas, please let me know. Plz let me know if the web page solution works for you!

Former Member
0 Likes

Hi Rahul,

I got this work with the 3.x Template. Let me know if you need help with this.

Datta.

Former Member
0 Likes

Hi Dattatraya,

Please let know on how to work on this! Any help will be greatly appreciated!

Thanks,

Rahul.