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

BusinessObjects-Query Builder Examples

Main tables: CI_INFOOBJECTS, CI_APPOBJECTS, CI_SYSTEMOBJECTS

Some scenarios:

Which BusinessObjects Active Directory Groups don't have any member:
• Select SI_NAME from CI_SYSTEMOBJECTS WHERE SI_KIND = 'UserGroup' and SI_GROUP_MEMBERS is null

Which Universes use the Connection 'con1'?
• Select * FROM CI_APPOBJECTS WHERE CHILDREN("SI_NAME = 'dataconnection-universe'", "SI_NAME = 'con1'")

List of all Universes
• Select SI_NAME, SI_ID FROM CI_APPOBJECTS WHERE SI_KIND='Universe'

List of all Universe Connections
• Select SI_ID, SI_NAME FROM CI_APPOBJECTS WHERE SI_KIND = 'metadata.dataconnection'

List of Active Connections
• Select * FROM CI_SYSTEMOBJECTS WHERE SI_KIND='Connection'

Which Reports Use my Univ1 Universe
• SELECT si_id, si_name,si_universe,si_cuid
FROM CI_INFOOBJECTS, CI_SYSTEMOBJECTS, CI_APPOBJECTS
Where PARENTS("SI_NAME='Webi-Universe'","SI_NAME ='Univ1'")
and SI_KIND = 'Webi' and si_instance = 0

List of Named Or Concurrent Users
• SELECT si_name FROM CI_SYSTEMOBJECTS where SI_NAMEDUSER=0 AND SI_KIND='User'
SI_NAMEDUSER=0 is for Concurrent users. Use SI_NAMEDUSER=1 for Nameduser

To bring back all folders and objects in the ‘Report Samples’ folder:
• select * from ci_infoobjects, ci_appobjects, ci_systemobjects where DESCENDENTS("si_name='Folder Hierarchy'","si_name='Report Samples' and si_kind='Folder'")

To bring back only direct children (objects and folders) in the ‘Report Samples’ folder:
• select * from ci_infoobjects, ci_appobjects, ci_systemobjects where CHILDREN("si_name='Folder Hierarchy'","si_name='Report Samples' and si_kind='Folder'")

To list reports and documents those are in public folders including Sub folders. (Excluding instances, personal documents and inbox documents):
• SELECT * FROM CI_INFOOBJECTS WHERE SI_KIND IN ('FullClient', 'Txt', 'Excel', 'Webi', 'Analysis', 'Pdf', 'Word', 'Rtf', 'CrystalReport', 'Agnostic') AND SI_RUNNABLE_OBJECT = 0 AND SI_INSTANCE_OBJECT = 0 AND SI_ANCESTOR = 23

Tweet

BusinessObjects-Universe not Found WIS 00501

Let's try to explain the situation what we faced. You have two BusinessObjects environments. Our goal is export webi reports and universes to a biar file and import them to the target system.

Everything looks fine? Here comes the nightmare. You refresh the reports and



There are many possible reasons. Our root cause was security.

Under Central Management Console look to the "Universes" folder. On the "Rights" tab be sure there is a group which has access to this folder (Universes) and this group belongs to a group that want to view the webi reports.

For the second be sure that the same group has access to the Universe Connections. You can check this in Central Management Console->Universe Connections->Rights.

More about this article can be found here :
http://www.businessobjectstips.com/tips/web-intelligence/what-is-an-unbound-report-and-why-should-i-care/

Tweet