Oracle Communities

Oracle Analytics and AI

Child Item

Ability to use images as attributes in DV

Description

Ability to use attributes with BLOB data type in DV so that images can be used as part of analyses.

Use Case and Business Need

It will be really helpful for to build more sophisticated analyses that use images as part of their data such as User Profiles, Country Flags, People Analytics, etc.

More details

DV datasets and projects do not support BLOB data types at the moment.

Original Idea Number: dc89b3bddf

Find more posts tagged with

Data Modelling and Datasets

Analysis and Data Visualization

Data Preparation and Flows

Needs Votes

Status: Needs Votes

Comments

BalaGuddeti-Oracle

OAC is not designed for typical object display instead analyze and mash data. Hence OAC does not support BLOB data types such as BLOB, JSON, and XML

As a workaround you could try to use BI Publisher, which comes integrated with OAC, and does support CLOBs and BLOBs. These BIP Reports in turn can be used in the OAC Dash Board.

Note: The BLOB must be an image. When you execute the query in the Query Builder, the BLOB does not display in the Results pane; however, the query is constructed correctly when saved to the data model editor. BI Publisher does not support querying of BLOB columns in an Oracle BI EE data source. BI Publisher does not support querying of CLOB columns in an Oracle BI EE data source.

https://docs.oracle.com/middleware/12212/bip/BIPDM/GUID-F9F844BA-5831-46E5-B085-44D82258A9A9.htm#GUID-7F1DA8C3-2E42-428A-90A1-B48A917D02BB