Normally BI Publisher report Prompts will not be displayed in dashboard when we pull BI Publisher report into Dashboard section. It only displays the Report document without any prompts as shown in below.
In order to show these prompts we have 2 ways
1.Using BIP Report URL
2.Drag and drop BIP report (some configuration need to be done to make this work)
We can use Dashboard link object or else Iframe html code to invoke bi publisher report along with prompts in Dashboards
Example IFrame code to call BI Publisher Report
<html>
<head>
<title>Call BIP Report IFrame </title>
</head>
<body>
<iframe src="BIP_Url" height=500px width=600px></iframe>
</body>
</html>
BIP_Url can be taken from BI Publisher Report ->Show Report url with No Header option.
Place that code in Dashboard Text object and check for Contains HTML Markup option
We have to do some configuration changes in instanceconfig.xml to make this work.
Navigate to below location to find instanceconfig.xml file <Middleware_Home>/instances/instance1/config/OracleBIPresentationServicesComponent/coreapplication_obips1
modify instanceconfig.xml of BI Presentation Services and add the ReportingToolbarMode element in the AdvancedReporting section. For example:
<ServerInstance>
<AdvancedReporting>
<ReportingToolbarMode>6</ReportingToolbarMode>
</AdvancedReporting>
</ServerInstance>
Note:
The following list describes the ReportingToolbarMode element values:
1 = Does not display the toolbar.
2 = Displays the URL to the report without the logo, toolbar, tabs, or navigation path.
3 = Displays the URL to the report without the header or any parameter selections. Controls such as Template Selection, View, Export, and Send are still available.
4 = Displays the URL to the report only. No other page information or options are displayed.
6 = Displays the BI Publisher toolbar to display the parameter prompts of the BI Publisher report
Restart OPMN services to reflect this change.
Now login OBIEE and add Bi Publisher report to a section. Now we can observe BI Publisher Report along with its prompts as shown in below.
In order to show these prompts we have 2 ways
1.Using BIP Report URL
2.Drag and drop BIP report (some configuration need to be done to make this work)
1. Using BIP Report URL
We can use Dashboard link object or else Iframe html code to invoke bi publisher report along with prompts in Dashboards
Example IFrame code to call BI Publisher Report
<html>
<head>
<title>Call BIP Report IFrame </title>
</head>
<body>
<iframe src="BIP_Url" height=500px width=600px></iframe>
</body>
</html>
BIP_Url can be taken from BI Publisher Report ->Show Report url with No Header option.
Place that code in Dashboard Text object and check for Contains HTML Markup option
2. Drag and drop BI Publisher Report in Dashboard section
We have to do some configuration changes in instanceconfig.xml to make this work.
Navigate to below location to find instanceconfig.xml file <Middleware_Home>/instances/instance1/config/OracleBIPresentationServicesComponent/coreapplication_obips1
modify instanceconfig.xml of BI Presentation Services and add the ReportingToolbarMode element in the AdvancedReporting section. For example:
<ServerInstance>
<AdvancedReporting>
<ReportingToolbarMode>6</ReportingToolbarMode>
</AdvancedReporting>
</ServerInstance>
Note:
The following list describes the ReportingToolbarMode element values:
1 = Does not display the toolbar.
2 = Displays the URL to the report without the logo, toolbar, tabs, or navigation path.
3 = Displays the URL to the report without the header or any parameter selections. Controls such as Template Selection, View, Export, and Send are still available.
4 = Displays the URL to the report only. No other page information or options are displayed.
6 = Displays the BI Publisher toolbar to display the parameter prompts of the BI Publisher report
Restart OPMN services to reflect this change.
Now login OBIEE and add Bi Publisher report to a section. Now we can observe BI Publisher Report along with its prompts as shown in below.
No comments:
Post a Comment