How to retrieve Request ID in Data Package from BPC Infocube using ABAP

[former_member692102]

Based on the screenshot below, I would like to get the Request ID of the transaction data (like how we do it in TCODE: Listcube) in ABAP for use in a custom program. You can refer below screenshot of the Dimension and Request ID I want.

Currently I am using cl_uja_bpc_admin_factory=>get_application_manager() and cl_ujo_query_factory=>get_query_adapter()->run_rsdri_query() to attempt to the request ID but the Data Package dimension is not listed as a dimension.

Kindly requesting help from all BPC experts!

[ThorstenHoefer]

If you want to read the content of a cube, you can use FM RSDRI_INFOPROV_READ

[former_member692102]

Unfortunately I attempted this FM and it somehow did not work with BPC cubes, and will return sy-subrc = 11, without a proper exception. I tried debugging and the logic will somehow skip the FM and not allow me to debug the code within the FM causing this error.

[former_member186338]

czynjay

It's better to show your code sample!

[former_member186338]

Why not to use data audit log for it?

[former_member692102]

Hi Vadim,

Because I need to compare the TIME in the transaction data vs the data loading time. I believe you cannot extract the transaction data of a BPC cube from the audit log.

[former_member186338]

czynjay

Sorry, but have you tested?

[former_member186338]

BPC methods will not show request info. You have to use BW methods...

But what is the idea behind getting request ID?

[former_member692102]

The idea behind it is to have a custom ALV report that contains transaction data in addition to the Request ID. The contents of the report are records where the TIME dimension (period) does not match with the program execution time.

Can you kindly give examples of BW methods to get Request ID in my case?