Tuesday, August 9, 2011

Dynamically Re-sizing Charts

The bar size of the chart cannot be dynamically resized however the charge axis can be zoom in or zoom out on the basis of lower and upper limits of the result set. For that purpose go to axis scaling and select “Zoom to Data Range”.

Default Axis :

Zoom to Data Ranges: 

Cheers ;)

Friday, August 5, 2011

Increase Max Dropdown Value in Prompts

Here are the instructions to increase the 256 limit of the dropdown in propmts;

1. Edit instanceconfig.xml
2. Add <Prompts><MaxDropDownValues>1000</MaxDropDownValues></Prompts>

3. Save the instanceconfig.xml
4. Restart Presentation Service

Cheers ;)

Thursday, August 4, 2011

Pivot Tables & CUBE Limits

Cube Limit for Pivot Table can be increased following steps:

1. Stop the services: IIS Service admin, Oracle BI Server, Oracle Presentation Server, Oracle BI Scheduler, Oracle BI Java Host.

2. Check the syntax in the Instanceconfig.xml, it should be:

<MaxCells> 4000000 </MaxCells>
<MaxVisibleColumns> 5000 </MaxVisibleColumns>
<MaxVisiblePages> 2500 </MaxVisiblePages>
<MaxVisibleRows> 75000 </MaxVisibleRows>
<MaxVisibleSections> 3000 </MaxVisibleSections>
<CubeMaxRecords> 1000000 </CubeMaxRecords>
<CubeMaxPopulatedCells> 1000000 </CubeMaxPopulatedCells>

Restart the Services, if still not works try step 3.

3. Creating the registry variables:
a) Start > Run > regedit
b) Go to HKEY_LOCAL_MACHINE > ORACLE >Business Intelligence
c) Create 2 new string values : CubeMaxRecords with value 150000 and other CubeMaxPopulatedCells with value 160000.
d) Similarly create the same 2 string parameters at the location : HKEY_LOCAL_MACHINE > Siebel Systems, Inc. > Siebel Analytics > Web > 7.7
(If the location mentioned above is not present create it)

4. Start the services.

Cheers ;)