BEx Queries for Activities in SAP BO Analysis
SAP NetWeaver Demo Model:
Before we are going to look into more details of SAP BusinessObjects Analysis, edition for OLAP, you should take a look at the information available on SCN for the SAP NetWeaver Demo Model:
- SAP NetWeaver Demo Model
- SAP NetWeaver Demo Model: BI Content
During the excercises in this book we will use the SAP NetWeaver Demo Model in SAP NetWeaver BW as the basis for the BEx queries and as the basis for our excercises.
BEx Queries for Activities:
For the next set of activities we will use a BEx Query based on the Multiprovider oD_NW_M01 of the SAP NetWeaver Demo Model.
BEx Query Designer diagram
The BEx Query contains the following characteristics in the Rows:
- Calendar Year
The BEx Query contains the following characteristics in the Free Characteristics:
- Sales Organization
- Sold to Party
- Product Category
- Product Group
- Calendar Year / Month
- Distribution Channel
- Sales Group.
In addition the BEx query is using the following Key Figures:
- Net Value
- Open Order Quantity
- Product Costs
- Transport Costs
For the first set of excercises we will use this BEx query.
Now that we have clarified, which InfoProviders and BEx queries we will use, we can start now in the next section with our first steps with SAP Businessobjects Analysis, edition for OLAP by establishing an OLAP connection to SAP NetWeaver BW.
Enroll for Instructor Led Live SAP BO Training