Oracle Communities

Oracle Analytics and AI

Child Item

Embed BIP Report with URL on page (HTML) and have parameters

JimVT

Summary

Embed BIP Report with URL on page (HTML) and have parameters

Content

Hi,

I've embedded my BIP Report on the Purchase Requisitions page succesfully using an iframe and URL.

Now it is my intention to have it embedded without any BIP headers/options/controls/... So that's working fine.

However we introduced 1 parameter (Supplier Name) that the user should be able to choose.

Whatever I change to the link (I've played with the xmode and output formats), I don't get the desired outcome, which is:

A parameter which they can choose from a dropdown
The report output (a plain table)

Is this at all possible? Any way I try, it seems to include either the entire BI Publisher header/controls (but with the parameter) or just the plain table (no header/controls but also no parameter).

Any ideas?

Thanks.

Version

R13 20B

Find more posts tagged with

Reporting

Customizing Reports

Report Layouts

Report Output

Report Delivery

Comments

SantoshKumarBhairi

Did you try using _xmode=2 and create the parameter (Supplier Name) within your data-model? You can enable the results for 'Supplier Name' populate thru a SQL-query or thru a fixed list of values.

And with respect to output, open the report layout, click on 'View a list' and there you can choose an appropriate output format like CSV.

JimVT

Hi Santosh,

I did try with xmode = 2, there was no difference. When opening the report from BIP, the parameter is there, but not when it's embedded on a page.
The parameter exists in the data model (list of values behind it). This is all working fine from the BIP pages.
The output is supposed to be HTML. I want it to show a plain table on the page in the application.

See below the end of the Shopping page (Requisitions). This is where I inserted a 'HTML Markup' region and pasted the URL so the report is visible.

As you can see, there is no parameter, even when I used xmode=2.

Any solutions?

Any confirmation this is at all possible?

Nivya Mathire

Hi,

Did you get this fixed? I am also looking for an option to get the parameters from report.

Regards,

Nivya

JimVT

Hi Nivya,

Unfortunately no. We went ahead with the report being displayed without any parameters.

In this case we wanted a parameter for 'Supplier', but whatever we try, it is not displaying in the embedded BI report in the screen. The parameter is there when you open the report from the BI catalog.

Workaround would be to just use CTRL+F to search for the Supplier in the screen.

Let me know if your investigation bears any fruit. I would be very interested.

Thanks.

Jim

SantoshKumarBhairi

hi Jim,

Sorry I never checked this thread. I have done a similar one for OTBI report/dashboard and based on Person, the data will be displayed in the embedded report. I will try similar one for BIP and let you know if that works.

thanks,

Santosh

JimVT

Hi Santosh,

Do let me know if it works. I'm not having any luck.

Pritha

@JimVT Could you please tell me in detail how you have embedded bip report in redwood page which is having no parameter.

Thanks & Regards

Pritha

RVohra

@Pritha , Welcome to the Oracle Analytics Community! This post was last updated almost 5 years ago. Also, question about Redwood page has no relation with the original question. I believe it can be posted as a new post and provide as many details as possible, like Product, Version, any specific module/Redwood page etc.

Thanks

JimVT

https://community.oracle.com/products/oracleanalytics/discussion/comment/73554#Comment_73554

This wasn't on the new Redwood SSP pages. So can't help you.

RVohra

Thanks @JimVT for updating this post.

@Pritha , as suggested above, please start a new post with your questions. Thanks