Skip to Content
Author's profile photo William MARCY

Webi 4.x tricks : summary

Webi_tricks.png

Hi everyone,

I am pleased to share with you some tips on the advanced use of Web Intelligence. These few tutorials allow you to give more value to your existing documents or to come or just to give you ideas for your future designs.

All my tricks are just a focus on some capabilities of the application, if you want more details about what you’re able to do with it, share your thought with me I’ll be happy to talk about it.

All entries are ranked by difficulty and by authors because I spend a lot (lot, lot, lot) of time searching on SCN great tips on Web Intelligence and some good entries are unfortunaltely hidden…so it’s time to raise your hands guys (and girls ).

New features in Web Intelligence 4.2

Performance Charts & other features

openSrc_sdk.png

New WebI feature in BI4.2 – Parallel Queries by Robert Twigg

openSrc_viz.png

How to build a Custom Elements service for SAP Web Intelligence 4.2 by Pascal GAULIN

New features in Web Intelligence 4.2 SP3

SAP BI 4.2 SP3: What’s New in Web Intelligence by  Christian AH-SOON available here SAP BI 4.2 SP3: What’s New in Web Intelligence

Summary

Tricks Design Performance Sizing Auditing Following Debugging

Legend

Picture Level Description
/wp-content/uploads/2013/12/legend2_340541.png Level 1 Difficulty is very low. Easy to set up and you can turn easily your existing document into value-added report effortless
/wp-content/uploads/2013/12/legend3_340542.png Level 2 Difficulty is low. Use analysis tools to interact with your report and give extra value to your operational reporting.
/wp-content/uploads/2013/12/legend4_340543.png Level 3 Difficulty is medium. Some of features used are advanced features and you’ve to be familiar with Web Intelligence.
/wp-content/uploads/2013/12/legend5_340544.png Level 4 Difficulty is high. Damn, your Webi document is so interactive and so cool. Restless to show and share it with others !
/wp-content/uploads/2013/12/legend_340545.png Level 5 Difficulty is extreme. How did he do that ? I’ve read 8 times the document and I still understand nothing.

Tricks

Difficulty Author Link to document
/wp-content/uploads/2013/12/legend2_340541.png

Abhijit Ingale

WEBI 4.0 Trick – Creating Progress Bar
/wp-content/uploads/2013/12/legend3_340542.png

Rakesh Pattani

BOBJ Trick To Display Table Data In Hierarchy Format
/wp-content/uploads/2013/12/legend3_340542.png Durgamadhab Mishra Webi tricks : Selecting Top N customers by Sales Percentage using a Slider
/wp-content/uploads/2013/12/legend3_340542.png WILLIAM MARCY

Webi tricks : Interactive selecting and viewing TOPn data

/wp-content/uploads/2013/12/legend5_340544.png Abhijit Ingale WEBI – Dynamic Line Chart driven by Input Control
/wp-content/uploads/2013/12/legend2_340541.png Harsha Ganapathy Creating a Sparkline chart for IPad
/wp-content/uploads/2013/12/legend2_340541.png Neha Kumari How to use formulae to change date and time formats in WebIntelligence
/wp-content/uploads/2013/12/legend3_340542.png Andreas Kaufmann alternate row colors in a break
/wp-content/uploads/2013/12/legend2_340541.png Tauseef Ali Mir Dynamic Variables using Input Control
/wp-content/uploads/2013/12/legend4_340543.png Nagavaibhav Elluru Custom message to replace ‘No Data in the query’
/wp-content/uploads/2013/12/legend4_340543.png Victor Gabriel Saiz Castillo All you need to know about #TOREFRESH
/wp-content/uploads/2013/12/legend3_340542.png Michael Thompson Webi tricks: How to build a butterfly chart
/wp-content/uploads/2013/12/legend5_340544.png Huu Nguyen Linear & Polynomial Trend Lines in Webi
/wp-content/uploads/2013/12/legend3_340542.png Michael Thompson Webi tricks: Bars embedded into rows
/wp-content/uploads/2013/12/legend3_340542.png Huu Nguyen WebI Trick: Line chart to show running average for each year
/wp-content/uploads/2013/12/legend5_340544.png Harshil Joshi Date Variables in Web Intelligence
/wp-content/uploads/2013/12/legend4_340543.png Huu Nguyen WebI Trick: Top N data for any integer N using Entry field Input controls
/wp-content/uploads/2013/12/legend5_340544.png Tanav Gupta How to Add Document links (Interlink WEBI reports) in SAP Business Objects Web Intelligence 4.0
/wp-content/uploads/2013/12/legend4_340543.png Sateesh Kumar Show Trend Icon/Arrows in webi as per conditions

/wp-content/uploads/2013/12/legend2_340541.png

Huu Nguyen Conditional formatting based on User input
/wp-content/uploads/2013/12/legend4_340543.png Koen Hesters Dynamic Visibility within a Webi Report
/wp-content/uploads/2013/12/legend4_340543.png David G WebI trick: Create a SEARCH Input Control for your WebI report part!
/wp-content/uploads/2013/12/legend5_340544.png Sateesh Kumar Dynamic Ageing Buckets in Webi
/wp-content/uploads/2013/12/legend4_340543.png Sujitha Grandhi Dynamic Visibility – Input Controls with Ranking
/wp-content/uploads/2013/12/legend4_340543.png Jonathan Brown Creating a Webi doc off of an unmanaged Excel data source on a network share
/wp-content/uploads/2013/12/legend5_340544.png Rakesh Pattani Merging Charts in WebI
/wp-content/uploads/2013/12/legend5_340544.png Rogerio Plank How to insert a Gauge chart inside a WEBI Document
/wp-content/uploads/2013/12/legend5_340544.png Selvarasan Subramanian Dense Ranking in SAP Business Objects Web Intelligence
/wp-content/uploads/2013/12/legend5_340544.png Jordan Bishop How to create a Speedometer inside of a Web Intelligence document
/wp-content/uploads/2013/12/legend2_340541.png Mahboob Mohammed Secret Custom Format (for Date) in Webi
/wp-content/uploads/2013/12/legend4_340543.png swapnil bhootwala String aggregation on WEBI report level.
/wp-content/uploads/2013/12/legend5_340544.png Rogerio Plank How to set a WEBI document to autorefresh each n seconds
/wp-content/uploads/2013/12/legend4_340543.png Kwaja Noorullah Khateef How to grant filtering functionality for viewers/end-users on ‘Input Control’ enabled report blocks(Chart & Table) in web Intelligence reports without enabling the design mode’
/wp-content/uploads/2013/12/legend4_340543.png SANDEEP SINHA Dimensions as Input Control- Dynamic Control | SCN
/wp-content/uploads/2013/12/legend5_340544.png Rogerio Plank Merging 3 Data Providers compatible 2 by 2
/wp-content/uploads/2013/12/legend4_340543.png Rogerio Plank Implementing a calendar like filter in the body of a report
/wp-content/uploads/2013/12/legend4_340543.png Didier MAZOUE Usage of mini charts in tables
/wp-content/uploads/2013/12/legend5_340544.png Didier MAZOUE Sort columns using input controls in read-only access
/wp-content/uploads/2013/12/legend5_340544.png Didier MAZOUE Top-Bottom ranking using input controls in read-only access
/wp-content/uploads/2013/12/legend5_340544.png Didier MAZOUE Display vertical labels in tables
/wp-content/uploads/2013/12/legend4_340543.png Mahboob Mohammed Sum & Avg lines in Chart
/wp-content/uploads/2013/12/legend_340545.png Mahboob Mohammed Accurately positioned Custom Comments in Column Charts
/wp-content/uploads/2013/12/legend4_340543.png Didier MAZOUE Display numbers in English words
/wp-content/uploads/2013/12/legend2_340541.png Niraj Parihar Dealing with Null Values in a Chart
/wp-content/uploads/2013/12/legend4_340543.png Didier MAZOUE Charts windowing
/wp-content/uploads/2013/12/legend_340545.png Mahboob Mohammed Relative positioning of a block w.r.t 2 (or more) blocks OR Container in Webi

Designing

This section will help you designing the structure of your Web Intelligence document. You will be able to highlight your data into a Webi document well-designed with some best practices from experts.

Author Link to document
WILLIAM MARCY Designing smart report with Web Intelligence
Merlijn Ekkel Best Practices for Web Intelligence Report Design

Performance

Challenge accepted ! Once your document is complete and functionnal, think about performance. A well designed document is nothing for user if it opens in 10 minutes. So performance is the key to help users to understand the power of Web Intelligence. Jonathan Brown made a full document containing all tips for Optimizing the Performance of Web Intelligence Documents.Others related documents can be added to this table to find easily how to optimize performance.

One of the big challenge with SAP BusinessObjects on SAP landscape is to get best performances with Web Intelligence based on SAP BW using BICS (Business Intelligence Consumer Service) connection. @kurt.holst gave us a complete overview of best practices using Webi against SAP BW.

Author Link to document
Jonathan Brown Tips for Optimizing the Performance of Web Intelligence Documents
Kurt Holst How to Performance Optimize SAP BusinessObjects Reports Based Upon SAP BW using BICS Connectivity

Sizing

Author Link to document
Matthew Shaw Performance Tips: Getting the most out of your Web Intelligence Processing Servers

Auditing

Author Link to document
Matthew Shaw WebiAdminTool – Business Intelligence (BusinessObjects) – SCN Wiki

Following

The Web Intelligence Bulletin (this page) is a timely and regularly-updated information source providing links to hot issues, new documentation and upcoming events of interest to Web Intelligence Users and Administrators (extract from the Web Intelligence Bulletin – source : see below).


Author Link to document
Adam StoneTed Ueda & Jason Everly & Michael Neville The WebI Bulletin

Debugging

Webi.png

A structured introduction and collection of hints, basic product information, best practices and links in the area of Web Intelligence. The goal is to provide end users a basic knowledge package to avoid or solve issues during the day to day business.


Special ovation to Timo Seufert and ALL the BI TEAM HUNGARY for their work knowing that Webi incidents can make you crazy. Good job team !


Additional ressources

You can see more things about Web Intelligence on space dedicated :

SAP BusinessObjects Web Intelligence

Creating Extensions to SAP BusinessObjects Web Intelligence

http://scn.sap.com/docs/DOC-54507

And more official documentation on Help Portal at :

SAP BusinessObjects Web Intelligence 4.1 – SAP Help Portal Page

One more thing, if you want to index your entry with a “Webi trick”, leave a comment and I’ll add your link ASAP. I’ll update this document frequently with new entries I’ll find out on SCN.

Have fun !

Assigned Tags

      106 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo M Mohammed
      M Mohammed

      Hi WILLIAM MARCY,

      How about adding the below document to this Webi trick list?

      Accurately positioned Custom Comments in Column Charts

      Thanks,

      Mahboob Mohammed

      Author's profile photo William MARCY
      William MARCY
      Blog Post Author

      Soon integrated

      Author's profile photo Didier MAZOUE
      Didier MAZOUE

      Hi William,

      How about adding the underneath document in your WebI list?

      Display numbers in English words

      Thank you

      Didier

      Author's profile photo William MARCY
      William MARCY
      Blog Post Author

      Soon integrated

      Author's profile photo Former Member
      Former Member

      Hello William,

      How about addingDealing with Null Values in a Chart let me know if this is useful.

      Regards

      Niraj

      Author's profile photo Former Member
      Former Member

      Thanks!! William and Divya Glad you liked it.

      Author's profile photo Former Member
      Former Member

      Hello William,

      I created a document Displaying Age of person in X Years Y months and Z days from two dates.. that has been useful in most of the cases. Could you please see if this can be added?

      Regards

      Niraj

      Author's profile photo William MARCY
      William MARCY
      Blog Post Author

      I'll have a look soon.

      William

      Author's profile photo Former Member
      Former Member

      Thanks William!!

      Author's profile photo Didier MAZOUE
      Didier MAZOUE

      Hi William,

      I created 2 documents that could be interesting to be listed in your document:

      Could you please have a look and see if they can be added?

      Thanks and regards,

      Didier

      Author's profile photo Arun Das
      Arun Das

      Nice Work William and guys.

      Keep sharing.

      This is gonna be really interesting. Will definitely share any ideas or trick that which is not listed.

      Regards,

      Arun

      Author's profile photo M Mohammed
      M Mohammed

      Hi William,

      Check this document which I created a while ago.

      Webi tricks to save hour(s) of work (in present & in future)

      Thanks,

      Mahboob Mohammed

      Author's profile photo Former Member
      Former Member

      Great list!

      Thanks for sharing your knowledge!

      Boris

      Author's profile photo M Mohammed
      M Mohammed

      Hi WILLIAM MARCY,

      Please check out this blog post and add it to this list, if it's worth it.

      Continuous Page Numbering in Multi-tab Webi Document

      Thanks,
      Mahboob Mohammed

      Author's profile photo M Mohammed
      M Mohammed

      Hi WILLIAM MARCY

      Please check out the below blog post.

      Conditional font coloring of hyperlinked columns

      Thanks,
      Mahboob Mohammed

      Author's profile photo William MARCY
      William MARCY
      Blog Post Author

      Thx Mohammed. I'll have a look soon.

      Author's profile photo M Mohammed
      M Mohammed

      Hi ,

      Please check out this blog post, this is something that people often need. May be, you can add it to this list.

      Halfhourly Timestamps in a Chart (Webi)

      Thanks,

      Mahboob Mohammed

      Author's profile photo Former Member
      Former Member

      Hi William,

      Thanks for creating such a great post,now it's very easy to learn new tricks and get solution of many issues.   πŸ™‚ πŸ™‚

      Regards

      Priyal

      Author's profile photo M Mohammed
      M Mohammed

      Hi WILLIAM MARCY,

      Check out this blog and hopefully, add it to the list.

      Relative positioning of a block w.r.t 2 (or more) blocks OR Container in Webi

      Thanks,
      Mahbooob Mohammed

      Author's profile photo William MARCY
      William MARCY
      Blog Post Author

      Done Mohamed ! Whaaaat a job ! 😎

      Author's profile photo Former Member
      Former Member

      Nice document, thanks for sharing. πŸ™‚

      Author's profile photo M Mohammed
      M Mohammed

      Hi WILLIAM MARCY,

      Please check out this blog and add it to the list if you think it should be.

      Cascading Prompts in Webi, similar to Crystal Reports (NOT Cascading LOVs)

      Thanks,

      Mahboob Mohammed

      Author's profile photo William MARCY
      William MARCY
      Blog Post Author

      Yep, great work. I'll add your entry asap.

      Author's profile photo M Mohammed
      M Mohammed

      Hi William,

      Cascading Prompts in Webi, similar to Crystal Reports (NOT Cascading LOVs)Β is waiting to be added. πŸ™‚

      Also, I created this Chart Background as Alerter today. Please check it out.

      Thanks,
      Mahboob Mohammed

      Author's profile photo M Mohammed
      M Mohammed

      Hi WILLIAM MARCY,

      Rogerio Plank's below trick can't evade Webi tricks πŸ˜‰ , please add it to this list.

      Using an Interactive InfoGraphic in your WEBI Report

      Thanks,

      Mahboob Mohammed

      Author's profile photo Naveen Reddy Yolugoti
      Naveen Reddy Yolugoti

      Thanks a lot to everyone who contributed for this amazing blog. I really appreciate everyone's effort and contribution to this blog.

      Keep up the great work everyone and excellent job by William Marcy in making a platform for all the great minds to come together with all the hidden Webi tricks and tips.

      Author's profile photo William MARCY
      William MARCY
      Blog Post Author

      I'm sorry guys if I'm not anymore active on "RIP SCN" but the new "blog" ecosystem is not my cup of tea. All is so much complicated and I don't have time to search, modify or anything else on this new platform. I simply quit.

      I'll make some effort to maintain this blog for the community, but it'll be the only things I'll do here.

      Author's profile photo M Mohammed
      M Mohammed

      Hi William,

      Would you be able to grant me ability to edit this blog?

      Thanks,
      Mahboob Mohammed

      Author's profile photo William MARCY
      William MARCY
      Blog Post Author

      Yep for sure. I just have to know how I can edit this blog. This is not obvious...

      Author's profile photo M Mohammed
      M Mohammed

      As long as you're the author, you'll see the Edit icon on top, somewhere below the blog heading, but there is no option in the edit screen to add someone else as a Moderator to a blog. I'll try to find that out and let you know. This Webi Tricks is such a great resource, but no activity since the migration to this new portal.

      Thanks,
      Mahboob Mohammed

      Author's profile photo Former Member
      Former Member

      Hi,

      Its a great effort...

       

      Regards,

      shaik