Skip to Content
avatar image
Former Member

Universe from EXCEL SHEET

Hi all,

I want to make universe from excel sheet. I made system DSN for odbc connection.

The connection test is successful but when i parse objects it gives me error like,

"Driver not capable : Transactional mode"

I have also commented the line transactional capability in ODBC.sbo file....

can any one give steps to create universe on excel file???

Thanks in advance

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Jun 06, 2011 at 06:25 AM

    Hi,

    Try with below steps.

    Comment out the Transactional mode parameter in the odbc.sbo file.

    1. Find the odbc.sbo file in the default location of <Business Objects install directory>\BusinessObjects Enterprise 12.0\win32_x86\dataAccess\connectionServer\odbc.

    2. Edit the odbc.sbo file and comment out the line:

    "<Parameter Name="Transactional Available">No</Parameter>"

    Use the xml comment characters: "<!-- -->"

    The line should look like this:

    "<!-- Parameter Name="Transactional Available">No</Parameter -->"

    Thanks,

    Amit

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 06, 2011 at 08:43 AM

    Hi amit kumar rathi,

    I tried doing so..but now i get different error called "Optional feature not implimented"

    Any idea?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 09, 2011 at 05:27 AM

    Hi amit ,

    I did change the parameter but still the same eror poping up

    " Optional feature not implimented"

    Add comment
    10|10000 characters needed characters exceeded