Data Retraction from SAP BW(Through BEx Query) into SAP ECC system

Data Retraction is the process of extracting data from BW and loading it to ECC system. This is very useful for planning data, generally we will create planning data by using BPC or some planning functions.This functionality is useful to make the data synchronize between ECC and BW and compare with real time data.

The below document explains step by step to procedure on how to do this.

Retraction through Bex Query (BW) into ECC

Exception aggregation in query designer in SAP BI

This explains about the exception aggregation in propeties of key figures(Basic, CKF and RKF) with some example data. documents includes step by step information.

Exception Aggregation in Business Explorer

Key figures aggregation in query designer

When we create calculated key figures in query designer or for basic key figures, in properties tab we will find aggregations tab.

This document explains about the options available in aggregation tab and how to use them.

Aggregation of Key Figures

Understand the BEx Query Designer in SAP BI - Part 6

This document will explain about the below functionalties in BEx Query Designer.

1) Creation of simple query with realtime example with step by step screenshots.

Understanding BEx Query Designer: Part-6 Simple Query Design

Understand the BEx Query Designer in SAP BI - Part 5

This document will explain about the below functionalties in BEx Query Designer.

1) Properties of Characteristics

2) Properties of Key Figures

3) Properties of Query.

Understanding BEx Query Designer: Part-5 Query Element Properties

Understand the BEx Query Designer in SAP BI - Part 4

This document will explain about the below functionalties in BEx Query Designer.

1) Conditions

2) Exceptions.

Understanding BEx Query Designer: Part-4 Conditions & Exceptions

Understand the BEx Query Designer in SAP BI - Part 3

This document will explain about the below functionalties in BEx Query Designer.

1) Restricted Key Figure

2) Calculated Key Figure.

Understanding BEx Query Designer: Part-3 Calculated Key Figures and restricted Key Figures 

Understand the BEx Query Designer in SAP BI - Part 2

This document will explain about the below functionalties in BEx Query Designer.

1) Structures

2) Selections

3) Formulas.

Understanding BEx Query Designer: Part-2 Structures, Selections and Formulas

Understand the BEx Query Designer in SAP BI - Part 1

This documnet will explain about the basics of Query designer. This is the first document which will explain the below things.

1) advantages of Query designer.

2) screen appearance of Query Designer.

3) Different sections in query designer.

4) Toll bar options in query designer.

Understanding BEx Query Designer: Part-1 Screen Appearance

How to restrict users with Query Access

The below document will explain the procedure to restrict the users with query access.


query access based on users

How to search for queries by certain elements

Some times, we will get situation where we need to find out the query name based on some elements in the query.

the below document will help you to do this.

How to search for queries by certain elements