Oracle Transactional Business Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Transactional Business Intelligence

Categories

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

Display photographs in OAC Analysis

41
Views
2
Comments
SaurabhJaiswal-Oracle
SaurabhJaiswal-Oracle Rank 5 - Community Champion
in Oracle Transactional Business Intelligence

Summary

Display photographs in OAC Analysis

Content

Facing a strange issue in OAC while displaying photos.

Customer is capturing photographs of readings.  These photos are being stored as a BLOB in ATP.  Customer is looking for a report with all the transactions and the corresponding photographs in a report.  We can see the data in OAC Analysis, but strangely only a part of the photograph is visible in the report.

As per Oracle Support this feature is not supported.  Is there any workaround that can be implement?  Is there a possibility that we convert the BLOB to some other datatype?

Any suggestions?

Tagged:

Comments

  • Amish Srivastava-140475
    Amish Srivastava-140475 Rank 1 - Community Starter

    Hi Saurabh,

    can you please let me know how you have loaded images into ATP.

     

    Regards

    Amish

  • Nathan CCC
    Nathan CCC Rank 7 - Analytics Coach

    Hi,

    1. "As per Oracle Support this feature is not supported"

    Please reference the thing you reference here. As per what support? Are you getting this from a certification matrix? Which sheet, tab, row, cell? Or an artilce we can read on support.oracle.com? Which feature exactly? If you can see the data in an analysis then you are selecting from a presentation table and column in a metadata repository database (RPD)? Did you build the RPD? How is the BLOB mapped to the physical layer?

    2. What version of OBI are you using?

    This question is not about the usual technology on this forum. You state "OAC Analysis". So you have built an analysis using "Classic" home using menu "New" "Analysis" in legacy Oracle Business Intelligence (OBI) in Oracle Analytics Cloud (OAC)? With some sort of data source query a binary large object (BLOB) from autonomous transaction processing (ATP) database. The reason I ask is that is a different version of OBI from the much much older Oracle Business Intelligence (OBI) 11.1.1.9.0 product in Oracle Transactional Business Intelligence (OTBI) in Oralce Cloud Applications such as Financials, Procurement, Projects etc. which is traditionally the topic of this forum. This forum is for Software as a service (SaaS). Other than Analytics for Applications OAC is not SaaS but PaaS. Maybe you should post on that forum for OAC? https://cloudcustomerconnect.oracle.com/resources/0591c7239f/summary