Oracle Analytics and AI

C_Blocklin

Summary

Need instructions for creating a dynamic logo within a BIP template

Content

We have many RTFs with dynamic logos on them, but we are now building a similar template using an Excel BIP template.  So, in our RTP - our alt-text field for the logo placeholder contains the following:

  url:{concat('${OA_MEDIA}','/',LOGO_PATH)}

Now, we need the same thing in the Excel template.  I followed the exact same steps and populated the alt text for the image with that same string, but it is still not pulling in any image onto the generated Excel document.  

Has anyone been able to make this work?

Version

5.6.3 (EBS 12.2.7)

Dir_Pal

Where are the images in the Excel?
* You need to set a couple of properties to allow use to access them and you need to be connected to the network to get the images.

 

Base image URI	html-image-baseuri	Base URI which is inserted into the src attribute of the image tag before the image file name. This works only when the image is embedded in the template.
Image file directory	html-image-dir	Enter the directory for XML Publisher to store the image files that are embedded in the template.

With standalone 10.1.3.4 the Excel output is actually MHTML where we can embed the images directly in the HTML file so you don’t need the properties set.

* In the “Web” Tab of the the image properties.
Paste an image in the template where you would like your image to be displayed in the output. Double click the image. In the “Web” Tab of the the image properties write this:

url:{concat(CP_IMAGE_LOC,’/’,’logo.gif’)}

where CP_IMAGE_LOC contains your unix directory path where my logo.gif file resides. CP_IMAGE_LOC is a placeholder in your rdf and hence is part of my XML output.
OR you can set the like this:

url:{‘${OA_MEDIA}/logo.gif’}

Our Excel is not true Excel and it has a limited set of functionality but for many users its enough just to get the data out into Excel.