COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: snagaboina on 09 Jan 2010 08:54:12 AM

Title: creating reports from views
Post by: snagaboina on 09 Jan 2010 08:54:12 AM

is there any possibility to create a report with the data from views without using these views?
Title: Re: creating reports from views
Post by: blom0344 on 09 Jan 2010 02:50:27 PM
Technically , yes. You can take the view's DDL and reuse this as an SQL datasource to the report. This however passes the model and may be more work to maintain. You then also need to allow users the right to straight SQL in reports..