Wednesday, March 18, 2009

Customizing the Download Links

We have a report where we set the values of the Session Variables using presentation variables in the Prefix section of the report.
And we use presentation variables in the columns of our report.
All the download options work except "Download to Data".

We get the error:
Odbc driver returned an error (SQLExecDirectW).
Error Details
Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 27002] Near <@>: Syntax error [nQSError: 26012] . (HY000)
SQL Issued: Set Variable Position_Name='@{PositionChange}', Position_Level = @{LevelChange}; SELECT INDEXCOL( 0, ISP."Position"."Territory Name", ...............

We decided to hide the “Download to Data” link.

By default for every OBIEE report will have Download to Excel / PowerPoint / Excel 2000 / Data and MHTML.

To achieve our requirement:

1. We got the viewscontrolmessages.xml file from {OracleBI}\web\msgdb\messages folder.
2. copied it to {OracleBIData}\web\msgdb\customMessages
3. Found the below tags under idDownloadLinksMenu@{viewID}

4. Remove the approriate line from <a> to </a>.
To remove the Download to Data remove the 4th line. So code looks like:

5. Restart the saw

No comments:

Post a Comment