BusinessObjects Web Intelligence

  1. home
  2. blog
  3. BusinessObjects Web Intelligence

Key Takeaways from Folding with Web Intelligence 4.3 SP2 - Webi Origami

by John S on March 29, 2022 No comments
Folding with Web Intelligence 4.3 SP2 Webi Origami Feature Image Did you miss our March 29th webinar Folding with Web Intelligence 4.3 SP2 - Webi Origami? We have a quick summary of the webinar with the webinar presenters’ key takeaways from their session. Here is the webinar overview: Being able to view report Totals and subtotals and then expand and dig into one of the subtotals while keeping the others still collapsed – this is a feature in Web Intelligence that has some very valuable enhancements in Webi 4.3 sp2. It is now easy and intuitive to analyze a report with folds and this session will cover how to set this up in multiple scenarios.

Key takeaways from this session:

Folding is much easier in 4.3
  • After adding sections and/or breaks to your report, find the folding options on the Display menu
  • Notice the “On report” arrows rather than outside the report as in 4.2
Folding has hover-over tooltips and right click options
  • Clicking on the folding arrow will expand or collapse that section/break
  • Right clicking on the arrow gives options to fold/unfold “All”
Exporting with Folding is “What you see is what you get”
  • Excel and PDF exports will display exactly what is folded/unfolded in Webi at the time of export
  • Neither Excel or PDF will have the expanding arrows.
Visual components can be added to sections with some Advanced Webi features
  • Charts will not display in folded sections
  • However, cells WILL display in the section
  • Cells can include formulas & Unicode to create visual effects
Don’t forget you can stream this webinar in its entirety as well as ever other Let’s Speak BO webinar we’ve hosted when you are logged in on the site. It is completely free to join!
John SKey Takeaways from Folding with Web Intelligence 4.3 SP2 - Webi Origami

Key Takeaways from Tips for Transitioning to the New Webi 4.3

by John S on February 16, 2022 No comments
Tips for Transitioning to the New Webi 4.3 February 15 2022 Feature ImageDid you miss our February 15th webinar Tips for Transitioning to the New Webi 4.3? We have a quick summary of the webinar with the webinar presenters’ key takeaways from their session. This session had a lot of audience interaction with the presenter and we highly recommend checking it out if you use Web Intelligence! Here is the webinar overview:

WebI 4.3 comes with a FIORI-based, modern, and simplified user interface for designing and developing ad-hoc reports, operational reports, highly analytical reports, visually rich dashboards, and more powerful BI content. While this is a great foundational step towards future analytics and end-user experience it is also quite a transition from the classic launchpad that many are used to.

To assuage the fear and panic generated from this huge transformation, this session will share a few tips that we have found quite useful to adapt to the new features faster and make the transition from WebI 4.2 to 4.3 more enjoyable.

Key takeaways from this session:

  • SAP BI 4.3 SP0 was released last year, and the BI Launchpad comes with the new FIORI-based interface with a modern and sleek UX
  • You will experience a great new deal of how you will perform all your WebI tasks
  • While the new UI is great and in alignment with most popular BI tools, and SAC, it is also quite a transition from the classic WebI UI
  • There are two new panels and the 4.2 functionalities are not re-organized and regrouped into the new panels and a lean simplified toolbar
  • There are some cool new features like WebI as a Data source, hiding of report tabs, unified query panel, enhanced formula editor, and some more.
Don’t forget you can stream this webinar in its entirety as well as ever other Let’s Speak BO webinar we’ve hosted when you are logged in on the site. It is completely free to join!
John SKey Takeaways from Tips for Transitioning to the New Webi 4.3

Key Takeaways from Dynamic Dates in Web Intelligence

by John S on February 3, 2022 No comments
Dynamic Dates in Web Intelligence Blog Feature Image Did you miss our February 1st webinar Dynamic Dates in WebI? We have a quick summary of the webinar with the webinar presenters’ key takeaways from their session. This session had a lot of audience interaction with the presenter and we highly recommend checking it out if you use Web Intelligence! Here is the webinar overview:

A common use case is to run a Web Intelligence report for a date range. That can be easily done with hard-coded date values, but that is not a very user-friendly approach always having to edit the query. Certainly prompts are more user-friendly. However, if you want to schedule a report for a dynamic, named date range such as yesterday, last month, last quarter, etc. you are at a dead-end.

This session will show how I built what I call a “Calendar Universe” a number of years ago that has stood the test of time. We will cover various ways to use dynamic dates talking about the pros and cons of each including the “Calendar Universe”.

Key takeaways from this session:

  • Set the prompt order in the Query Properties.
  • Use the format suggestion in the date prompt to convert the prompt value (always a string) to a date.
  • You cannot compare objects in a filter. Instead create a variable that does the comparison and filter on that.
  • Define a custom format for something other than the default or other available formats.
  • Copy the @Prompt function syntax details from the query script of a universe query and then paste it into a free-hand SQL query.
  • When using “Results from another query” cannot use “Between”; must use “Greater than” and “Less than”.
  • Add the pre-defined Query Summary cell to get an objective view of the queries such as execution time and number of rows returned.
  • Generate a date table dynamically with a common table expression (CTE) in a free-hand SQL query.
  • Add the pre-defined Query Summary cell to get an objective view of the queries such as execution time and number of rows returned.
Don’t forget you can stream this webinar in its entirety as well as ever other Let’s Speak BO webinar we’ve hosted when you are logged in on the site. It is completely free to join!
John SKey Takeaways from Dynamic Dates in Web Intelligence

Key Takeaways from Formatting Web Intelligence 4.3 Like a Pro Webinar

by John S on January 19, 2022 No comments
Formatting Webi Intelligence 4.3 Like a Pro Webinar Graphic Did you miss our January 18th webinar Formatting Web Intelligence 4.3 Like a Pro? We have a quick summary of the webinar with the webinar presenters’ key takeaways from their session. Here is the webinar overview: First impressions matter – even for reports! This session will be covering how to use formatting shortcuts and templates to make a meaningful report stand out and shine, including new ways to format Web Intelligence in 4.3.

Key takeaways from this session:

  1. Properties panel makes formatting easier in 4.3
  2. There are many formatting shortcuts in Webi to make beautiful reports faster
  3. We recommend using a report template for consistent, beautiful reports.
In this webinar Roxanne mentioned a PDF template that we have been allowed to share. This PDF document gives the reader a view of the “SR_Template” used by the AO for Webi reports as seen in the presentation. Don’t forget you can stream this webinar in its entirety as well as ever other Let’s Speak BO webinar we’ve hosted when you are logged in on SpeakBO.com website. It is completely free to join!
John SKey Takeaways from Formatting Web Intelligence 4.3 Like a Pro Webinar

Building Visualizations in Web Intelligence – New and Improved

by Analaura Salazar on May 6, 2019 No comments
Building visualizations in webi feature image With so many different Business Intelligence tools out there to use for reporting and business needs, it is sometimes hard to choose one that will fit the business. One tool, that is loved by many, could assist you in just that. This tool is non-other than Web Intelligence. Webi is a powerful tool to build beautiful and interactive visualizations. Take your reports to the next level by watching this webinar! During this webinar, Michael showcased the latest enhancements and features that Web Intelligence has to offer from a data visualization perspective. Michael covered topics such as input controls, intra-document linking, and so much more. After watching this webinar, users will be able to produce a new level of eye-catching dashboard designs. View Recording
Analaura SalazarBuilding Visualizations in Web Intelligence – New and Improved