cancel
Showing results for 
Search instead for 
Did you mean: 

BW Report iView - Buttons to create graphs on the fly

Former Member
0 Kudos

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.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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.

Former Member
0 Kudos

Maybe I'm not pasting the HTML in the right place? I posted it at the very top and the new icons now appear to the right of my table filtering options.

athavanraja
Active Contributor
0 Kudos

just copy 0QUERY_TEMPLATE in to your own name space add the table and graphs you want there. this is standard template with all those buttons.

Regards

Raja

Former Member
0 Kudos

I'm not sure how to do what you are asking? Can you elaborate just a little bit more? Where do I find the 0QUERY_TEMPLATE? What name space are you refering to? Thanks!

athavanraja
Active Contributor
0 Kudos

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

athavanraja
Active Contributor
0 Kudos

is your question answered? reward points to helpful answers by choosing the appropriate radiobuttons

Regards

Raja

Former Member
0 Kudos

Hi,

I have been out of office. I'm not using a custom template that I know of.

Former Member
0 Kudos

You can't see it but the end of my pasted url is &DATA_MODE=STORED

athavanraja
Active Contributor
0 Kudos

looking at the url the template name is PORTALPRIORNATMGROUPCASE

since its not starting with Z or Y it doesnt look like a custom one, but at the same time i have checked my BW3.5 system and didnt see a standard template with this name.

which version of BW are you working on

Regards

Raja

Former Member
0 Kudos

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.

athavanraja
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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.

Former Member
0 Kudos

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.

athavanraja
Active Contributor
0 Kudos

post the query string you have used , i will correct it and post it back here.

Regards

Raja

Former Member
0 Kudos

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;

https://portal.barberfoods.com:8443/sap/bw/BEx?sap-language=EN&bsplanguage=EN&CMD=LDOC&CUBE=S900&QUE...

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;

https://portal.barberfoods.com:8443/sap/bw/BEx?sap-language=EN&bsplanguage=EN&CMD=LDOC&CUBE=S900&QUE...

athavanraja
Active Contributor
0 Kudos

please read my earlier post the pattern for the query string is

CMD=LDOC&INFOCUBE=<CUBE>&QUERY=<QUERY NAME>

its infocube and not cube

Regards

Raja

Former Member
0 Kudos

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.)

athavanraja
Active Contributor
0 Kudos

i dont know about passing queryview in the url, can you close this thread and post this in BW forum.

Regards

Raja

Former Member
0 Kudos

Ok thanks Raja for all your help! Ritu, you should probably create a new thread too.

-Patrick

athavanraja
Active Contributor
0 Kudos

Hi Patrick,

I am trying to find out how to pass the query view id to the url (i am sure it is possible). as soon as i find something i will update this thread, if you are successful in BI forum, kindly update this thread with the solution.

Thanks and all the best.

Regards

Raja

Former Member
0 Kudos

Ok thanks Raja. I have created a separate topic regarding the QueryView.

-Patrick

Answers (2)

Answers (2)

Former Member
0 Kudos

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

athavanraja
Active Contributor
0 Kudos

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