Connecting Web Intelligence Reports with Hyperlinks and Prompted Filters

  • by Jim Brogden, Senior Consultant, Daugherty Business Solutions
  • September 23, 2011
By adding links to other SAP BusinessObjects documents in your SAP BusinessObjects Web Intelligence reports, you can provide drill-through capabilities to reports and significantly cut down on the time it takes to analyze a dataset. Learn the details about how to create and edit links to reports.
Key Concept

The OpenDocument application provides the capability of writing syntax statements that launch, refresh, and pass parameters to other published BusinessObjects reporting documents through a URL.

The need for more detailed information is a common request from business analysts and decision makers when analyzing company data. Performing an exhaustive root cause analysis on a subject is often the most successful strategy for identifying problems and pinpointing areas to maximize profits. However, this process can be time-consuming for business users as they sift through rows of extraneous results to get to relevant information. Even when information is compiled from multiple universes and data sources, comprehensive analysis generally means studying several reports before making important decisions.

A powerful method for resolving this type of business problem is to link SAP BusinessObjects Web Intelligence (also known as WebI) reports to other SAP BusinessObjects documents, creating an integrated business intelligence reporting solution rather than a series of stand-alone reports. Report writers and ad-hoc users alike have the capability of producing a guided analysis for the report-viewing audience by connecting reports with hyperlinks. This approach returns only the needed and pertinent information, with a hyperlinked report passing values to a prompted query filter in a separate Web Intelligence document.

An example of this type of analysis occurs when analyzing company spend by region. While reviewing the data, it’s discovered that the highest spending patterns continually occur in the southeast region. Analysts know they need to investigate several different types of spending in the southeast to get a complete understanding of the situation. They also know that the data exists in several different Web Intelligence reports. What’s not known is exactly which reports contain the data needed to perform a thorough analysis.

Instead of requiring analysts to return to the InfoView portal, locate each report individually, and filter the data set to only show the southeast region, links can be created that pass the selected value — in this case, southeast — to a prompted filter in a linked report that only returns data related to the southeast region. The report is launched with a single click and the needed information is returned to the analysts quickly and accurately.

Jim Brogden

Jim Brogden is a senior consultant specializing in SAP BusinessObjects and data visualization for Daugherty Business Solutions in Atlanta, GA. He’s the lead author of the first official book dedicated to Web Intelligence covering version XI 3.1 and the SAP PRESS book SAP BusinessObjects Web Intelligence 4.0 – 2nd Edition, a blogger on http://www.myxcelsius.com/, a BusinessObjects Certified Professional, award-winning Xcelsius dashboard designer, ASUG volunteer, and active contributor at SAP’s Idea Place. You may view Jim’s profile on LinkedIn at www.linkedin.com/in/jimbrogden and follow him on Twitter @jhbrogdenjr.

If you would like to submit an article idea, contact the editor.

See more by this author


Comments

No comments have been submitted on this article. 


Please log in to post a comment.

To learn more about subscription access to premium content, click here.