Author |
Message |
Rajua99 Principal Member


Joined: 16 Dec 2004
              Posts: 387 Location: Arizona

|
Posted: Fri Oct 13, 2006 6:56 pm Post subject: Re: Cannot add an Excel sheet into an Universe |
|
|
Hello,
I was able to create a connection for my excel sheet by keeping the array size to 1 and it is responding also. when i am parsing the objects i am getting this error message for all the objects that exists in my excel sheet. I got only 2 colums in my excel sheet and both of them are number only.
Parse failed: [Microsoft][ODBC excel driver] syntax error in From clause.
Thanks
Alluri[/b] _________________ BO Admin and Developer
Currently working on 5.1.9/6.5.1/XIR2/XI 3.1. Testing BI 4.0 |
|
Back to top |
|
 |
Rajua99 Principal Member


Joined: 16 Dec 2004
              Posts: 387 Location: Arizona

|
Posted: Thu Oct 26, 2006 12:14 pm Post subject: Re: Cannot add an Excel sheet into an Universe |
|
|
I was succesfull in creating the Unvierse using excel sheet using the pdf provided by Robert Metzker in his website how to create Universe from excel file
Here is the Link to this website.
http://homepage.mac.com/rmetzk/Busobj_Tutorials.html
Thanks,
Alluri _________________ BO Admin and Developer
Currently working on 5.1.9/6.5.1/XIR2/XI 3.1. Testing BI 4.0 |
|
Back to top |
|
 |
bodevXI Principal Member


Joined: 08 May 2006
             Posts: 137

|
Posted: Sun Oct 29, 2006 3:52 am Post subject: Re: Cannot add an Excel sheet into an Universe |
|
|
Hi,
We have a requirement to create universe with Excel as data source.
We are getting the error " Optional Feature Not Implemented"
As mentioned while creating we took care that the Array Fetch Size is set to 1.
What is the purpose behind selecting the ODBC3 connection?
Is this the reason for getting the above mentioned error?
Please respond .......
This is an urgent requirement. |
|
Back to top |
|
 |
cart3r Forum Member


Joined: 11 Jun 2009
          Posts: 6

|
Posted: Wed Jun 16, 2010 4:24 am Post subject: Re: Cannot add an Excel sheet into an Universe |
|
|
Hi,
I'm having trouble creating a working universe based off my excel sheet. The ODBC connection is valid and the connection test works in Designer.
I'm able to create objects based off the data in Excel.
However, when I go to the SQL viewer inside each object, it says the server is not responding (QP0016).
I also get the Parse failed: Drive not capable : Transactional Mode error when I try to parse the objects.
I used the Microsoft Excel Driver to create the ODBC link and tried both the Generic ODBC and Generic ODBC3 connectors in Designer.
Any ideas?
thanks |
|
Back to top |
|
 |
cart3r Forum Member


Joined: 11 Jun 2009
          Posts: 6

|
Posted: Thu Jun 17, 2010 1:22 am Post subject: Re: Cannot add an Excel sheet into an Universe |
|
|
problem resolved. for my particular case, i changed the
<Parameter Name="Transactional Available">NO</Parameter>
to
<Parameter Name="Transactional Available">Yes</Parameter>
in the odbc.sbo file. |
|
Back to top |
|
 |
|