cancel
Showing results for 
Search instead for 
Did you mean: 

Creation of OLAP Variable for Master data

Former Member
0 Kudos
171

Dear BW Experts,

How to Create OLAP Variable for Master data in SAP BW? What is the use of OLAP Variable?

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

The entry column Type (Variable) on the Select Data tabpage indicates a variable time frame in which the data should be requested. The variables are not replaced by concrete values until a request is made. There are eight options:

Variable Data request Description

0

Yesterday

(12am – 12am)

1

Last week

(Monday-Sunday)

2

Last month

(1. (First day - last day of previous month)

3

Last quarter

(1. (First day - last day of previous quarter)

4

Last year

(01. (January 1 – Dec 31 of previous year)

5

User time selection

See below

6

ABAP routines

See below

7

<b>OLAP variables</b>

See below

<b>Time selections with the help of the variables 0 to 4.</b>

The variables 0-4 only refer to date fields of the data type DATS.

<b>User time selection</b>

Type 5 gives you a free selection of all fields.

If you select this variable for a field, confirm the selection, and then choose Detail for Type, an additional dialog box appears. In this dialog box you can freely limit the values of the fields and determine the next period value and the number of periods until a repetition.

Variables are placeholders for values and are not replaced by concrete values until a data request is made. You can also use a Variable for selections when requesting data for an InfoObject, if you choose type 7, confirm the selection, and then choose Detail for Type.

Former Member
0 Kudos

Hi Krishna Mohan Reddy

when you create a variable on bex it is a olap variable.. its my understanding ,all the variables u create in Bex is for characteristics, i mean master data only

just remenber, you can creating variable on characteristic ex Material.. which is master data only

Hope it is usefull help for you.

Thanks

Bhima Chandra Sekhar G