OBIEE11g: All the Column Values are not shown in Prompts drop down for Check Box, Radio Buttons and List Box

Scenario:

We have created a column prompt on a column which has about 450 values. When we click on the Prompt Drop down all the column values are not displayed in the prompt when we are using Check Box or Radio Buttons or List Box the same prompt is displaying all the values when we select the check boxes option. The prompt shows first 256 values only, there is no option to see or select the values other than these 256.
  

Solution:

1. Please make a backup copy of the instanceconfig.xml located in <INSTANCE_HOME>/config/OracleBIPresentationServicesComponent/coreapplication_obips1 folder.

2. Add or modify the following tag <MaxDefaultValues> into instanceconfig.xml and set a proper value (in the below example, it is set to 1000).
Also check the <MaxDropDownValues> value.

<Prompts>
<MaxDefaultValues>1000</MaxDefaultValues>
<MaxScrollValues>100</MaxScrollValues>
<MaxDropDownValues>10000</MaxDropDownValues>
</Prompts>

3. Restart Presentation Services.

OBIEE 11g: Issue with Excel 2007 Export - Merging Columns,Adding Extra Columns,Extra Blank Spaces, Cell Size Changes When Exporting to Excel 2007+

Scenario:

When you try to export a report in Excel 2007 or Excel 2007+ format, the report data and layout is not properly exported. We see difference when you compare the exported report with the report on the dashboard. Some of the formatting issues you will find are

1) Merged Columns
2) Cell format like large cell size
3) Some extra blank spaces
4) Extra columns which are not showing on the dashboard.

Root Cause:

This is a bug in 11.1.1.7 and later versions.

Solution:

We can fix this issue by making a small change to the config file xdo.cfg. Please follow the below steps to know how to make the changes.
 

1. Take a back up copy of <Middleware_Home>/instances/instance1/config/OracleBIJavaHostComponent/coreapplication_obijh1/xdo.cfg
   
2. Open xdo.cfg for editing.
   
3. Add the following: 
   
   <config version="1.0.0" xmlns="
     http://xmlns.oracle.com/oxp/config/">
         <properties>
          <property name="xlsx-keep-values-in-same-column">true</property>
         </properties>
     </config>
4.  Save your changes.
   
5. Restart all OBIEE Services (OPMN Services).

OBIEE 11g : Exporting Dashboard Page to Excel Error:"Excel found unreadable content in" FILE_NAME.xlsx. "Do you want to recover the contents of this workbook?"

Scenario:

When you try to export a dashboard page or entire dashboard from "Page Options" on a dashboard to excel 2007 or excel 2003 you can get the excel file with out any error, but when you try to open the exported excel file then you will get an error message related to unreadable content. The same happens when you create an agent to deliver the dashboard page. 

  Root Cause:

This issue may be caused when Dashboard Page name is using special characters that are not acceptable for Excel Sheet Name.
For example

 =

\
 /
 *
 ?
 :
 [
 ]  

& 

;

 Resolution:

Rename the dashboard page and avoid the special characters. Now export it to excel and test. You can see the excel file opening with out any errors and data will be shown as per the dashboard page.

OBIEE11g:PRINT TO PRINTABLE PDF ON THE DASHBOARD FAILS WITH ERROR CODES: ETI2U8FA

 

Scenario:

We are trying to Print a report which has around 1900 records from the dashboard using the option Printable PDF the process fails with below error message 

"An error occurred during execution of ""send"". Broken pipe [Socket:8]
Error Details
Location: saw.rpc.variablemos.write, sawfopProxy,saw.subsystem.portal.pdf 

Error Codes: ETI2U8FA"

When i try to pint a small report which has 150 records it processed printing successfully to PDF

 When i am doing the research on this error, i found that this error is most common with exporting PDF and Printing PDF. Especially when we try to export large Dashboards and Large reports.Printing reports with a smaller number of rows works successfully and No issues in exporting the same to CSV or Excel.This issue can be fixed by modifying the Java host Config file.

Please follow the steps as mentioned below.

Update the <obiee_home>\instances\instance1\config\OracleBIJavaHostComponent\coreapplication_obijh1\config.xml file with:

<MessageProcessor>
     <SocketTimeout>300000</SocketTimeout>
</MessageProcessor>

Along with:

 <XMLP>

<InputStreamLimitInKB>0</InputStreamLimitInKB>
<ReadRequestBeforeProcessing>true</ReadRequestBeforeProcessing>
</XMLP>

 

Note: After modifying the Config.xml file we should restart OPMN Services.