I have successfully added my MS access DB as an odbc datasource within the cognos express manager. The problem is, when use the data source in advisor, it displays all MS access db tables but not the predetermined querys (Views). When creating dimensions in Data Advisor, it doesn't allow me to add columns from multiple tables. So as far as I can work out, it will only let me create models from individual tables which is useless to me.
When I use the same odbc connection in other software environments, it always displays all tables and defined queries (views).
Any help with this would be much appreciated.
Me - First time cognos express user (Trial version 9.5)
OS - Windows 7 Pro 64
MS Office 2010
NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
This topic has been locked.
1 reply Latest Post - 2012-12-03T17:12:14Z by SystemAdmin
Pinned topic MS Access odbc connection (Views/Querys)
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-12-03T17:12:14Z at 2012-12-03T17:12:14Z by SystemAdmin
SystemAdmin 110000D4XK214 Posts