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.