table associated with ODS that gives number of records added

[Former Member]

Hi Friends,

I am looking for a db table that has information similar to that in the 'Request' tab of ODS Manage. Most importantly I am looking for the number of records added for a given request.

Thank you for your inputs

Deepthi

[kumar_gudiseva2]

Additional info on table RSMONICTAB:It does not store those requests that transfer 0 records.

In case, you want to track these requests too, you are better off using table RSREQICODS.

Kumar Gudiseva.

[former_member188975]

Hi Deepthi,

You can look at table RSMONICTAB.

Hope this helps...

[Former Member]

Hi Deepthi,

Refer the RSMONFACT table with the ODS's technical name. The field REQ_INSERT_SUM would give the no. of records added. The field IC_ID would take both cube and ODS name.

Bye

Dinesh