Freeze Frames in OBI 11.1.1.6.x

Finally we have the "freeze pane" option that many users have asked for for years.......Below is the changes needed in instanceconfig.xml:

<Views>

<GridViews>

<DefaultScrollingEnabled>true</DefaultScrollingEnabled>
<DefaultRowFetchSlicesCount>500</DefaultRowFetchSlicesCount>
<DefaultColumnFetchSlicesCount>50</DefaultColumnFetchSlicesCount>
<DefaultFreezeHeadersClientRowBlockSize>40</DefaultFreezeHeadersClientRowBlockSize>
<DefaultFreezeHeadersClientColumnBlockSize>30</DefaultFreezeHeadersClientColumnBlockSize>
</GridViews>
</Views>

Details on what each item means:


DefaultScrollingEnabled - Turns on or off scrolling for all pivot or table views.
DefaultRowFetchSlicesCount - Set the "up to" how many rows to fetch server side for determining the scrollbar height for freeze headers.
DefaultColumnFetchSlicesCount -  Set the "up to" how many columns to fetch server side for determining the scrollbar (across) width for freeze headers.
DefaultFreezeHeadersClientRowBlockSize - Sets how many rows to fetch in one block for freeze headers.
DefaultFreezeHeadersClientColumnBlockSize - Sets how many columns to fetch in one block for freeze headers.

There is a post on OTN with the same:

https://forums.oracle.com/forums/thread.jspa?threadID=2395998&tstart=165

Case Insensitivity in OBIEE 11g prompts

Had a request to turn on the case insensitive searching in OBIEE 11g today here is how you do it:

1. Add the following entry in instanceconfig.xml: located at

\<MW Home>\instances\<yourinstancename>\config\OracleBIPresentationServicesComponent\coreapplication_obips1
<QueryManager>
<CaseInsensitiveMode>true</CaseInsensitiveMode>
</QueryManager>

Save Instanceconfig.xml file.

2. Open the NQSConfig.ini located in \<MW Home>\instances\<yourinstancename>\config\OracleBIServerComponent\coreapplication_obis1 and search for CASE_SENSITIVE_CHARACTER_COMPARISON and change this values to OFF as shown below.
CASE_SENSITIVE_CHARACTER_COMPARISON = OFF;
Save NQSconfig.ini file.

3. Restart All OBIEE services.
4.Verify setting has taken affect.

NQSConfig.ini Error "EVALUATE_SUPPORT_LEVEL "

Working on OBIEE 11.1.1.6.1 today and got the following error on a dashboard "[nQSError: 43113] Message returned from OBIS. EVALUATE_SUPPORT_LEVEL inside NQSConfig.INI is not set to support EVALUATE. (HY000)" What in the world? So I go do a search in the NQSConfig.ini and Wow! Where did this config addition come from:


# EVALUATE_SUPPORT_LEVEL:
# 1: evaluate is supported for users with manageRepositories permssion
# 2: evaluate is supported for any user.
# other: evaluate is not supported if the value is anything else.

EVALUATE_SUPPORT_LEVEL = 0;

Changed setting to = "2" and all is fine, now off to figure out where that came from and what it is doing in the NQSConfig now..

* Just as a note this setting came in with 10.1.3.4.2....Guess I never had the issue with SampleApp...ugh.