COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Query Studio => Topic started by: bonniehsueh on 03 Jul 2008 12:33:04 PM

Title: Controlling data shown in Query Studio
Post by: bonniehsueh on 03 Jul 2008 12:33:04 PM
Is there a way to control when values are shown in Query Studio so that when users drag data items into the report area the data doesn't automatically display?
Title: Re: Controlling data shown in Query Studio
Post by: Ty Clabbers on 08 Jul 2008 03:36:31 AM
Search the Cognos knowledge base for article 1016448.3.
Title: Re: Controlling data shown in Query Studio
Post by: bonniehsueh on 29 Jul 2008 04:44:57 PM
I am on version 8.2 so the KB document did not work for me.
The latest KB document did work for me and has been tested succesfully on 8.2 and 8.3.

http://support.cognos.com/knowledgebase/googlesearch?load_kb_document=1&dr=kb1&uniqueid=139093

Enjoy!
Title: Re: Controlling data shown in Query Studio
Post by: JaiCognos on 26 Aug 2009 04:51:26 AM
Yes there is a way when ever you create a report in query studio gives you three options how to display the data.

1.Data Turn Off-With this option you can see the dummy data that is not queried from the database.
For your requirement you can control the data by create the report in this mode so that report will display the dummy data.
2.Run with all data:Here you can view all the records available in the data base.
3.Run with limited data:With this option we can query  the data and view the report with limited data from the data available in the database.

Hope this helps you :)))
Title: Re: Controlling data shown in Query Studio
Post by: sfirebaugh on 28 Aug 2009 01:00:57 PM
As JaiCognos stated, each user will have to set how to view the data.  This can be set in Manage File > My Preferences...