Becoming a SAP Business Warehouse Query Expert

Become a BW Query Expert by taking part in the "SAP Business Warehouse Plan and Actual Comparison of Book Sales" project. This course will help you build flexible optimized queries and integrate your results with Excel.
Course info
Level
Beginner
Updated
Feb 27, 2017
Duration
2h 25m
Table of contents
Description
Course info
Level
Beginner
Updated
Feb 27, 2017
Duration
2h 25m
Description

Conditional formatting is an important concept for driving the focus of the reader and for ranking the information. Our queries function well, but they are still inflexible. The variables make our queries flexible. In this course, Becoming a SAP Business Warehouse Query Expert, you'll learn how to develop a complex, but flexible sales tactical analysis in Excel with Query Designer and with Bex Analyzer. First, you'll explore conditional formatting with exceptions and creating top lists with conditions in the Query Designer. Next, you'll learn how to create a flexible query with variables. Then, you'll discover how to model and develop an interactive Excel based analysis with design items in Bex Analyzer. Finally, you'll learn how to design the workbook with Bex Styles. By the end of this course, you'll know the important reporting tools of SAP Business Warehouse in all necessary details and be ready to develop nice and flexible Excel based analytical applications that your users will love.

About the author
About the author

Laszlo is an official certified SAP BW/BI consultant and trainer with over 10 years of IT experience. He specializes in SAP Business Warehouse/Business Intelligence but also enthusiastic about other solutions like ABAP, C# and new software practices.

More from the author
SAP Business Warehouse: The Big Picture
Beginner
1h 22m
Oct 12, 2015
More courses by Laszlo Meszaros
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hi everyone. My name is Laszlo Meszaros, and welcome to my course, Becoming an SAP Business Warehouse Query Expert. I am an SAP Business Warehouse developer at Expertise Team. SAP Business Warehouse is SAP's enterprise data warehouse product, and it's used by thousands of companies. In this course you are going to learn how to develop a complex, but flexible sales tactical analysis in Excel with Query Designer and with Bex Analyzer. Some of the major topics that we will cover include, conditional formatting with exceptions, and creating top lists with conditions in the query designer, creating a flexible query with variables, modeling and developing an interactive Excel based analysis with design items in Bex Analyzer, designing the workbook with Bex Styles. By the end of this course you will know the important reporting tools of SAP Business Warehouse, and all necessary details, and be ready to develop nice and flexible Excel based analytical applications that your users will love. Before beginning this course you should be familiar with the basics of SAP Business Warehouse and query design. I hope you will join me on this journey to learn SAP Business Warehouse with the Becoming an SAP Business Warehouse Query Expert course at Pluralsight.

Adding a Popup Screen with Variables
Hi. This is Laszlo Meszaros from Pluralsight. Welcome to the module about Adding a Pop-up Screen with a Variable. SAP Business Warehouse is a flexible tool. That's why it is so popular, and queries wouldn't be flexible enough without the variables. A query with predefined selections can give a result only for this selection, but with the variables we can toggle around in our database. We can try out different selections, and still we can use the same query. In this module I will be showing you the possible scenarios to make a query flexible with the variables, but before that, let's take a look at our roadmap. In the previous module we discussed that exceptions and conditions are important tools when we want to prioritize the information, and the variables are the tools of flexibility, and the flexibility is our current topic. I will be explaining the factors that might drive you to a rigid query structure, and what kind of problems you might face. After watching this module you will understand how variables can help. I will also drive you through how you can create different types of variables. During the demos we will be changing our queries. The result, we will be a flexible query system that your users will like. First, let's start with the introduction.

Placing Design Items
Hi. This is Laszlo Meszaros from Pluralsight. Welcome to the module about Placing Design Items into BW Workbooks. Let's check what we accomplished in our roadmap. We added different types of variables and so made our query flexible. With this step, we finished the development of the queries. We have finished two queries. Now it's time to create a BW workbook in Excel. One of our queries should show a table, the other one will be a data source of a chart. In this module I will be showing you how to assign out queries as a workbook data source. You will understand how to use them in different user interface elements, like in a table, in a chart, or even in a checkbox for filtering. The topic of this module is about the user interface elements or, in other words, about the design items. What are these design items, what is a BW workbook, and what is their connection to our queries? This is what I want to answer now.