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.
It goes like this.
- Create report, adding the fields you want
- 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
- Change your layout of the “year” table: like this
- you can go to table-properties: Format Table >> Appearance >> Spacing and Padding >> Set horizontal (and vertical) to like 0.5cm
- Create element linking
Report Element >> Linking >> Element
- Link the “year”-table (horizontal table) to your “report”(Crosstab)
- Et voila, your webi works now interactive via the linking
- Now put some make-up on the report. (adding button image in your “year”cells) and you will have “buttons in your webi report“
- 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
Good document.
Thanks for putting this together. It is excellent.
Awesome
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.
Hi,
Right click on the cell, go to format cell, go to last tab, there you can set the image.
Grts
Koen
Thanks Koen, I am able to do it now.
Rajesh
Good Document
No no, I just used an image as background in the cells of the header, "all years"
Sorry, suddenly deleted the question about image.
For me header does not work as a total selection. Should something else be done?
Regards
No,
Which version are you on?
It's working perfectly on the BI 4.1 SP 1
Kr,
Koen
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
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
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
Awesome, Thanks for sharing and stay blessed.
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?
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
Thanks Mahboob for the clarification. Wish SAP should have included some useful inbuilt images for visualization.
Thanks, Krishna