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"

Tweet

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"

Tweet

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

Tweet

BusinessObjects-Main Query Tables for BusinessObjects R2

Query all this tables from the SI_KIND column

CI_INFOOBJECTS
-Webi

CI_APPOBJECTS
-Universe
-Universe Connection

CI_SYSTEMOBJECTS
-User
-UserGroup

Tweet

BusinessObjects-Install Business Objects R2 to Windows 2008

If you want to install Business Objects R2 to Windows 2008 you will get the error mesaage "can't start service Event Server". Ignore this message and continue to your installation(for each service). After finishing restart your server. Open CMC console. You will see that all of your services are stopped.


Ok, right click on each service which you want to use. Go to the dependency tab. You will see that the NTLMSSP service is red. Select that service and remove. Now you can start your service.


The reason is that Windows 2008 no longer uses NTLMSSP.

Tweet

BusinessObjects-Keycod Error For Xcelsius

If ypu got the "The Keycode you entered is not valid. Please try again" error go the to registry and open the "HKEY_LOCAL_MACHINE–> SOFTWARE –> Business Objects –> Suite 12.0" folder.

Under Xcelsius>Keycodes change the DATA value to your keycode and add a semicolon and the date. For example:

XXXXXXXXXXXXXXXXXXXXXXX;20101203

Tweet

BusinessObjects-Xcelsius 2008 Installation On Office 2010

First download the file from

http://download.microsoft.com/download/7/c/4/7c426dfc-46e2-4ded-bab4-3b33600ad7d1/msi45sdk.msi

After you run this file go to the installation folder and run orca.msi (under tools subfolder. usually "C:\Program Files\Windows Installer 4.5 SDK\TOOLS")

This will create the orca.exe file.

Run the orca.exe file and open the xcelsius.msi file (before this action take a copy of your file).

From the left pane select "LaunchCondition" and drop the "EXCEL 10 OR...." line.

Save the file and run.

Tweet