Mindmajix

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

Screenshot_39

The BEx Query contains the following characteristics in the Rows:

  • Calendar Year
  • Region

The BEx Query contains the following characteristics in the Free Characteristics:

  • Country
  • Sales Organization
  • Sold to Party
  • Product Category
  • Product Group
  • Product
  • Calendar Year / Month
  • Distribution Channel
  • Division
  • Sales Group.

In addition the BEx query is using the following Key Figures:

  • Net Value
  • Open Order Quantity
  • Product Costs
  • Transport Costs
  • Rebates

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

0 Responses on BEx Queries for Activities in SAP BO Analysis"

Leave a Message

Your email address will not be published. Required fields are marked *

Copy Rights Reserved © Mindmajix.com All rights reserved. Disclaimer.
Course Adviser

Fill your details, course adviser will reach you.