nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Ability to use attributes with BLOB data type in DV

Neeti Choksi-Oracle

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 the analyses that use images as part of their data such as User Profiles, Country Flags, etc.

More details

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

Original Idea Number: f05941a9dd

Find more posts tagged with

Reporting

Data Modelling and Datasets

Analysis and Data Visualization

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