Skip to Content
avatar image
Former Member

BOXI 3.0 Universe Does not Recognize SAP BI Query Date Fields as Date

We are noticing that the universes that are created are turning all date fields from the bex query to charachter fields. When we try to change the field back to a date in the universe it fails saying that the driver is not capable. This is usually tied to bad data in the columns. Has anyone seen this and come up with a workaround?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 16, 2008 at 05:56 PM

    Hi,

    You need to post your question in Crystal Report .Net Form link is here

    BusinessObjects Integration Kits

    Hope this helps!!

    Regards,

    Deepti Bajpai

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 16, 2008 at 05:58 PM

    Hi,

    You need to post your question in Integration Kits - SAP Form link is here

    BusinessObjects Integration Kits

    Hope this helps!!

    Regards,

    Deepti Bajpai

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Mark, you are not alone.

      We also encountered this error using XI 3.0. We received the "Driver is not capable" error message when including date dimensions from a universe built on a BEx query. Looking at the universe, the date dimensions themselves were date fields, but all the date keys were listed as characters.

      Our fix:

      Replace all the date dimensions with the date keys listed below the dimensions. This is a little tricky because when you add the key into your webi query, it automatically adds the dimension. You have to manually remove the dimensions from the webi query after adding the key, and your report should run without the "Driver not capable" error message.

      This is a serious bug, because now we have to train users building the webi queries to delete the date dimension. We cannot hide the dimension in the universe because it will also hide the key.

      I guess another fix could be creating a new Dimension in the universe, and copying the properties from the key field into the new dimension...but if you have many dates, it's a big pain.

      Hope this helps,

      -Lee