Sunday, April 29, 2012

BusinessObjects-CS: COM Provider CLSID not specified or erroneous

If you face with this problem be cool. It is very easy to resolve it.

First you have to do is install SQL Server 2008 to your server where your BusinessObjects is installed. After that go to your BusinessObjects installation folder. Under "SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\dataAccess\connectionServer\oledb" you will see the sqlsrv.sbo file. Open this file and change the two lines as shown in the picture below:



If you use client tools you have to do this at your client too.

If you install SQL Server 2005 drivers you have to write only "SQLNCLI" instead of "SQLNCLI10"

BusinessObjects-BI4 Configuration Tips

After installation of your BI4 system one of the important thing you should notice is the "Platform Search Application". This Application is indexing all of your data for searching. Not only your documents, it is also indexing your universe dimensions. By indexing your universes it runs the List Of Value query. Therefore it can be harmful to your database systems.

To configure your Platform Search Application go to the Central Management Console. Under "Application" you can see "Platform Search Application". I suggest to index only Web Intelligence content. I also recommend to set the "Crawling Frequency" to "Scheduled Crawling".

If you change the "Crawling Frequency" don't forget to schedule it under the "Platform Search Scheduling"

Saturday, April 28, 2012

BusinessObjects-BI4 Main URL List

Query Panel:
http://cmsserver:port/AdminTools

BI Launchpad:
http://cmsserver:port/BOE/BI

CMC (Central Management Console) Panel:
http://cmsserver:port/BOE/CMC

LCM (Life Cycle Management) Panel:
http://cmsserver:port/BOE/LCM