topic Re: BW report in Application Development and Automation Discussions

BW report

naveen_inuganti2 — Fri, 06 Jun 2008 04:45:51 GMT

Hi Experts....

Please try to under stand my problem..

I have to devolop one report, but that is with BW tables...

here i hav to fetch no.of actions for pertoculer employee...that i hav to display for each month...

like...

jan feb mar april may june july

100 123 121 123 432 756 129

these 100, 123 .... are no. of actions... for one perticuler emlpoyee...

in technical view...

no.of actions F1 from T1 table,

employee code F2 from T2 table,

month F3 from T3 table,

all these are BW tables...

There is no links for those tables.. with i received initially..of corse iam not found...

So can i devolop this with logic... or Is it mandatory to find links...

my cuurent stage...

finally i got succeed to find links for F1, F2 and F1, F3... so there is no link for F2 and F3...

But here i have to fetch data of F1 for F2 wrt F3....

how can logic...???

and finally...

Suggest me a good way to solve this problem....

Thanks,

Naveen.I

Former Member — Fri, 06 Jun 2008 04:53:10 GMT

Hi Naveen,

First fetch data from table F3 then write FOR ALL ENTRIES to table F1 and then write FOR ALL ENTRIES for F2 table.

Join F1 and F3 and get the data and then write FOR ALL ENTRIES to table F2

Best regards,

raam

Edited by: Kodandarami Reddy.S on Jun 6, 2008 10:25 AM

Former Member — Fri, 06 Jun 2008 05:08:36 GMT

First fetch data from table F1 then write FOR ALL ENTRIES to table F2 this is first internal table .(link F1 and F2 common field)

using F1 then write FOR ALL ENTRIES to table F3 this is second internal table .(link F1 and F3 common field)

then loop first internal table ,under loop u need to read the second internal table with key find common entries move to final internal table

now in ur final internal table contain all F1 ,F2,F3 records