OBIEE 11g Client installation - Installer UI Mode Error on Windows 8

OBIEE 11.1.1.7 client failed to install on Windows 8 X64 machine,
Got the below error while installing

To fix the issue, we need to install 32 bit client on Windows 8 X64 bit machine.

Open Command Prompt as "Run As Administrator"
Navigate to the client exe file location and run the client file as below

biee_111170_32_client_install -i GUI

FETCH FIRST 65001 ROWS ONLY OBIEE 11g

By default OBIEE Analysis returns 65000 records for a report, it can be updated as per your business requirement. Here is the steps to be followed

1. Log into Enterprise Manager (EM)
2. Click on "Business Intelligence"
3. Click on "coreapplication" ->   "Capacity Management" Tab -> "Performance" tab
4. Modify the value "Maximum Number of Rows Processed when Rendering a Table View"
    Lock and edit configuration
    Enter Value as per requirement.
5. Restart Presentation services.

OBIEE 11G - Overwrite maximum number of records in Analysis

In OBIEE 11g maximum number of records to be shown in a reports can be restricted from enterprise manager(em) click here for details, However if someone needs to overwrite the maximum number of records in a report then it can be achieved by adding 

"FETCH FIRST 50000 ROWS ONLY" in the Prefix section Under "Advanced' tab of analysis and Click on "Apply SQL"

*50000 being the custom value, as per the requirement.