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…):
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>
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:
Press lock and edit configuration:
Enter a new for your NEW catalog:
Press Activate Changes:
Go back to capacity management and start the presentation server:
(you might need to reboot the whole system, due to cache settings):
Till Next Time.