Tuesday, 16 September 2014

IBM Cognos BI Interview Questions – Query Studio

142) What is Query Studio?
Query Studio is the adhoc querying tool.
143) What is a adhoc report?
An adhoc report is a simple report or one-time report that is outside the set of standard reports you may have available to you.
A design time environment acts as a runtime environment.
It’s also known as self service.
144) What is measure?
A query item that contains values that can be aggregated to produce meaningful results. For example, product costs can be treated as a measure because average and total costs have some meaning, but product codes, though numbers, are not usually treated the same way. Measures are quantitative performance indicators.
Measures give the numbers that usually appear in the cells of cross tab reports or in the numbers of a chart.
Measures are also known as facts.
145) How Grand totals and Sub totals are generated in Query Studio?
In Query Studio the footer summaries (Grand Totals) are automatically generated for measures.
The sub totals can be generated by creating the Groups.
146) Define layout:
In reporting, layout defines the appearance of the report, including formatting, style, and design.
In report specifications, layout is also the name of an element that defines how the data returned by queries is presented.

No comments:

Post a Comment