If you are unable to create a new account, please email bspsoftware@techdata.com

Author Topic: Controlling data shown in Query Studio  (Read 8876 times)

bonniehsueh

  • Guest
Controlling data shown in Query Studio
« 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?

Ty Clabbers

  • Guest
Re: Controlling data shown in Query Studio
« Reply #1 on: 08 Jul 2008 03:36:31 am »
Search the Cognos knowledge base for article 1016448.3.

bonniehsueh

  • Guest
Re: Controlling data shown in Query Studio
« Reply #2 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!

JaiCognos

  • Guest
Re: Controlling data shown in Query Studio
« Reply #3 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 :)))

sfirebaugh

  • Guest
Re: Controlling data shown in Query Studio
« Reply #4 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...