Categories
- All Categories
- 121 Oracle Analytics News
- 21 Oracle Analytics Videos
- 14.4K Oracle Analytics Forums
- 5.5K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 47 Oracle Analytics Trainings
- 7 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 8 Oracle Analytics Industry
- Find Partners
- For Partners
Can we report on the columns and subject areas used in an OTBI report?

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):
Answers
-
Yes you can if you have access to the S_NQ_ACCT table in the BIPLATFORM schema
0 -
I don't think it's possible in OTBI.
0 -
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
0 -
Ask to have the Usage Statistics added into the repository as a new subject area you can then use answers to generate your report
0 -
Hi Richard,
Thank you for the suggestion as it does have the SA name in it.
I am sure it will help.
Dawn
0 -