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 !

To report this post you need to login first.

105 Comments

You must be Logged on to comment or reply to a post.

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

    (0) 
  2. Priyal Agarwal

    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

    (0) 
  3. 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.

    (0) 
  4. WILLIAM MARCY 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.

    (0) 
        1. Mahboob 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

          (0) 

Leave a Reply