Can't seem to get it to work. I am going to open an SR. Thanks for your help.

I will try that and let you know the results. Thanks!

Note: [Fri Jan 27 21:05:16 2017]Local/Attendance///3156/Error(1350002) Attempt to set ODBC connection option failed with error []

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.

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…

OK. How do I see what is emitted against the source by the wizard?

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…

I was having trouble getting a connection to Essbase in the RPD. It is working now.