Ability to use attributes with BLOB data type in DV — Oracle Analytics

Oracle Analytics Cloud and Server Idea Lab

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Ability to use attributes with BLOB data type in DV

Needs Votes
41
Views
1
Comments

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

2
2 votes

Needs Votes · Last Updated

Comments

  • BalaGuddeti-Oracle
    BalaGuddeti-Oracle Rank 5 - Community Champion

    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