Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 17 Oracle Analytics Lounge
- 218 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 81 Oracle Analytics Trainings
- 15 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
Create JSON output format in BI Publisher
Luis Gustavo
Rank 2 - Community Beginner
We have a request to raise a BIP report using JSON output.
We needed to build a complex report query to get JSON layout, but when business user runs this report, everytime they have challenges to convert it to JSON output.
The output option JSON should be available in BIP similar to eText and XML.
1
Comments
-
any udpate please?
0 -
try this..
SELECT JSON_OBJECT ('SupplierNumber' VALUE ps.segment1,
'VendorType' VALUE ps.vendor_type_lookup_CodeFORMAT JSON) sample_output
FROM poz_suppliers ps0