Skip to Content
Author's profile photo Koen Hesters

Buttons in Webi (Improve Interactive Reporting) + clear filter in report resultpage

Hi,

 

A nice way of making your Web Intelligence Report even more interactive is adding “buttons”.

For example we want to have “buttons” for “year” as selection.

0000Capture.PNG

It goes like this.

  1. Create report, adding the fields you want
  2. 0001Capture.PNG
  3. Change the layout of your table, add a second table above your first one and enter only “year” in it, make sure it is a horizontal table
  4. 0002Capture.PNG
  5. Change your layout of the “year” table: like this0004Capture.png
  6. you can go to table-properties: Format Table >> Appearance >> Spacing and Padding >> Set horizontal (and vertical) to like 0.5cm
  7. Create element linkingCapture2.PNGReport Element >> Linking >> Element
  8. Link the “year”-table (horizontal table) to your “report”(Crosstab)Capture3.PNG
  9. Et voila, your webi works now interactive via the linkingCapture4.PNG
  10. Now put some make-up on the report.  (adding button image in your “year”cells) and you will have “buttons in your webi reportCapture5.PNG
  11. Note: the header works as a total selection, all values are selected on click (like the clear in input control), so you can pimp it even some more
  12. 0000Capture.PNG

Assigned Tags

      17 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Good document.

      Author's profile photo Former Member
      Former Member

      Thanks for putting this together. It is excellent.

      Author's profile photo Former Member
      Former Member

      Awesome

      Author's profile photo Former Member
      Former Member

      Hi Koen,

           Could you explain a bit more about how you have added the images for buttons

      ie., after step 10.

      I was able to follow you till there but I am kinda lost after that.

      Author's profile photo Koen Hesters
      Koen Hesters
      Blog Post Author

      Hi,

      Right click on the cell, go to format cell, go to last tab, there you can set the image.

      Grts

      Koen

      Author's profile photo Former Member
      Former Member

      Thanks Koen, I am able to do it now.

      Rajesh

      Author's profile photo Former Member
      Former Member

      Good Document

      Author's profile photo Koen Hesters
      Koen Hesters
      Blog Post Author

      No no, I just used an image as background in the cells of the header, "all years"

      Author's profile photo Former Member
      Former Member

      Sorry, suddenly deleted the question about image.

      For me header does not work as a total selection. Should something else be done?

      Regards

      Author's profile photo Koen Hesters
      Koen Hesters
      Blog Post Author

      No,

      Which version are you on?

      It's working perfectly on the BI 4.1 SP 1

      Kr,

      Koen

      Author's profile photo Former Member
      Former Member

      Hi,

      I have a lower one, 4.0 SP6 + IE9, can be a current version bug. But now I have no possibility to try on 4.1.

      Many thanks in any case

      Regards

      Author's profile photo Krishna Narravula
      Krishna Narravula

      Hi Koen,

       

      I find this topic is very useful when creating dashboards in WEBI. I am currently using 4.2 SP3 version. How I can able to change cells into Buttons? Followed format cell, and the last tab is "Layout" which doesn't have to change the cell. Do we need to upload a tton image or would you help on how to navigate make changes? Thanks, Krishna

      Author's profile photo Former Member
      Former Member

       

      How to get rid of of button that appears in last cell top right corner (Which is used to reset Input control). I want to hide it so that users don't have reset functionality because it is not needed for our requirement.

      I tried by Overlapping Color filled Blank Cell/Table. However when switched to html mode it always appear.

      version: 4.2

       

      Author's profile photo Lateef mohammed
      Lateef mohammed

      Awesome, Thanks for sharing and stay blessed.

      Author's profile photo Krishna Narravula
      Krishna Narravula

      Hi Koen,

       

      I am using 4.2 SP3 and creating some visualization reports, and trying to add Buttons for cells. I am not able to locate under format cell. As you mentioned above that format cell the last tab which is "Layout". Would you please help to navigate?

      Author's profile photo Mahboob Mohammed
      Mahboob Mohammed

      Hi Krishna,

      Those buttons are not available by default, you'll have to create them using some images, and save locally, and then use them.

      Thanks,
      Mahboob Mohammed

      Author's profile photo Krishna Narravula
      Krishna Narravula

      Thanks Mahboob for the clarification. Wish SAP should have included some useful inbuilt images for visualization.

       

      Thanks, Krishna