BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: BOB is going to retire...please see details here.
General Notice: No events within the next 45 days.

Cannot add an Excel sheet into an Universe

Goto page Previous  1, 2
 
Search this topic... | Search Semantic Layer / Universe Designer... | Search Box
Register or Login to Post    Forum Index -> Semantic Layer / Universe Designer  Previous TopicPrint TopicNext Topic
Author Message
Rajua99
Principal Member
Principal Member



Joined: 16 Dec 2004

Posts: 387
Location: Arizona


flag
PostPosted: 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
Principal Member



Joined: 16 Dec 2004

Posts: 387
Location: Arizona


flag
PostPosted: 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
Principal Member



Joined: 08 May 2006

Posts: 137



PostPosted: 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
Forum Member



Joined: 11 Jun 2009

Posts: 6



PostPosted: 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
Forum Member



Joined: 11 Jun 2009

Posts: 6



PostPosted: 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
Display posts from previous:   
Register or Login to Post    Forum Index -> Semantic Layer / Universe Designer  Previous TopicPrint TopicNext Topic
Page 2 of 2 All times are GMT - 5 Hours
Goto page Previous  1, 2
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0352 seconds using 17 queries. (SQL 0.0096 Parse 0.0009 Other 0.0247)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo