on 09-16-2008 1:55 AM
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Mark,
This was an issue with XIR2 version, but it was corrected in XI3.0.
Your Date field in SAP BI maps to many objects in the universe, if your date field is an attribute for instance, it will map to at lease two objects prefixed with L00 and L01 in the universe. Did you check all the objects created in the universe from your Date field ? one of them should have appropriate type Date, but not all of them.
If you create a universe from the SAP Demo cube for instance, the Calendar Day characteristic which is Date, will map in the universe to a class with two objects:
1- L00 Calendar Day : type = character because it represents ALL calendar days
2- L01 Calendar Day: type = Date because this represents the actual date field.
Hope this helps.
Abdellatif
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
User | Count |
---|---|
84 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.