Bungee Software, Inc. develops and markets games for personal computers. Best-selling titles such as Portal Kombat, Barrio Brothers, and Kung Fu Grandma have helped Bungee Software become a leading supplier of computer games. However, the company is currently facing increased competition from Pixialated, Inc. To protect its market share, Bungee Software has formed a task force to explore ways to streamline its sales processes. The company has discovered that collecting and disseminating sales data to executives consumes considerable time and resources. The task force believes that easier access to sales and profit analysis information would save time and help executives with salesplanning activities | Chapter 8 Creating Workbooks Contents Before Getting Creating a Workbook An Step 1 Starting the BEx Step 2 Creating a Workbook Step 3 Saving the Template to the Step 4 Inserting Queries into the Step 5 Adding Visual Basic Functionality to Step 6 Saving the Workbook to the In this chapter you will learn How to create a workbook template using the BEx Analyzer How to insert a query or queries into a workbook How to save a workbook template to the InfoCatalog How to add pushbuttons and textboxes to a workbook template using simple Visual Basic commands Report Development Tools 8-1 Chapter 8 Creating Workbooks Overview Overview Chapter 7 presented an overview of BW s architecture concepts and terminology. In this chapter you will learn how to use the Business Information Warehouse to create workbooks or reports . As shown in the graphic below creating a workbook in the BW is essentially a five-step process You are here To help you get started with the Business Information Warehouse we have organized the material as follows Chapter 8 Creating Workbooks Chapter 9 Creating Queries Chapter 10 Working with the BEx Browser Chapter 11 Special Topics including tips tricks In this chapter you will be working with the BEx Analyzer and Microsoft Excel. With the help of a business scenario see next page we will show you three guided tours Creating a workbook template Inserting an existing query into a workbook Using Visual Basic to add workbook functionality 8-2 Reporting Made Easy Chapter 8 Creating Workbooks Before Getting Started In chapter 9 you will learn how to work with queries. In chapter 10 you will see how to access workbooks through the BEx Browser. Before Getting Started Before you start building workbooks it is useful to understand the following What is the business scenario see below What does the finished workbook look like see .
