HTML TAG TO HIDE OBIEE REPORT EXPORT IN CSV FORMAT

Place the below HTML in Text Box of OBIEE dashboard page to disable exporting reports in Csv Format

<meta name="viewport" content="width=device-width, initial-scale=1.0">
<style>
a.NQWMenuItemWIconMixin:last-child {    display: none !important;}
</style>

GO URL IN BI PUBLISHER

Below is the GO URL Syntax in BI Publisher

http://example.com:7001/xmlpserver/Samples/Salary+Report.xdo?_xpt=0&_xdo=%2FSamples%2FSalary%20Report.xdo&_xmode=4&dept=10&_xt=Simple&_xf=html

This URL runs the report "Salary Report" located under Shared Folders/Samples. Note the following:

_xpt=0 renders the document in the report viewer

_xdo=%2FSamples%2FSalary%20Report.xdo defines the report path

_xmode=4 renders the document only

dept=10 sets the report-specific parameter "dept" to "10"

_xt=Simple uses the layout called "Simple"

_xf=html sets the output format to html

Specifying Parameters in the URL

The preceding examples render the complete report inside the BI Publisher report viewer with all the report controls. The default layout, default output format, and default parameters are used to render the report. You can add parameters to the URL to specify how the report renders.

When constructing the URL, note the following standard URL syntax:

? - denotes the first parameter

& - denotes each additional parameter

The following table describes more parameters you can add to the URL.

Parameter	Definition	Example Usage
_xpt	Specifies whether to render the report in the BI Publisher report viewer or export the document to a new window appropriate for the output type. For example, if the output type specified is html, the report document (only) will render in a browser window; if the output type is PDF you will be prompted to save or open the PDF document. When this parameter is not specified, the report renders in the BI Publisher report viewer. Valid values are: ■ 0 - renders the report in the BI Publisher report viewer ■ 1- exports the document to appropriate application window	_xpt=0
_xdo	(Optional) Provides the path to the report.	_xdo=%2FSamples%2FSalary+Report.xdo
_xt	Specifies the layout to use. Enter the name of the layout as defined in the report definition. If an invalid name is entered, the default layout is used.	_xt=Manager+Summary
_xf	Specifies the output format. If no value is specified, the default output format is used. If an invalid value is specified, or, if a value is specified that is not enabled for the layout, the report does not render. Valid values are: ■ analyze - use for Interactive output ■ rtf ■ docx ■ pdf ■ html ■ pptx - use for PowerPoint 2007 ■ ppt - use for PowerPoint ■ xml - use for Data ■ excel - use for Excel ■ excel2000 - use for Excel 2000 ■ xslx - use for Excel 2007 ■ csv	_xf=pdf
report parameters as named in the data model	Specify name-value pairs for the parameters specific to the report. You must use the parameter name as defined in the data model.	dept=10
_xmode	Specifies the report viewer mode. If not specified, defaults to view in the full report viewer. Valid values are: ■ 0 - view in the full report viewer. ■ 1 - hide BI Publisher banner, hide parameters, can change layout, other actions: export only. ■ 2 - hide BI Publisher banner. (No Header) ■ 3 - hide BI Publisher banner, hide parameters (No Parameters) ■ 4 - report document only: hide BI Publisher banner, hide parameters, hide other actions, hide layouts. (Document Only)	_xmode=1

Eg:

-------

{HOST}/xmlpserver/FIN_GL%20Reports/Test/CI_GLR_Monthly%20Summary%20of%20Ledger%20Data%20for%20Accounts%20by%20Cost%20Center_MTH/CI_GLR_Monthly%20Summary%20of%20Ledger%20Data%20for%20Accounts%20by%20Cost%20Center_MTH.xdo?_xpt=0&_xdo=/FIN_GL%20Reports/Test/CI_GLR_Monthly%20Summary%20of%20Ledger%20Data%20for%20Accounts%20by%20Cost%20Center_MTH/CI_GLR_Monthly%20Summary%20of%20Ledger%20Data%20for%20Accounts%20by%20Cost%20Center_MTH.xdo&_xmode=0?HOST={HOST}&COST_CENTER_CD={COST_CENTER_CD}&ACCOUNT_CD={ACCOUNT_CD}&PERIOD_NAM={PERIOD}&_xt=Simple&_xf=html

http://example.com:7001/xmlpserver/Samples/Salary+Report.xdo?

_xpt=0

&_xdo=%2FSamples%2FSalary%20Report.xdo

&_xmode=0

&dept=10

&_xt=Simple&_xf=html

_xpt=0 renders the document in the report viewer

_xdo=%2FSamples%2FSalary%20Report.xdo defines the report path

_xmode=0 view in the full report viewer.

dept=10 sets the report-specific parameter "dept" to "10"

_xt=Simple uses the layout called "Simple"

_xf=html sets the output format to html

http://example.com:9704/xmlpserver/FIN_GL+Reports/Test/CI_GLR_Monthly Summary of Ledger Data for Accounts by Cost Center_MTH/CI_GLR_Monthly+Summary+of+Ledger+Data+for+Accounts+by+Cost+Center_MTH.xdo?

_xpt=0

&_xdo=%2FCI_GLR_Monthly%20Summary%20of%20Ledger%20Data%20for%20Accounts%20by%20Cost%20Center_MTH.xdo

&_xmode=0

&ACCOUNT_CD={ACCOUNT_CD}

&PERIOD_NAM={PERIOD_NAM}

&COST_CENTER_CD={COST_CENTER_CD}

{HOST}

&_xt=Simple&_xf=html

FULL TEXT CATALOG SEARCH IN OBIEE

The full-text catalog search provides a mechanism for searching for objects in the Oracle BI Presentation Catalog that is similar to a full-text search engine. This full-text search provides more advanced options than the basic catalog search that Presentation Services provides, as described in the following list:

• Basic Catalog Search — Users can search for an object by its exact name, which is similar to using a Find dialog in many products.
  
• Full-text Catalog Search — Users can search for objects by various attributes, such as name, description, author, and the names and values of columns of data that the object references. Users obtain search results that correspond to the objects that they have access to open.
  

Below are the useful urls for Full Text Catalog Search in OBIEE

http://docs.oracle.com/cd/E25054_01/bi.1111/e10541/prescatadmin.htm#CACHJIEG

http://bidirect.blogspot.com/2013/12/obiee-11g-full-text-catalog-search-for.html