cancel
Showing results for 
Search instead for 
Did you mean: 

Reg: Writing Conditions in Datasource

Former Member
0 Kudos

hi all,

I am very new to BI. i have two SAP tables RSPPEDIR and RSCOMPDIR and i have to select entries with the required condition and put it in a DSO/cube.

How can i do it..what are the process needed? please help me

Accepted Solutions (0)

Answers (3)

Answers (3)

former_member210253
Contributor
0 Kudos

Hi Jeny,

Mentioned tables will have query details, what was the req to take that and put them in DSO/CUBE.

U can write an ABAP program to fetch the data and insert  into the DSO.

Logic:

Select all the required fields  from the tables and put into internal  table.

insert them in the DSO/Cube.

Select F1 F2 F3

from RSRREPDIR

into Itab

where(Condition).

INSERT /bic/aDSO(Active table)

       FROM TABLE Itab..

Hope it will help.

Regards,

Babu.

KodandaPani_KV
Active Contributor
0 Kudos

Hi jeny,

Welcome to SCN.

first get the requirement then design the model.

According to business logic you can write at start routine or end routine.

based on performance you can write at end routine level.

Thanks,

Phani.

Former Member
0 Kudos

Hi,

Before populating data into the DSO/Cube, you can write your custom code in

1.Start routine

2.End routine

3.Transformation rule