Posts

SAP BW Reporting: Everything You Want to Know

Business intelligence tools are intended to support users in understanding the enterprise performance and to help users make appropriate decisions based on their understanding. One critical aspect here that the user should note is the need to give all users an equal insight into the enterprise—an insight based on consistent data and standard analytical definitions. For consistent enterprise control, a unified view of information for all users is indispensable. On the one hand, this is achieved by the SAP Business Information Warehouse (SAP BW) functionality for extraction and data warehousing via a consistent data basis. Conversely, queries can provide a unified and flexible analysis platform according to the Single Point of Truth concept. This means that within an enterprise, a piece of information (or a dataset) exists once as a reference and cannot be falsified by locally changed variants. Essentially, a query is a database research action with interesting additional functionality like currency scenarios, complex calculation options, and analysis functions.

In this e-book (116 pages) you will find in-depth notes about SAP BW Reporting tools. See the covered content below:

  • Reporting Agent
  • SAP BI 7.0 Reporting Tools
  • Business Explorer (BEx Browser, BEx Query Designer, BEx Map)
  • Query Designer
  • BEx Web Application Designer
  • Chart Designer
  • Web Analyzer
  • Ad-Hoc Query Designer

Read more →

/0 Comments/by

SAP Query Tutorial for Beginners

SAP Query is SAP’s tool to define and execute once own reports without knowing ABAP programming language. In this document following key topics to explore SAP Query are covered in detail:

  • What is SAP Query? Purpose and Advantages of SAP Query?
  • Configuration for SAP Query
  • Create transaction for SAP-Query
  • Creating Ad Hoc query (HCM related infoset query)
  • Developing SAP Query for Task List Data Extraction
  • Transport of SAP Query objects
  • Setting the Expiry date in SAP Query
  • SAP Query for getting hourly background job status
  • Building an SAP Query using ABAP Code
  • Development of Basic List Query using SAP Query
  • Working with infosets/User Groups/Query in detail

Read more →

/0 Comments/by

SAP Business Intelligence Reporting Guides

This article contain guidelines step by processes for

  • How to create a basic ad hoc query in BEx Query Designer using the Financials InfoCube
  • How to modify an existing ad hoc query and add features to the basic query
  • How to add Confidential InfoObjects and Security Variables to the ad hoc query

Read more →

/0 Comments/by

BEx Ad Hoc Query Fundamentals

BEx Ad Hoc Query Fundamentals provides key terms and concepts BI Power Users need to understand prior to creating an ad hoc query in BEx Query Designer.

BEx Ad Hoc Query Fundamentals are organized in multiple sections.  Each section will build on the concepts covered in previous Fundamentals topics:

  • BEx Ad Hoc Query Fundamentals – Part I: Provides an overview of basic key terms and concepts BI Power Users need to understand prior to creating a basic ad hoc query in BEx Query Designer. This section covers key terms and concepts of Key Figures, Dimensions, Characteristics, Free Characteristics, Attributes and Filters
  • BEx Ad Hoc Query Fundamentals – Part II: Builds on the key terms and concepts covered in BEx Ad Hoc Query Fundamentals – Part I. This section covers key terms and concepts of Key Figure Properties, Restricted Key Figures, Caharacteristic Properties and Variables
  • BEx Ad Hoc Query Fundamentals – Part III: Builds on the key terms and concepts covered in BEx Ad Hoc Query Fundamentals – Part I and Part II. This section covers key terms and concepts of Compound Characteristics, Hierarchy Characteristics, Hierarchy Characteristic Properties, Hierarchy Variables, Basic Formulas, Ad Hoc Query Dates, Key Date

Read more →

/0 Comments/by