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