IBM Cognos Business Intelligence v10: Using Query Studio
- Dec 3, 2012
- Launch Query Studio
- Query Studio High-Level Interface
- Report Types
- Open an Existing Report
- Create a List Report
- Run the Report
- Change Layout
- Create a Crosstab Report
- Create Filters
- Summarize Report
- Sort Data
- Create Calculations
- Create Charts
- Define Conditional Styles
- In a Nutshell: Reviewing by IBM Cognos BI Audience
Query Studio is a core IBM Cognos BI component and is installed as part of the IBM Cognos BI Server install. It is an end-user ad-hoc query tool for business users and business analysts who need to explore the data to quickly answer various business questions. Query Studio is easy to use and requires little or no training.
Query Studio uses relationally and dimensionally modeled data and uses the same administration process and security already defined in the IBM Cognos BI environment. It is a web-based component used to perform analysis and explores data to answer simple business questions quickly. Like any other tool, you should be familiar with your organization’s data to build meaningful queries.
Cognos Workspace Advanced is the logical upgrade path for IBM Cognos BI V10.x users that brings together Query Studio, Analysis Studio, and Report Studio Express features, all in one place. If you are a legacy IBM Cognos 8.x user, you can continue to use your queries from IBM Cognos BI 8.x in IBM Cognos BI v10.x; however if you plan to build new reports for query and analysis, it is recommended you tap into the rich capabilities of IBM Cognos Workspace Advanced.
Launch Query Studio
You can launch Query Studio from the Welcome screen by clicking Query my data under My Actions section or from the IBM Cognos Connection launch option, click Launch > Query Studio.
When you launch Query Studio, you must select a package that contains the metadata for your reporting, for example, Go Data Warehouse (query). You can work with both dimensional and relational packages; although, relationally modeled data is more suited for Query Studio. You can work with one package at a time.
When you launch Query Studio and choose a package, you are taken to a blank Query page with data items and other prebuilt objects such as filters available in the package in the Menu pane.
Before you start creating your report using Query Studio, you must ensure that the metadata is available via a Framework Manager package and has been published to IBM Cognos Connection. You should also ensure that the package contains all the information you need to build your report.