cancel
Showing results for 
Search instead for 
Did you mean: 

Problems faced in Universe Designer

Former Member
0 Kudos

First of all, I am using Business Object Edge XI 3.1 trial version so i am creating this universe with this designer but when I open it, it says "Universe connection is not accessible" however I am still able to view my schema. Is there any problem with my connection to the database? currently using mssql 2005.

Secondly, after I created my schema, i run the integrity check and there are parsing errors that cannot be solved. Will it cause any disruption if I continue building the universe with the Web intelligence?

Thanks!

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

It depends what the parsing errors are and what the object definitions are.

For example, an object called Today defined as:

cast(convert(char(10),getdate(),23) as datetime)

This will not parse because it does not reference a table but as soon as you include it in a query with an object that references a table it will work fine.

As for your connection issue, are you using OLEDB or ODBC?

Does the user have permissions to use that connection as well as the universe?

Answers (2)

Answers (2)

Former Member
0 Kudos

Check your ODBC connection and the driver used. What is the version of the Driver ?

The Objects will not parse correctly because the connection is not able to see the tables in the database. Also, specify the Owner for the tables... in the Designer

Edited by: Irfan Mohammed on Sep 25, 2010 5:06 AM

former_member207342
Contributor
0 Kudos

- Check if user by which you are logging in has rights to access connection

- Check if connection is successful by testing it.

- Check if all the table in universe designer does exist in underlying database

--Kuldeep

Former Member
0 Kudos

We use a universe with the connection to SAP BEx Query. After importing the universe from CMS message "Universe connection is not accessible" appears.

BusinessObjects user, who imports the univers, has administrative rights. And connection is tested OK.