Categories
- All Categories
- 75 Oracle Analytics News
- 7 Oracle Analytics Videos
- 14K Oracle Analytics Forums
- 5.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 40 Oracle Analytics Trainings
- 59 Oracle Analytics Data Visualizations
- 2 Oracle Analytics Data Visualizations Challenge
- 3 Oracle Analytics Career
- 4 Oracle Analytics Industry
- 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_tables0