Wednesday, November 16, 2011

Sort Issue when MultiSelect has more that 256 items.

There is a issue with OBIEE version 10.1.3.4.1 were if the multiselect has more than 256 items and the user clicks "more" on the prompt it will not sort all of the items. There is a patch to fix the issue it is:

9787610 - MULTISELECT PROMPT NOT SORTING PROPERLY WHEN CONTAINS MORE THAN 256 ITEMS

Wednesday, November 9, 2011

OBIEE 11g Import Metadata Shortcut

If you have ever had to import schemas/tables with the BI Administration tool in OBIEE 10g then you know that it can be a pain having to know or get the login/password to an account to import it. Well in OBIEE 11.1.1.5 you can simply click on the connection pool that has access to the tables you want to import and use that connection pool instead of the game of hunting down the 'keeper' of all passwords like in OBIEE 10g. Just click on the connection pool and click import metadata....nice feature.

OBIEE 11g Log and Config File Locations?

Here is a great Oracle Doc to aid you in the  above question...
'What are all the logs and configuration files for OBIEE 11G and where to find them? (Doc ID 1275087.1)'

Load testing OBIEE 11g

User wanted to load test OBIEE 11.1.1.5, that was fine as I had already setup the config files for 10g no problem right? Well it seems that one of the main config that is used especially if using Loadrunner for load testing is to add the <NewCursorWaitSeconds> tags so the testing tool won't see the clock refreshes in OBIEE and think the report finished. In 10.1..3.4.1 the config tags in the instanceconfig.xml are:
<NewCursorWaitSeconds>3000</NewCursorWaitSeconds> 
within the <ServerInstance> </ServerInstance>tags 
in OBIEE 11.1.1.5 it is as follows:
<Cursors>
<NewCursorWaitSeconds>3000</NewCursorWaitSeconds>
</Cursors>
within the <ServerInstance> </ServerInstance>tags.

 

OBIEE 11g Security Bug

Installed OBIEE 11.1.1.5 on Windows 2003 R2 x64; setup AD LDAP via Oracle doc ID: 1273961.1 after setting up web catalog security via application roles had issue were one time user would got security that allowed them access to the items the next time they logged in they didn't have access. Checked the users "My Account" both times the same roles were assigned. Hmm...put in SR with Oracle found out there is a bug that caused this. Was given Patch 12393459 and it fixed the issue.