Blog

  • Home
  • SAP BO
  • BEX Queries For Activities In SAP BO Analysis

BEX Queries For Activities In SAP BO Analysis

  • (4.0)
  • | 2692 Ratings

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

BEx Query Designer

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.

Frequently asked SAP BO Interview Questions


Ravindra Savaram
About The Author

Ravindra Savaram is a Content Lead at Mindmajix.com. His passion lies in writing articles on the most popular IT platforms including Machine learning, DevOps, Data Science, Artificial Intelligence, RPA, Deep Learning, and so on. You can stay up to date on all these technologies by following him on LinkedIn and Twitter.


DMCA.com Protection Status
Close
Close