Can we report on the columns and subject areas used in an OTBI report?

Dawn Cawston - CPS

Summary:

As 22d is removing the Workforce Learning - Learning Management Real Time subject area, I wondered if there was a report that could tell us which of our reports uses this subject area and the columns contained therein to enable easier replication?

Content (required):

Report on columns and subject areas

Version (include the version you are using, if applicable):

22c soon to be 22d

Code Snippet (add any code snippets that support your topic, if applicable):

RichardChan

Yes you can if you have access to the S_NQ_ACCT table in the BIPLATFORM schema

Amrita Gupta-Oracle

I don't think it's possible in OTBI.

Dawn Cawston - CPS

HI both

Thank you for your responses.

I don't have access to the table you mention Richard, but I appreciate the thought.

Kind regards

Dawn

RichardChan

Ask to have the Usage Statistics added into the repository as a new subject area you can then use answers to generate your report

Dawn Cawston - CPS

Hi Richard,

Thank you for the suggestion as it does have the SA name in it.

I am sure it will help.

Dawn

Gaurav Bharadwaj-Oracle

@Dawn Cawston - CPS

Please review this :

https://www.linkedin.com/pulse/oracle-cloud-applications-otbi-usage-performance-ranganathan/?trk=read_related_article-card_title