real time loading status of Data Targets in BW

[shashank_dalvi]

Which are the tables in BW which gives real time loading status (Successfull,UnSucessful,Ongoing) of Data Target (Cube,DSO) ?

I need this information to create BI Dashboard.

Thank you !!

[Former Member]

Check RSBKDTP table.

Regards,

Dilip.

[KodandaPani_KV]

Hi,

check the RSBKDTP table -> select the active version only -> execute it

check the these filed

RSBKDTPNM

RSOBJVERS

RSBKDTP_I

RSBKSRCNM

RSBKSRCTP

RSBKSRCTLOGO

RSBKTGTNM

RSBKTGTTP

down laod the dump to excel sheet.

now sort the RSBKTGTNM, RSBKTGTTP fields - it will say where are loading to target.

Thanks,

Phani.

[shashank_dalvi]

Hi Phani,

Thanks for your reply.

In the above table is there any field which gives QMStatus(red,yellow or green) of the Cube or DSO or a flag which tells us if the request was successfully posted to data target or not.

Thank you in adavance !!

[shashank_dalvi]

Is there a ABAP program available which would give Data Load Status in BI 7 ?