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