Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 216 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 79 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Error loading data using the Essbase Acceleration Wizard
[Tue Jan 31 10:03:44 2017]Local/Attendance///3156/Error(1198068)
ODBC message [[Oracle DataDirect][ODBC SQL Server Wire Protocol driver][Microsoft SQL Server]'days' is not a recognized built-in function name.]
We are using OBIEE version 12.2.1.2.0. How do I resolve this?
Thanks!
Answers
-
That's more an error on the source side. What is your source that you're trying to load? A proper metadata representation or some code in an opaque view?
0 -
I am using a view from sql server specifically designed to get the levels that I desire. All of the columns are varchar columns returning text that is divided by underscores to get the proper leveling. The dimension works properly in obiee when it is not wired back to essbase and drills down properly. However, it is very slow. Should I use the native odbc driver instead of the data direct driver used by the biplatform odbc dsn?
0 -
Well quite obviously the problem is with the code of that view and the actual, effective statement which gets sent to the source when the wizard emits it.
So a) What effectively gets emitted against the source by the wizard? First thing you need to find out.
I wouldn't jump on ODBC drivers without having analyzed anything.
0 -
OK. How do I see what is emitted against the source by the wizard?
0 -
Look in the log files
0 -
I have been looking at the essbase logs and can not figure it out. Here is an excerpt from the logs:
[Fri Jan 27 21:05:05 2017]Local/Attendance/FACT_StudentAttendanceDetail/jrphifer/8040/Info(1021003)
Connection String for [OBI_BUSINESS_MODEL] is generated
[Fri Jan 27 21:05:05 2017]Local/Attendance/FACT_StudentAttendanceDetail/jrphifer/8040/Info(1021041)
Connection String is [DSN=AnalyticsWeb;UID=...;PWD=...;]
[Fri Jan 27 21:05:05 2017]Local/Attendance/FACT_StudentAttendanceDetail/jrphifer/8040/Info(1021006)
SELECT Statement [SELECT_BUSINESS_MODEL "Student Information System"."DIM_EnrollmentHierarchy"."BusinessUnitTypeKey", "Student Information System"."DIM_EnrollmentHierarchy"."BusinessUnitType", "Student Information System"."DIM_EnrollmentHierarchy"."SchoolLevelKey", "Student Information System"."DIM_EnrollmentHierarchy"."SchoolLevel", "Student Information System"."DIM_EnrollmentHierarchy"."BusinessUnitKey", "Student Information System"."DIM_EnrollmentHierarchy"."BusinessUnit", "Student Information System"."DIM_EnrollmentHierarchy"."GradeLevelKey", "Student Information System"."DIM_EnrollmentHierarchy"[Fri Jan 27 21:05:05 2017]Local/Attendance/FACT_StudentAttendanceDetail/jrphifer/8040/Info(1021043)
Connection has been established
[Fri Jan 27 21:05:05 2017]Local/Attendance/FACT_StudentAttendanceDetail/jrphifer/8040/Info(1021044)
Starting to execute query
[Fri Jan 27 21:05:16 2017]Local/Attendance///3156/Error(1350002)
Attempt to set ODBC connection option failed with error []
[Fri Jan 27 21:05:16 2017]Local/Attendance///3156/Error(1198068)
ODBC message [[Oracle DataDirect][ODBC SQL Server Wire Protocol driver][Microsoft SQL Server]'days' is not a recognized built-in function name.]
0 -
By the way, it generates this error even with simple dimensions that I create and return quickly in obiee when I wire them back into essbase. The columns are not date related. It seems to be a problem with the data direct odbc driver trying to load a specific odbc option that does not exist in the driver.
0 -
Note:
[Fri Jan 27 21:05:16 2017]Local/Attendance///3156/Error(1350002)
Attempt to set ODBC connection option failed with error []
0 -
Weird. So when this is a general issue with all attempts then try the other driver. Can be the dll spewing out the code is bugged or trying to be too smart for its own good.
0 -
I will try that and let you know the results. Thanks!
0