Before you start building a query, it is important to have a clear understanding of the user requirements. For instance, Bungee Software executives primarily request sales revenue and gross profit data, grouped by organization, product, customer, and sales employee. Thus, the relevant characteristics are Sales Organization, Distribution Channel, Division, Material, Material Group, Customer, and Sales Employee. The relevant key figures are Sales Revenue and Gross Profit. Users can include key figures and characteristics in one or more queries | Chapter 9 Creating Queries Contents Creating and Saving a New Defining a Filter in a Creating Restricted Key Creating a New Formula Percentage Change Creating a Calculated Key Working with BW Queries Additional In this chapter you will learn how to Create and save a new query Define filters in a query Create restricted key figures and calculated key figures in a query Create new formulas in a query Work with drilldown currency conversion charts and other BW query functions Report Development Tools 9-1 Chapter 9 Creating Queries Overview Overview In chapter 8 you learned how to Build a workbook template Insert an existing query into a workbook Save a workbook to the InfoCatalog Queries define the structure of a workbook in the Business Explorer BEx Analyzer. In the previous chapter you learned how to insert Bungee Software s Sales Analysis query into a workbook. With the help of a guided tour you will now learn how to create the same query. During the query building process you will learn how to define filters create restricted key figures and create calculated key figures. Later in the chapter we cover additional features and functions to help you work with BW queries. You are here Before Getting Started Before you start building a query it is important to have a clear understanding of the user requirements. For instance Bungee Software executives primarily request sales revenue and gross profit data grouped by organization product customer and sales employee. Thus the relevant characteristics are Sales Organization Distribution Channel Division Material Material Group Customer and Sales Employee. The relevant key figures are Sales Revenue and Gross Profit. Users can include key figures and characteristics in one or more queries. 9-2 Reporting Made Easy Chapter 9 Creating Queries Creating and Saving a New Query In this example we separate the sales revenue and the .
