Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Framework Manager => Topic started by: Cognos Talk on 08 Oct 2013 11:14:58 AM

Title: Not able to view data from tables or views in SQL Server.
Post by: Cognos Talk on 08 Oct 2013 11:14:58 AM
I am using Cognos 10.1 and have connection to SQL Server 2008 which was working before. For some reason when importing the view or table to framework manager i am able to import the table or view  definitions however when trying to test sample data  not even header columns come up, then i cannot even see the columns, any idea how to fix this problem? Connection works fine.
Title: Re: Not able to view data from tables or views in SQL Server.
Post by: aymancherif on 13 Oct 2013 06:16:14 PM
Isn't there any error messages appear helping on this ?

Thanks,
Ayman
Title: Re: Not able to view data from tables or views in SQL Server.
Post by: MMcBride on 14 Oct 2013 02:09:47 PM
Is your Model DQM Enabled?

There are two locations to to enable this and one of them is at the beginning when you first create your model.

I have seen issues very similar to what you are describing in DB2 and SQL Server 2008 when I am working with a DQM model.
When I reached out to IBM for help we ended up submitting some APAR's for it however the easiest work around was to not go DQM on the model and use DQM when you publish the package.
Text only | Text with Images