on 09-22-2010 2:12 AM
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!
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
- 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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.