Changing the size multiselect text box

We had multiselect where the users would pick the week which is in the format FY2009-Q3-MAR-W3. The multiselect are size of 10. So in the textbox complete string couldn't be seen, as in image.

The user wanted to see the complete string of one selected string. OBIEE didn't have any options of increasing the width. As a round about this is what I did.
1. I copied the promptviewtemplates.xml from {OracleBI}\web\msgdb\messages to {OracleBIData}\web\msgdb\customMessages folder.
2. I searched for the below tag in the above copied the xml file.

3. Changed the size value to size="16".
4. Restarted the presentation services.
The sizes of the prompts were changed as below.

Alter the GrandTotal caption

Though this seems silly, but we did loose 10 minutes of our time trying to figure out where it is done.

1. Go to edit mode of the pivot table.
2. In the properties of rows click on "Format Labels"

3. In the heading put in whatever label is needed.

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

Disabling "Create Bookmark Link"

In OBIEE "Create Bookmark Link" is enabled by default.In order to disable this, we need to make the below entry in instance config.xml file.

<Dashboard>
<EnableBookmarkURL>false</EnableBookmarkURL>
</Dashboard>