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
How to create lookups through Fusion BI
Summary
We have a requirement to create lookups but we dont have access from UI.Is there any way that we can achieve this task through BI/OTBI.
Answers
-
You can only create logical lookups in BI/OTBI thru CASE statement or using select 'x' form dual, etc.
And if you are going to require those lookups to transact further, they must be created in the Fusion UI using dff setup.
0 -
Hi,
You can't create the lookups using BI like on-prem systems. The only option other than UI is to use web services. However, currently there is no REST API support to create lookups. So, the only option is to use SOAP services.
Please check below links to use webservices for lookup creation:
https://community.oracle.com/mosc/discussion/4054229/webservice-for-valueset-lookupThanks.
0 -
Hi Mandeep,
Thank you so much for the reply. This looks helpful .
Thanks and Regards,
Sankeerthana
0 -
Thank you for the reply. I will check on this.
Thanks and Regards,
Sankeerthana
0
