This content has been marked as final. Show 6 replies
OK I found the problem.
I have been advised by a BI Publisher guru that the following article in My Oracle Support, "BI Publisher 11g Can the Guest User Be Enabled With a Catalog Repository? [ID 1269481.1] which states the following:
*Guest user cannot be used with a Catalog Repository.*
*Guest Access is only available when using a file based Repository.*
A file system repository is only valid for BI Publisher installed standalone (without OBIEE), so no you cannot simply change the repositry unless you do not want to use BIP and OBIEE together, in which case it makes more sense to have a separate isntall of BIP.
As for other methods to call BI Publsiher, Web Services are the best method available to call BIP from an external application.
Edited by: zooid on May 4, 2012 11:44 PM
Edited by: zooid on May 4, 2012 11:45 PM
Try this blog
Hi Gus C,
That is the same blog I mentioned my original post, but thank you none the less.
The problem I have unfortunately does not have a simple solution. i.e. I can only really address my setup by using web service and I do not have the time at this point to go that this path. However it is something which i will need to address the moment I have the time. In the mean time authentication against BIP is the only real possibility.
The answer for non file based BI Publisher repository is web-service.
I might have missed a specific requirement for having to define and store your report in BI Publisher directly, but in most cases, it is recommended to store your report definition as well as your report layout / template in APEX instead. The method of integrating APEX with BI Publisher was developed specifically so that you won't have to re-authenticate. The way this works is that APEX executes your query, generated an XML file for your data and sends this off the BI Publisher, along with your template, and BI Publisher simply turns this into PDF, without actually having to access the database.
To get started, go to your APEX app, Shared Components, and create a report query there. Then take the XML or XML Schema export from your report query, load this into the BI Publisher Word Plug-In, design your template, save the template as an RTF file, load this into APEX as a report layout, associate the layout with your report query and then hook up the report query in your APEX app.
Thank you for your help. I have tried your sample as per your blog http://marcsewtz.blogspot.com.es/2012/02/dynamic-images-in-pdf-what-32k-limit.html but have found that the moment I place the blog images into a repeat group I get errors. I am not sure what I am doing wrong but it must be something very simple as it works perfectly when I do not use a repeat group with images.
Once I have the time I will revisit your sample prior to going down the path of the web-service as I am somewhat scared of the potential issues to be addressed with the web service.