Skip to Content
0
Former Member
Dec 07, 2006 at 11:38 AM

Combining Masterdata and Transactional data and display in Report

204 Views

Hai All,

I am new to BW. I am not getting how to combine my Master data with Transactional data and to display in the report. Actuall my scinario is

I have one ODS which contain 2 cols ( this is Master)

Roll no Student Name

1 A

2 B

3 C

4 D

My transactional data contains

Roll no Sub1 Sub2 Test No

1 10 20 1

2 20 30 1

3 40 50 1

4 60 70 1

I want a report which is having the fields -- > Roll no Student Name Sub1 Sub2

For this what i ahve to do ?

Please send the solution with the steps.

Regards

Prashanth