Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 17 Oracle Analytics Lounge
- 218 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 81 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
OAC Analytics usage tracking - Data is inserted to ADW Tables when ran workbooks and reports
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
Answers
-
@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)1 -
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
0 -
@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.
0 -
@Sambasivarao Manam - Did you create the tables manually?
0 -
@Sumanth V -Oracle Yes , created tables Manually
0 -
@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 :0 -
@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.
1 -
I will check and get back , currently could not do make changes on classic RPD model as Business users are doing preprod validation.
0 -
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.
1 -
Sumanth V -Oracle will do and keep posted updates
1
