New Universe not refreshable by other users

[funkmonsteruk]

I've just created a new universe - gone through the odbc admin and exported it to a repository.

Reports based on this universe work fine for me but other users are getting an odbc connection error everytime they try and refresh- anybody know of a common cause for this error?

 

[nimmy99]

Is it for BO or WEBI? Give us the exact error message what they are getting.

 

[funkmonsteruk]

Nimmy,

It's BO and the error message is [microsoft][odbc driver manager] data source name not found and no default driver specified0

 

[blom0344]

That's about the clearest message possible,there is no ODBC connection set-up on those users's PC's T. Blom
Information analyst
tbl@shimano-eu.com

 

[khobar]

Hi

Can somebody highlight the steps involved in creating a WEB based report using BO.

Install the server version BO package 5.0
1. Should i first create a repository
2. Create and Store the report in the repository
3. Publish these report as a web page

I am new to this environment please help

khobar

 

[funkmonsteruk]

OK, I've gone into the users machine odbc setup and created a system dsn which points to the relevant database and i've given it the same name as my own connection. Now i'm getting a new error message.

It's giving me a microsoft odbc error and it's saying Not a valid bookmark - 1045

Any suggestions?

 

[blom0344]

The connection name you specify is BusObj related. The DSN should be configured directly to the database where you store the repository. The universe connection is just that it is a parameter of the universe. A repository can store any number of universes with their own connections.... T. Blom
Information analyst
tbl@shimano-eu.com

 

[funkmonsteruk]

The user alreafdy seems to be connected to the repository - do you think the problem could be with the way in which i have added the universe to the repository?

 

[funkmonsteruk]

Got it to work blom - you were right I hadn't exported the universe to the repository correctly...

Cheers for your help