What’s New in SAP BusinessObjects Design Studio 1.5 to Enhance Performance (Part 1)

  • by Ingo Hilgefort, Vice President of Product Management, Visual BI Solutions
  • August 28, 2015
With the release of SAP BusinessObjects Design Studio 1.5, some important enhancements to components, performance, and functionality have been made in several areas. Review the most important updates of the release 1.5 for SAP BusinessObjects Design Studio and learn the steps for how to make the best use of these new dashboarding functionalities.
Learning Objectives

Reading this article, you will learn about:

  • Merging and unmerging ariables using SAP BusinessObjects Design Studio 1.5
  • Executing parallel queries in SAP BusinessObjects Design Studio 1.5
  • How to use the new data binding functionality of SAP BusinessObjects Design Studio 1.5
  • Concrete steps for leveraging SAP BusinessObjects Design Studio 1.5 new functionalities
Key Concept

SAP BusinessObjects Design Studio 1.5 provides dashboard designers with new functionality in the areas of components, geographic visualization, performance improvements, scripting, and prompt/variable handling, among others. With these new features, such as parallel query execution and the ability to visualize geographic information, SAP BusinessObjects Design Studio has become a true dashboarding environment.

With the release of SAP BusinessObjects Design Studio 1.5, SAP has made significant enhancements in the area of performance and data handling. Here, I review the functionalities of merging and un-merging of variables, parallel query execution, and the new data binding capabilities that come with this new release. All these added capabilities improve the performance of your dashboard. In addition, SAP BusinessObjects Design Studio 1.5 has other new capabilities, such as being able to display geographic information in map form, export the dashboard to a PDF file, the ability to allow users to select data source on-demand, and new components for navigation and filtering.

In this article, I focus on three performance-relevant topics: variable merge and unmerge, parallel processing, and the new data-binding options. In my next article (part two to this one), I discuss the new components, such as the filter line, the navigation panel, the chart picker, and the back-end connection component. In addition, I take a closer look at the integration of geographic maps and the ability to export the dashboard to a PDF file.

How to Merge and Un-Merge Data Source Variables

Before going into the details about these enhancements, let me first clarify what merging of variables actually means in SAP BusinessObjects Design Studio. When you use data sources that contain prompts/variables, these data sources are turned into variables in SAP BusinessObjects Design Studio. Prior and up to release 1.4, the SAP BusinessObjects Design Studio product merged variables based on their technical names, so that a user would only be prompted once. For example, let’s say your dashboard is making use of two underlying BEx queries from your SAP BW system. Both of the BEx queries contain a variable for the dimension customer, and the technical name for the variable is identical (for example VAR_CUSTOMER) in both BEx queries. In this example, SAP BusinessObjects Design Studio would merge these two variables and the user only has to provide the input value once.

In most situations you want to merge these kinds of variables, but there are also circumstances where you would like to un-merge the variables and have the option to provide different values for the variables for each of the used data sources. With SAP BusinessObjects Design Studio 1.5, this is now possible. For example, you might have a dashboard that compares data from the first quarter with the second quarter of the year, the data is retrieved from two data sources, and each data source asks for a time range as input. In such a scenario it is an advantage to be able to un-merge the variables and provide different input values—in my example, for the first and second quarters—for each data source.

Ingo Hilgefort

Ingo Hilgefort started his career in 1999 with Seagate Software/Crystal Decisions as a trainer and consultant. He moved to Walldorf for Crystal Decisions at the end of 2000, and worked with the SAP NetWeaver BW development team integrating Crystal Reports with SAP NetWeaver BW. He then relocated to Vancouver in 2004, and worked as a product manager/program manager (in engineering) on the integration of BusinessObjects products with SAP products. Ingo's focus is now on the integration of the SAP BusinessObjects BI suite with  SAP landscapes, such as SAP BW and SAP BW on SAP HANA, focusing on end-to-end integration scenarios. In addition to his experience as a product manager and in his engineering roles, Ingo has been involved in architecting and delivering deployments of SAP BusinessObjects software in combination with SAP software for a number of global customers, and has been recognized by the SAP Community as an SAP Mentor for SAP BusinessObjects- and SAP integration-related topics. Currently, Ingo is the Vice President of Product Management and Product Strategy at Visual BI Solutions, working on extensions to SAP’s product offering such as SAP BusinessObjects Design Studio and SAP Lumira. You may follow him on Twitter at @ihilgefort.

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.