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.
 

OBIEE -BI Content Server is down, after creation of Windows services

Content server went down after creating windows services and it never starts. To fix the issue we need add a new environment variable in windows.

BI_ORACLE_HOME=<path_to_middleware>\ORACLE_BI1