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