Excel and Business Objects

[PETEHO]

I have created a Universe based on a single excel worksheet with 70 columns, nothing fantastic.

I created the universe and inserted table,all 70 column headings are shown. to check it was reading this correctly I did a count of Rows and got the following error 'Syntax error in From Clause'

If I ignore this I get further errors the more I go on mentioning 'DBD exceptions' and 'Unable to find owner'.

Are there any excel issues that people are aware of with BOXI r2. I have never had a problem form SQL or Oracle.
Thanks

 

[blom0344]

I have no experience with BOXI r2, but I would not expect a SQL function like 'count' to work on a Excel datasource.
spreadsheet <> database.

The concept of a database row in a fundamentally different one than that from a spreadsheet..

Ties Blom