what is new in BO Enterprise XI 3.1

Client tools
• BO Enterprise Java InfoView = the old infoview webi but now comes with Dashboard Builder and PM. I think.
• Dashboard Builder
• Performance Manager

• Web Intelligence Rich Client
the old web intelligence enhanced.

• Desktop Intelligence = the old Business Objects Full Client Application

• Central Management Console (CMS) = the old supervisor.

• Report Conversion Tool
convert BO Desktop Intelligence docs (*.rep) >>>>>>>>> Web Intelligence docs (*.wid)

• Universe Designer
the old Designer. Now it comes with an option on the menu called "query panel", where you can see the query to be built.

• Data Source Migration Wizard
• Business Views Manager
• Report Comparison Tool
• Import Wizard
• Publishing Wizard
• Query as a Web Service
• Translation Manager
• Universe Builder
• Universe Connection Manager
• Crystal Reports
• Voyager
• Set Analyzer
• Integration Kit for SAP
• Integration Kit for Peoplesoft
• Live Office

• Central Configuration Manager = gathers all services (start/stop) related to Business Objects like windows services.
The services are:
• Apache Tomcat
• WinHTTP Web Proxy Auto-Discovery Service
• World Wide Web Publishing Service

BO designer: Divergences in Check cardinalities

In my opinion we may have divergences in BO designer during the cardinalities check when:

We have multilanguage selection during the query. This table has two primary keys, the code and the language. For this, bo thinks there are two rows for each N row in another table, so it thinks you have a N by N relationship. We don't select the code at this point because the user will select when creating the query:

*the part circled was introduced by me after the checking. if I hit detect button it says ok.
clang='EN'

, the error is :"cardinality is not valid" because i forced 1 by N relationship and BO checks and see N by N relationship due to the lack of the language.

Free lancer

windows services explained

http://www.theeldergeek.com/alerter.htm

BO 6.5 Tracing file - ultimate tracing

Put this code into a bo_trace.ini file:

Code:

active=true;
importance='<<'; size=100000; keep=true; Put it on a tmp directory and create this environment variables (these have my tmp directories): BO_TRACE_CONFIGDIR -> C:\temp\TraceLog
BO_TRACE_CONFIGFILE -> C:\temp\TraceLog\BO_trace.ini
BO_TRACE_LOGDIR -> C:\temp\TraceLog

to disable you need to put the webi service down

Characters and Apostrophes

We have an universe in French language, objects and classes in french like:

Données and Date de l'implementation.

I opened my designer and the universe opened with these descriptions:

Donnies and Date de l implementation

I exported and got the following error:

Problem Error: "[Microsoft] [ODBC SQL Server Driver] [SQL Server] Statement(s) could not be prepared. Contact your administrator or database supplier for more information (Error: WIS 10901)" when running a report in WebIntelligence
Resolution *****CONFIGURATION******
WebIntelligence 6.1x
SQL Server 2000

***********SYMPTOMS*******
When running a report in WebIntelligence, the following error message appears:

'[Microsoft] [ODBC SQL Server Driver] [SQL Server] Statement(s) could not be prepared. Contact your administrator or database supplier for more information (Error: WIS 10901)"

**********CAUSE**************
The report is created from a Universe that has an apostrophe in the Class and/or object names.

**********RESOLUTION******
Remove the apostrophe from the Class and/or object names.



*************MY RESOLUTION************
Restore repository's backup to get the old universe. It worked

Links

http://www.dwinfocenter.org/
http://www.dw-institute.com
http://www.RalphKimball.com
http://www.BillInmon.com
http://www.DataWarehouse.com
http://www.dmReview.com
http://www.datamation.com
http://www.intelligententerprise.com/
http://www.datamirror.com
http://www.techguide.com
http://www.business-intelligence.co.uk
http://www.datamining.com/dm-ka.htm
http://www.evaltech.com
http://businessintelligence.ittoolbox.com/

timelines

BI Course

http://www.nextg.com.br/v2/web/curso.php

Cache d'univers

Apagando cache de universos no servidor bo 6.5.1


d:\business objects\businessObjects Enterprise 6\nodes\FRPARWIP1\mycluster\universes\UNIVERS

d:\business objects\businessObjects Enterprise 6\nodes\FRPARWIP1\mycluster\universes\UNIVERS\ucdz

Diretorio q se pode apagar os universos *.unv e o arquivo *.unw

VI para usuarios Windows

VI (se pronuncia viai do ingles visual editor) é um editor em linux muito útil e se vc quer ser um administrador de sistema linux/unix ou um bom usuário, vc deve saber a usar o VI.

Caso queira utilizar o VI no windows baixe uma versão no site www.vim.org

Nao vou falar de VI nesse blog porque vc pode encontrar vários websites especializados nisso.

Enjoy

WEBI 6.5 and BOFC 5 prompts problem

problem: the user cannot see all the values on his prompts, but a brand new user with the same rights can. report written in BO FC 5.1

symtoms: list of prompts cannot be refreshed when the user opens BO FC 5.1 report on webi 6.5

the object is a filter
filter name: Annee/Mois ?
where: @Select(Periode de connexion\Annee/Mois) IN @Prompt('Choisissez une ou plusieurs periode','A','Periode de connexion\Annee/Mois',MULTI,FREE)

reason: bug


solution: create a new user, copy the personal reports of the old user to this user and delete the old user.

Locked General Supervisor

This saved my life today.
If you don't have a second general supervisor, you could try the following SQL run against the security domain database:
Code:

Update OBJ_M_ACTOR Set M_ACTOR_C_PASSWORD = NULL Where M_ACTOR_C_NAME = ;

This will set the password for the general supervisor to null, and therefore the next time you login, you will not need to enter a password. It is recommended that a password is given asap via the supervisor module. You will also have to set the status of the user login, otherwise even with a null password BusObj will not let you log in. The status column is in OBJ_M_ACTOR and is called M_ACTOR_N_STATUS. If you set this flag to 1 along with setting the password to null then you should be okay. If this still doesn't work, make sure you have commited the database update

Dw com BO

Assunto técnico em informática de Datawarehouse com Business Objects


Caso não lhe interesse, visite tapioca do bill.