Oracle Analytics and AI

_vero_

Hello,

our goal is to create a BIP report publisher with different logos for our customers. We tried to include in our data model (created using logical queries) a BLOB variable that contains our images. In the data section we can see the BLOB variable, but when we try to open the BIP report we see an error, even if we didn't use the variable in the report. On the web, we found different videos that explain how to include dynamic images, but all of them use the rtf model, something we would like to avoid given the complexity of the model in its entirety.

As integration here one of the links that we followed: https://docs.oracle.com/en/cloud/paas/analytics-cloud/acpmr/create-publisher-layout-templates.html#ACPMR-GUID-EAAA117F-4B39-459C-97B5-1E2AE400E785

We tried also to include dynamic images using url, stored as a column in the database, but this is the error we find:

Is there a way to include dynamic images without the rtf model, only using the BIP template?

Thanks

Simonab-Oracle

Hi @August 7,

"Add BLOB Image"

You can add a Binary Large Object (BLOB) image in an RTF or XPT template. Usage of an RTF template is recommended for BLOB images.

To add a BLOB image in XPT layout:

1. Specify the data column type as Binary Large Object (BLOB).
2. Insert the image in the BLOB column, and then select the BLOB column data element to display as image.
   To add multiple BLOB data rows in tabular format, use Repeating Group. Include a Layout Grid to create a tabular format, and add the BLOB column in the Layout grid.
3. In the column preceding the BLOB image, type "data:image/jpeg;base64," along with the quotes.

For your reference, please review:
https://docs.oracle.com/en/cloud/saas/otbi/otbi-pub-design/images.html#GUID-4CD74376-46BF-43A6-8232-C145EE9B53B0

Thank you,

Simona