Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 213 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
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
I need Item_Number with Item_Class and Item_Category in my BIP report
User_IQZBR
Rank 2 - Community Beginner
I need Item_Number with Item_Class and Item_Category in my BIP report,
How can I join EGP_SYSTEM_ITEMS_B table with EGP_ITEM_CLASSES table and EGP_ITEM_CATEGORIES_TABLE ?
Tagged:
0
Best Answer
-
@User_IQZBR - Please refer the below documentation for table details and it's primary keys which can be used to join to achieve your requirement.
Please post this question in OTBI community for better responses as the query is related to Fusion application tables.
0
Answers
-
Hello @User_IQZBR,
Is this requirement at the Fusion BIP report end or FDI OAC integrated BIP report end?
Thanks and Regards
Ashish
0 -
Fusion BIP report
0
