Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 44 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 278 Oracle Analytics and AI News
- 56 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Extracting Configuration Options via OBIEE
Content
Hi All
I've been asked to try and export the configuration options of expenses (Setup and Maintenance > Manage Policies By Expense Category). Now, I can export the expenses into a report easily, but can't seem to grab the configuration options for each individual expense (not sure if it is even possible!). I've attached an image to show what I am trying to export (basically everything on the image, so Rate Definitions, Rate Determinants etc.) If it is possible, how would I go about doing this?
Comments
-
Hi,
If you are looking to write a BIP SQL Query to get the Information , then this info might help you.
Since all the Policies are categorized based on the Expense Category, there will be multiple tables based on categories.
One Such example would be EXM_ACCOM_POLICIES . By just doing a select * , you may not get all the information , but definitely a good starting point.
Here is a link to all the Expense Related Tables : http://docs.oracle.com/cloud/farel10/financialscs_gs/OEDMF/EXM_tables.htm#Expenses_tables
0