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
List of joins between ERP Tables
Organization Name
Western Digital
Description
User can provide a set of tables as input to a UI.
The return from the UI should be list of tables and join conditions that should be used, to use the provided list of tables successfully without cross joins, and with right set of joins.
Use Case and Business Need
To create a new BIPublisher report with any two or more ERP Tables.
We don't know the right set of joins to use.
We don't know the right set of intermediate tables and the right set of joins that can be used along with these intermediate tables.
Oracle has to provide an UI, where user will provide a list of tables.
Then this UI has to return the list of joins conditions to be used, along with intermediate tables and joins if any.
And also on the right hand side, the UI can display the Unique, Surrogate and Primary Key of all the tables involved in the joins.
More details
This will help on all the joins in the ERP modules.
Oracle users can say that they are using the right joins in the ERP tables.
There are multiple ways in which the joins can be achieved, but the oracle recommended approach in an UI will add a high value addition as a trust on the data retrieval approach.
Original Idea Number: 3ede74126a