Oracle Analytics Publisher

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

Unable to display dynamic URL images in OAS

Received Response
37
Views
1
Comments
User_UT31U
User_UT31U Rank 1 - Community Starter
edited Oct 13, 2025 1:55PM in Oracle Analytics Publisher

I have a customer who has raised an SR and I wonder if it can be answered here.

"We have a business requirement to generate a catalogue of items, dynamically generated based on a set of filter criteria.

We are assessing the possibility of using Analytics Publisher and dynamically display the product images based on MCS ITEM_IMAGE table address.

So far we were not able to display any image either dynamically or if we give an URL. We are only able to display static pictures inserted directly in the template.

Steps followed:

- Create a data model; data set to query MCS and generate a column FULL_PATH by concatenating IMAGE_ADDR||IMAGE_NAME based on ITEM_IMAGE. This will give an URL to the image

e.g., https://dlp-merida-merchadmin.emea.wdpr.customer_name.com/permalink/v1/1/20033/preview/207811020047.jpg?token=B81Grfn6Rq0lCSa4h8a1Fd7W913LTwx2JiYPBErPqTlTYvAqhstwncX9pSi1Y2Jd

(images are only accessible internally in the our environment but if we use any public image it doesn't work either).

- Create an rtf template with item attributes and the column FULL_PATH

- Next to the column FULL_PATH, insert a dummy image and change the Alt Text to url:{FULL_PATH}

- When we open the report, the image is not displayed. If we put the link directly, it still does not work. e.g.,  url:{https://dlp-merida-merchadmin.emea.wdpr.customer_name.com/permalink/v1/1/20033/preview/207811020047.jpg?token=B81Grfn6Rq0lCSa4h8a1Fd7W913LTwx2JiYPBErPqTlTYvAqhstwncX9pSi1Y2Jd}

We are following the documentation but it does not work.

Can you please let us know how to make it work? Is it related to some security configuration that prevents OAS from accessing URL's outside?"

Answers

  • RVohra
    RVohra Rank 6 - Analytics Lead

    Make sure that the image URL (e.g., https://server.com/images/item123.jpg) must be:

    • Publicly accessible OR
    • Accessible to the BI Publisher server
    • The image URL must end with a valid image file extension (.jpg, .png, etc.)

    Use following three steps to see if it works:

    1. SELECT ITEM_NAME, IMAGE_URL FROM MCS.ITEM_IMAGE
    2. (Assuming IMAGE_URL is the XML tag name from your data model.)
      • Insert a placeholder in a cell or frame where the image should go.
      • Right-click → Properties
      • url:{IMAGE_URL}
    3. Save and upload the RTF, and run the report.