BPC Embedded report journal

[michele_medaglia5]

Hi Bpc Friends

I was asked to create a report in AfO to show the journals.

Could you please give me some tips how to implement the flow from the BW tables?

Thanks

Michele

[harsha_jalakam · Accepted solution]

Hi Michele,

Can you confirm on the version of BPC you are using.

For BPC Embedded on BW 751 and earlier,the journal data is available in /BIC/ + application prefix + DT. Where application is available from the table RSBPCA_APPL. For this you may have to create ODS view on top of the journal table and then build a query on top it.

For BPC Embedded on BW 752 and later , the journal data is available directly on aDSO where the journal aDSO can be found in UJJ_P_JRNL_ADSO.

Regards,
Harsha

[michele_medaglia5 · Accepted solution]

thanks Harsha

My version is BPC 10.1 on BW on HANA and the BW version is the below:

SAP_BW750 0016 SAPK-75016INSAPBW SAP Business Warehouse

[harsha_jalakam · Accepted solution]

Ok thank you, then for version, journal data are stored on tables /BIC/ + application prefix + DT, Where application prefix is can be seen in RSBPCA_APPL table. As I said earlier to create AFO on top of this table, you may to create ODS view and then build a query.