on 05-08-2006 8:15 PM
I once created a BW report through the portal and it had buttons at the top so once I had filtered my query the way I wanted it I could click the graph button at the top of the screen and automatically graph it. That was very cool! Now I can't remember how I got that option to appear? There was a whole row of icons at the top of the screen, for example one was a pie graph, one was a bar graph, one was an Excel icon, one was CSV I think...
How do I get those to appear? I used Web Application Designer and then referenced it via the portal iView. I don't see the option for the toolbar anywhere and I'm baffled how I did it before.
Hi, Thanks I have successfully added the buttons with your code however when I load the iView and the BW Report displays with the buttons but when I click the buttons nothing happens.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
1. are you using custom template for your output or standard one? looks to be cusomt one.
2. what are you passing in query string parameter when you create the iview, does it have something like cube=XXX&query=XXXX, if yes its using a default template which is set in SPRO
3. from your description i understand you are using a custom template for this query. in that case start WAD and open template 0QUERY_TEMPLATE (thats zero at the starting) and save as in your name space (Y or Z) now open the newly saved custom template and add the table, graphs, for your query. you will get the standard tool bar now.
Regards
Raja
Ok let me explain my process a little bit; when I want a BW report to appear on the web here's what I do.
1) I write a query
2) I create a workbook and attach the query.
3) I customize my worksheet to only show parts of the query I want to display.
4) I save the worksheet as a QUERY VIEW
5) I open Web Application Designer and create a new template
6) I insert a table object into my new template
7) I configure the table object to point to my query view.
😎 I save the web template and give it a name like PORTALPRIORNATMGROUPCASE.
9) In the portal I create a BW Report iView which references PORTALPRIORNATMGROUPCASE.
Am I doing this the difficult way? Basicly I want the simplest way to display my reports on the portal with little effort and I still want to see the standard toolbar.
to show the BW query as an iview , you dont need to create a BW webtemplate (unless otherwise you want to have some specific formatting / features)
1. just create a query and save it
2. create BW query iview and enter the following in the query string parameter
CMD=LDOC&INFOCUBE=<CUBE>&QUERY=<QUERY NAME>
You can also parameter to the query thru the query string
Regards
Raja
Ahh, thank you! You just made me remember how I had it coming up in the past. Yes that works but the problem with a BW Query IView (I am told) is that the single sign on will not work and alternately I need to use a BW 'REPORT' iview instead. So I just tried your suggestion with a BW REPORT Iview and the icons did indeed appear but now the report doesn't load! I'm using a QUERYVIEW instead of a QUERY though so maybe that does not work or maybe it only works with a query iview?
Thanks for your help.
Ok I did more testing.... it looks like it doesn't like it when I put QUERYVIEW instead of QUERY in the URL. I discovered I could put anything in place of QUERY (for example APPLES) and it would display the buttons with a BLANK page (no report). When I choose simply QUERY and reference an existing query I keep getting
The requested query does not exist on the current server.
Unknown or deleted query
I am putting the correct name of the queries though so I'm puzzled.
Ok here's two I have tried. The first is trying to use a QueryView since all my stuff is really query views. The icons appear correctly but no reports;
The second one points to a legitimate Query however I get the message that the query is not found. I'm referencing the Query's technical name in the URL;
Hi Raja,
Thanks for pointing out the problem with my URL! It worked beautifully for the query! It doesn't seem to work for the QUERYVIEW though, is it possible to use QUERYVIEW also instead of QUERY? (This way I don't have to create many many queries, I can simply use one query with multiple query views.)
Hi Patrick,
Firstly sorry as my reply here is not to help you solve your problem but requesting you to kindly send me a snippet wherein I can too create BW reports in EP....
I would surely like to learn how can these reports be programmed\... created except then using the existing EP wizard.
Please ... need your guidance.
Thanks and Warm Regards,
Ritu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
add the following lines of code to your webtemplate.
<table align=right cellspacing="1" bordercolor="#111111" id="AutoNumber1" style="border-collapse: collapse">
<tr>
<td >
<A href="#Navbar">
<IMG title=<SAP_BW_TEXT program='SAPLRRSV' key='742'> alt="<SAP_BW_TEXT program='SAPLRRSV' key='742'>" src="/sap/bw/Mime/BEx/Icons/pixel.gif" border=0 ></A>
<A href="<SAP_BW_URL ITEM='*GR*' MULTI='X' HIDDEN='X' CMD_1='ITEM=*GR1*&MULTI=X&HIDDEN=''>"><IMG alt="<SAP_BW_TEXT program="SAPLRRSV" key="622">" src="Mime/BEx/Icons/S_B_TVAR.gif" border=0></A></td>
<td > |</td>
<!-- Display Bar Chart--->
<td >
<A href="<SAP_BW_URL ITEM='*GR*' MULTI='X' HIDDEN='X' CMD_1='ITEM=GR1GR2NavBlock&HIDDEN=' CMD_2='CMD=RESET_ITEM&ITEM=GR2Chart&WIDTH=600&HEIGHT=400&HIDDEN=&ITEM_ID=0QUERY_TEMPLATE_COLUMNSTACKED&GENERATE_CAPTION='>">
<IMG alt="<SAP_BW_TEXT program="SAPLRRSV" key="657">" src="Mime/BEx/Icons/S_GISBAR.gif" border=0>
</A>
</td>
<!-- Display Pie Chart--->
<td >
<A href="<SAP_BW_URL ITEM='*GR*' MULTI='X' HIDDEN='X' CMD_1='ITEM=GR1GR2NavBlock&HIDDEN=' CMD_2='CMD=RESET_ITEM&ITEM=GR2Chart&WIDTH=600&HEIGHT=400&HIDDEN=&ITEM_ID=0QUERY_TEMPLATE_PIES&GENERATE_CAPTION='>">
<IMG alt="<SAP_BW_TEXT program="SAPLRRSV" key="658">" src="Mime/BEx/Icons/S_GISPIE.gif" border=0>
</A>
</td>
<!-- Display Line Chart--->
<td >
<A href="<SAP_BW_URL ITEM='*GR*' MULTI='X' HIDDEN='X' CMD_1='ITEM=GR1GR2NavBlock&HIDDEN=' CMD_2='CMD=RESET_ITEM&ITEM=GR2Chart&WIDTH=600&HEIGHT=400&HIDDEN=&ITEM_ID=0QUERY_TEMPLATE_LINES&GENERATE_CAPTION='>">
<IMG alt="<SAP_BW_TEXT program="SAPLRRSV" key="659">" src="Mime/BEx/Icons/lines.gif" border=0></A>
</td>
<!-- Display 3D Bar Chart--->
<td >
<A href="<SAP_BW_URL ITEM='*GR*' MULTI='X' HIDDEN='X' CMD_1='ITEM=GR1GR2NavBlock&HIDDEN=' CMD_2='CMD=RESET_ITEM&ITEM=GR2Chart&WIDTH=600&HEIGHT=400&HIDDEN=&ITEM_ID=0QUERY_TEMPLATE_3DCOLUMNS&GENERATE_CAPTION='>">
<IMG alt="<SAP_BW_TEXT program="SAPLRRSV" key="660">" src="Mime/BEx/Icons/columns_3D.gif" border=0></A>
</td>
<td > |</td>
<!-- Display Export Excel--->
<td >
<A href="<SAP_BW_URL CMD='EXPORT' FORMAT='XLS' DATA_PROVIDER='DP' SUPPRESS_REPETITION_TEXTS=' '>">
<IMG alt="<SAP_BW_TEXT program="SAPLRRSV" key="T77"> <SAP_BW_TEXT program="SAPLRRSV" key="T72">" src="Mime/BEx/Icons/S_X_XLS.gif" border=0 ></A>
</td>
</tr>
</table>
Regards
Raja
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.