Organization Name
POSTMEDIA NETWORK INC. (CA)
Description
Please, make available the same features existing in OBIEE on-premise for an OAC instance that uses on-premise Oracle Database with RDG.
Features:
- Usage Tracking. As implemented on the usual BI_PLATFORM schema (tables S_NQ_ACCT, S_NQ_ACCT, S_ETL_DAY, S_ETL_TIME_DAY, etc)
- Scheduled Agent data. As implemented on tabels S_NQ_JOB, S_NQ_INSTANCE, S_NQ_ERR_MSG, S_NQ_JOB_PARAM, etc
===================
Business impact:
Missing these tables affects the quality of Support, Audit, Monitoring and Maintenance tasks.
The provided functionality as of 2020-04-24 does not cover th ementioned needs.
e.g.: automate a report with all the agents that have failed in the last 7 days, including its error message; send it every morning at 9:00 AM from Monday to Friday, to members of the Support team.
e.g.: produce a XREF report of all the Agents that deliver content for a given analysis.
e.g. produce a XREF report of all agents created by a given user.
(etc)
Use Case and Business Need
Use Case #1: automate a report with all the agents that have failed in the last 7 days, including its error message; send it every morning at 9:00 AM from Monday to Friday, to members of the Support team.
Use Case #2: produce a XREF report of all the Agents that deliver content for a given analysis.
Use Case #3: produce a XREF report of all agents created by a given user.
Use Case #4: perform Impact Analysis
Business Need #1: need to know which agents have failed in the last 4 days, and their error messages.
Business Need #2: audit and monitor what dashboards and analyses are used by a given user.
Business Need #3: Obtain ranking information of usage of specific dashboards/analyses
Business Need #4: Analyze what dashboards analyses have nto been used in more than n months. Monitor if those objects can be deprecated.
More details
See OBIEE 11g / 12 documentation about tables:
S_NQ_JOB,
S_NQ_INSTANCE,
S_NQ_ERR_MSG,
S_NQ_JOB_PARAM,
S_NQ_ACCT
S_ETL_DAY
S_ETL_TIME_DAY
Original Idea Number: dba7f5af98
