SAP BusinessObjects OLAP Connect Tutorial Guide

This guide describes BusinessObjects OLAP Connect, a data provider that lets BusinessObjects users access Microsoft SQL Server OLAP Services (MS OLAP Services) and SAP Business Information Warehouse (SAP BW) multidimensional servers.

Contents of this SAP BusinessObjects OLAP Connect Tutorial Guide
Chapter 1 Introducing BusinessObjects OLAP Connect 17
What You can Do with BusinessObjects OLAP Connect . . . . . . . 19
How BusinessObjects Integrates with BusinessObjects OLAP Connect . . . 20
Accessing MS OLAP Services or SAP BW . 25
Chapter 2 Getting Started 27
Connecting to the Data Source . . 29
Defining the Data for a Report . . . 41
Changing the Report Data Source 72
Changing the Report Login . . . . . 75
Changing the Display of the List of Values in InfoView 79
Setting the Connection Strategy . 80
Getting Information About the Report Data . 82
Saving a Report Definition . . . . . . 84
Formatting the Report . 85
Refreshing the Report . 86
Including Different Queries in One Report . . 87
Chapter 3 Fine-Tuning Your Data Selection 89
Adding and Removing Dimension Members 91
Nesting . . . . 97
Using Filters to Focus Your Analysis . . . . . 100
Sorts and Ranks . . . . 114
Attributes . . 125
Chapter 4 Performing Time Series Analysis 131
Performing Periods to Date Analysis . . . . . 133
Editing a Time Series 139
Performing Opening Period Analysis . . . . 140
Performing Closing Period Analysis . . . . . 142
Performing Parallel Period Analysis . . . . . 143
Performing Last Period Analysis 146
Combining Time Series . . . . . . . 148
Chapter 5 Working with OLAP Calculations 149
Creating Calculated Members . . 151
Common Business Calculations 153
Using Common Business Calculations with Dimensions . . . . . 158
Business Statistics . . 160
Distinct Counts and Basket Analysis . . . . . 164
Custom Calculations . 170
Editing and Deleting Calculations . . . . . . . 173
Calculation of Values . 174
Standard BusinessObjects Calculations . . 175
Chapter 6 Creating an Interactive Document 177
Filter Prompts . . . . . . . 179
SAP Variables . . . . . . 192
Drill . . . . . . . 200
Formatting the Report 207
Distributing the Document . . . . . 208

View the original article here