Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
OTBI - Subject Area Overview & Standard KPI Calculation Guidelines
Hello everyone,
I wanted to ask if there is a way to generate a list in BI Publisher (Cloud) that provides an overview of the available Subject Areas along with their respective fields. Alternatively, is there another method to display this information efficiently?
Additionally, I would like to know if there is a guideline or standard reference for KPI calculations, such as Headcount, FTE, #Absences, and others.
Looking forward to your insights.
Best regards,
Engin
Best Answers
-
I don't think there is a way to generate this list in BIP. But you can check the data lineage sheet available on below thread:
HCM OTBI subject areas to database lineage mapping spreadsheet — Cloud Customer Connect
Thanks.
1 -
Hi Engin,
OTBI SA Measures' definitions are not available for the recent releases but it was available previously for some prior releases. Please take a look into the following old documents but please note it will not contain any newly created measures or columns (or correct definition of measures if it got changed recently).
Oracle Transactional Business Intelligence Subject Area Documentation
Especially look at:
Data Lineage documents will provide you the source of the Subject Area columns but it will not provide the calculation logic of the measure column. Here are the Data Lineage docs:
Hope this help.
Cheers,
1
Answers
-
Thank you, that helps me alot.
0 -
Glad you found it useful.
Can you please accept the answer / answers that helped you, it'll be very helpful for fellow community members in future.
Thank You!
0