Tuesday, August 9, 2011

OBIEE Catalog for large organisations part 1

Organisations tend to grow… The chance that an organisation of 50 persons will be 4000 in the next 5 years is small but it’s there. The chance that 3.500 persons will become 4.000 can be called reasonable.

Plan your catalog for growth! This needs to be done from the moment you start with OBIEE. If you think that the number of users of the system will become more then 4.000 in the next 5 years (debatable the typical live span of a BI system), you need to tell the system know! The magical number 4.000 is caused by (inherited) limitations of disk file systems.

First bring down the presentation server (if it’s up…):

image

EM > Business Intelligence > coreapplication > capacity management > Availiabilty

Next open the instanceconfig.xml in a text editor (<<BI_HOME>>\instances\instance1\config\OracleBIPresentationServicesComponent\coreapplication_obips1)

locate the catalog tags and add :        <HashUserHomeDirectories>2</HashUserHomeDirectories>

image

NOTE: sometimes this number needs to be higher:

see: OBIEE Catalog for large organisations part 2 (published soon..) ==> http://obiee101.blogspot.com/2011/08/obiee-catalog-for-large-organisations.html

Goto the BI deplyment directory in the enteprise manager:

image
 

Press lock and edit configuration:

image

Enter a new for your NEW catalog:

image

Press Apply:

image

Press Activate Changes:

image

Go back to capacity management and start the presentation server:

image

(you might need to reboot the whole system, due to cache settings):

 image

Till Next Time.

No comments: