OAC Analytics usage tracking - Data is inserted to ADW Tables when ran workbooks and reports

Sambasivarao Manam

HI All,

I have configured usage tracking settings on console usage Tracking section Maximum rows 100,000, Logging table ,Int block ,connection pool,Query logging table and created separate Database object on RPD . however when running reports those information are not capturing backend configured tables.

I followed below knowledge articles .

https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=570471880421167&id=2783268.1&_afrWindowMode=0&_adf.ctrl-state=nez3twenz_4

https://www.youtube.com/watch?v=Sy9F7ozC3VI

Sumanth V -Oracle

@Sambasivarao Manam - Please refer the video embedded in this article and review the setting and troubleshooting use cases mentioned in it and see if it helps resolving your issue.

Configure And Troubleshoot Usage Tracking Data Issues In OAC [Video Content] (Doc ID 2812776.1)

GayathriAnand-Oracle

Hi

Do the usage tracking tables get created fine? Is issue only with data not getting inserted?

If the tables are not getting craeted, validate the connection pool info provided in system settings. Make sure the database user used has proper privileges to create/insert data.

Did you modify anything in the RPD connection pool? All of you have to do this create connection pool in RPD and refer that in the system settings along with table names you wish to use. Do not modify rpd beyond this.

Test to see if data gets inserted fine and once this is verified then you can go ahead and import metadata and configure BMM and subject area (these steps are needed only if you wish to create reports off UT).

Thanks

gayathri

Sambasivarao Manam

@GayathriAnand-Oracle. I have created usage tracking tables and able to import meta data of those tables in RPD also configured tables and connection pool details on console. only challenge is to see ran reports data into tables that means not inserting stats in tables.

Sumanth V -Oracle

@Sambasivarao Manam - Did you create the tables manually?

Sambasivarao Manam

@Sumanth V -Oracle Yes , created tables Manually

Sumanth V -Oracle

@Sambasivarao Manam - You don't need to in OAC. Create a schema and provide it's details in OAC DV console, once you click on apply it automatically creates the tables for you within that schema.
Reference : https://docs.oracle.com/en/cloud/paas/analytics-cloud/acabi/track-usage.html#GUID-6EC1AD7D-D904-4D90-A21C-295B1984B3CD

GayathriAnand-Oracle

@Sambasivarao Manam Follow exact steps that is documented. You should not be creating usage tracking tables manually. Just create connection pool and let the system do the rest. If you still face issue, post all the steps you did, without this we cannot assist you meaningfully.

Sambasivarao Manam

I will check and get back , currently could not do make changes on classic RPD model as Business users are doing preprod validation.

Sumanth V -Oracle

Sure @Sambasivarao Manam. You can drop the tables created within the schema and complete the usage tracking configuration in OAC DV console and validate if tables are created successfully in Database. Once verified you can do the RPD changes once you get the down time.

Sambasivarao Manam

Sumanth V -Oracle will do and keep posted updates