167) Define Event Studio:
Use the event studio to perform the tasks when the business event occurs.
When an event occur people are alerted to take actions.
168) Define burst:
To create many report results by running
a single report once. For example, you can create a report that shows
sales for each employee, and run it once, sending different results to
regional managers by bursting on region.
You set up bursting in Report Studio and enable it in the portal.
169) What is a report?
A set of data deliberately laid out to
communicate business information. Depending on the context, “report” may
refer to report specification or report output.
Report (more precisely, report
specification) is the generic term for the objects created by edited by
Query Studio, Report Studio, and Analysis Studio.
170) What is Report specification?
The definition of queries, prompts,
layouts, and styles that make up a report. A report specification is
combined with data by a run operation to create report outputs. You
create report specifications by using Report Studio, Query Studio,
Analysis Studio, or through the Software
Development Kit.
171) Define report output?
A report output combines data at the
point in time when the report was run with a report specification. It is
a document that can be displayed, printed or emailed. Cognos 8 can
produce report outputs in HTML, PDF, Excel, or CSV formats.
172) Define Content Manager:
The Cognos 8 service that manages the
storage of customer applications, including application-specific
security, configuration data, models, metrics, reports, and report
output.
Content Manager is needed to publish
models, retrieve or store report specifications, manage scheduling
information, and manage the Cognos namespace.
173) What is data source?
A relational database, dimensional cube, file, or other physical data store that can be accessed though Cognos 8.
174) Define data tree:
Within a studio, contains objects such
as query subjects, query items, dimensions, levels, and members. A data
tree is used as a palette of the available data that can be inserted
into calculations, filters, display areas, and other authoring gestures.
175) Define drill down:
The act of navigating from one level of data to a more detailed level. The levels are set by the structure of the data.
176) Define drill up:
The act of navigating from one level of data to a less detailed level. The levels are set by the structure of the data.
177) What is hierarchy?
A hierarchy represents a collection of
dimensional members organized into a tree structure, with each member
having one or more parent members and an arbitrary number of child
members.
The root of a hierarchy has no parent, and leaf members of a hierarchy have no children.
178) What is layout?
In reporting, layout defines the appearance of the report, including formatting, style, and design.
In report specifications, layout is the portion of the specification that defines how the data returned by queries is presented.
179) Define level:
A level is a set of members that have
common attributes. For example, a geographical dimension might contain
levels for country, region, and city. Levels are used to define the
structure of hierarchies in a dimension.
180) What is member?
A member is a unique item within a
level. For example, Camping Equipment and Golf Equipment are members of
the Product Line level.
181) Define locale:
A code that is used to set the language
or dialect used for browsers, report text, and so on; and the regional
preferences, such as formats for time, date, money, money expressions,
and time of day.
For Cognos products, you can specify a
locale for the product interface (product locale) and for the data in
the report (content locale).
182) Define multidimensional expression language (MDX):
An abbreviation for multidimensional
expression language, MDX is the multidimensional equivalent of SQL.
Cognos 8 allows report authors to type in their queries using MDX
expressions in Report Studio for dimensional data sources.
183) Use of repeater:
In Report Studio, a cell container that repeats values within itself with no predefined internal structure.
184) Define Repeater table:
In Report Studio, a table-like container that repeats cells across and down the page for row in the associated query.
185) What is template?
A reusable reports layout or style that can be used to set the presentation of a query or report.
186) Define work area:
The area within a studio that contains the report, analysis, query or agent currently being used.
187) What is a Hot File?
A separate local data table that can be
added to your catalog or used in the report as a data source and as if
it is a regular database table. A Hot File can be joined either with a
database table or with another Hot File itself.
188) What is Impromptu?
Impromptu is a windows based powerful
interactive query and reporting tool that lets you query data and create
sophisticated reports in a easy – to- use and sophisticated desktop and
interface.
189) What is the difference b/w macros and prompt?
Macro is a dynamic object which is used to substitute the values at query run time.
Prompt is a report element that asks for values before the report is run.
190) What is a Cube size?
Cube size is not static. it can be defined according to Project but we can create up to 2GB
191) What is refreshing of cube and how can we do it?
Refreshing a cube means getting the latest records from content store. we have an option to refresh cube.
192) what is meant by dash boards/flash cards?
Dash Board reports are used to create many reports in one report.
193) What is the usage of html object in tools box?
By using HTML object, We can insert multimedia file into report. At the run time we can see the file multimedia file.
194) How can we use conditional blocks?
Conditional Blocks adds an empty block that you can use for conditional formatting. You can hide and show report elements.
195) What is cube group?
Set of similar cubes built by Transformer.
196) What is burst reporting?
Burst reporting means sending a single report to multiple recipients using Cognos connection.
197) What is Level Span?
Level Span is used to avoid 1:1 relationship.
No comments:
Post a Comment