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
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
Re: MS Access odbc connection (Views/Querys)2012-12-03T17:12:14ZThis is the accepted answer. This is the accepted answer.OK, to answer my own question
It appears that this can only be done from the framework manager.
The querys (views) are displayed correctly here and are accessible.