Oracle Analytics Cloud and Server

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

Unable to display Image on BIP report saved as blob in database

Received Response
416
Views
15
Comments
Rank 5 - Community Champion

Hi

Previously We were working in oracle 11g forms and reports, we were displaying Company's Logo (blob image in database) and there was report in report builder to show as image.

Now we are planning to convert our reports into OBIEE 12c (BIP --- XDO), When try to show blob data on BIP report then instead of Image raw data is displaying (we are not using any word template etc.).

anyone please help

Report Print Screen.jpg

Welcome!

It looks like you're new here. Sign in or register to get started.
«1

Answers

  • Rank 8 - Analytics Strategist

    You might want to give this a look ->

    Blog : How to Use Blob Datatype Files Within OBIEE 12c

  • Rank 5 - Community Champion

    Hi Robert

    This blog is for the Images on analysis through RPD but in my case I want to use Images on BIP XDO reports through Data Model (generated from SQL query).

    this blog does not fullfil my requirement

    regards

  • Rank 8 - Analytics Strategist

    Sorry - I missed the BIP part, have you seen this ->

    https://blogs.oracle.com/xmlpublisher/inserting-blobs-into-your-report

  • Rank 8 - Analytics Strategist
  • Rank 5 - Community Champion

    This blog is helpful but If you please guide me little more

    After reading these blogs, I am assuming that template is necessary for BIP reports, am I right?

    in my case I am not using any word/ pdf template, just created data model and then created report

  • Rank 3 - Community Apprentice

    Hello,

    I faced the same issue, cause i wanted to show an image in the BIP report (not with word/pdf template).

    I was not able to achieve it.

    Workaround i´ve made for my personal solution was to access a public url with the desired image and place it in the report.

    Regards,

    Carlos

  • Rank 5 - Community Champion

    This solution can be implemented for the static images such as logo etc. but this solution is not feasible when we are dispalying some patient related images such Pulmonary images or gastro images.

    So what is recommendation for this scenario

  • Rank 8 - Analytics Strategist

    Hi,

    I am a big believer in the right tool for the right job, and whilst BIP does claim to be pixel perfect etc I am fairly sure Oracle did not envision or design it such that it would be fit for purpose to be used for an image archive accessing solution, and particularly as you are talking medical images I would be very cautious about attempting this with the wrong tool.

    Better would be to include URL links to whatever is specifically designed for purpose for accessing the medical images in question.

    Given the nature of the information security must also be a major consideration.

  • Rank 5 - Community Champion

    @Robert Angel

    I have achieved this problem by designing the RTF template as BIP built-in Layout Editor template type (XPT) does not support this feature directly but when upload template (OBIEE 12c; New --> Style sheet --> upload) then template uploaded succesfully but not visible for report creation.

    If you can help me I shall be greatful

  • Rank 8 - Analytics Strategist

    Seriously - I saw your hospital is oncology, if this were me I would not want to display images via your BI solution, I would want to ensure that only specialist medical imaging technology was used with highest resolution and zoom in facilities - this is a matter of life and death - and for my sins I too worked in health for over ten years....

Welcome!

It looks like you're new here. Sign in or register to get started.