Explore topic-wise InterviewSolutions in .

A PHYSICAL data SOURCE containing a multidimensional representation of data. A cube contains information organized into dimensions and optimized to provide faster retrieval and NAVIGATION in reports.

A physical data source containing a multidimensional representation of data. A cube contains information organized into dimensions and optimized to provide faster retrieval and navigation in reports.

Analysis STUDIO SUPPORTS only cross TAB, CHARTS.

Analysis studio supports only cross tab, charts.

In ANALYSES studio users can explore analyses and compare dimensional DATA. USE Analyses studio to read the data from MULTIPLE dimensional structures known as Cubes.

In analyses studio users can explore analyses and compare dimensional data. Use Analyses studio to read the data from multiple dimensional structures known as Cubes.

LEVEL SPAN is USED to AVOID 1:1 RELATIONSHIP.

Level Span is used to avoid 1:1 relationship.

Burst reporting MEANS SENDING a single REPORT to MULTIPLE recipients using Cognos CONNECTION.

Burst reporting means sending a single report to multiple recipients using Cognos connection.

SET of SIMILAR CUBES BUILT by TRANSFORMER.

Set of similar cubes built by Transformer.

Conditional Blocks ADDS an EMPTY block that you can use for conditional FORMATTING. You can hide and SHOW REPORT elements.

Conditional Blocks adds an empty block that you can use for conditional formatting. You can hide and show report elements.

By using HTML OBJECT, We can insert multimedia file into report. At the RUN time we can see the file multimedia file.

By using HTML object, We can insert multimedia file into report. At the run time we can see the file multimedia file.

DASH Board reports are used to CREATE many reports in one REPORT.

Dash Board reports are used to create many reports in one report.

Refreshing a CUBE means GETTING the LATEST records from content STORE. we have an OPTION to refresh cube.

Refreshing a cube means getting the latest records from content store. we have an option to refresh cube.

CUBE size is not static. it can be DEFINED ACCORDING to Project but we can create up to 2GB.

Cube size is not static. it can be defined according to Project but we can create up to 2GB.

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.

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.

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.

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.

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.

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.

The area WITHIN a STUDIO that contains the report, ANALYSIS, QUERY or AGENT currently being used

The area within a studio that contains the report, analysis, query or agent currently being used

A reusable reports LAYOUT or style that can be USED to set the presentation of a query or REPORT.

A reusable reports layout or style that can be used to set the presentation of a query or report.

In Report STUDIO, a table-like container that repeats cells ACROSS and down the PAGE for ROW in the associated query.

In Report Studio, a table-like container that repeats cells across and down the page for row in the associated query.

In Report Studio, a CELL container that repeats values WITHIN itself with no predefined INTERNAL structure.

In Report Studio, a cell container that repeats values within itself with no predefined internal structure.

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.

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.

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).

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).

A MEMBER is a UNIQUE item within a level. For example, Camping EQUIPMENT and Golf Equipment are members of the PRODUCT Line level.

A member is a unique item within a level. For example, Camping Equipment and Golf Equipment are members of the Product Line 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.

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.

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.

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.

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.

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.

The act of NAVIGATING from one LEVEL of DATA to a less DETAILED level. The levels are set by the STRUCTURE of the data.

The act of navigating from one level of data to a less detailed level. The levels are set by the structure of the data.

The ACT of navigating from ONE level of DATA to a more detailed level. The levels are SET by the structure of the data.

The act of navigating from one level of data to a more detailed level. The levels are set by the structure of the data.

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.

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.

A relational database, DIMENSIONAL CUBE, FILE, or other PHYSICAL data store that can be accessed through Cognos 8.

A relational database, dimensional cube, file, or other physical data store that can be accessed through Cognos 8.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

Use the EVENT studio to perform the tasks when the business event occurs.

When an event occur PEOPLE are ALERTED to TAKE ACTIONS.

Use the event studio to perform the tasks when the business event occurs.

When an event occur people are alerted to take actions.

The data in the report can be FORMATTED based on GIVEN condition this ALLOWS you to QUICKLY identify the data for faster analyses.

The data in the report can be formatted based on given condition this allows you to quickly identify the data for faster analyses.

1. Formatting :- Now query studio allows you to format the report with font, colors, and border styles.
2. CONDITIONAL Formatting :- The data in the report can be formatted BASED on given condition this allows you to QUICKLY identify the data for faster analyses.
3. Applying Templates :-Templates can be created in report studio which can be applied to the reports created in Query Studio.
4. Improved Filtering :- Query Studio allows you to create more advanced filters using logical operators. AND or OR.
5. Query Data from OLAP sources (cube) :- Now Query Studio supports in READING the data from multi-dimensional STRUCTURES known as Cubes.
6. Supports Hierarchy Levels :- Since Query studio reads the data from Cube which is defined with hierarchy levels it supports multi-dimensional analysis. (Drill Up, Drill Down, Drill Across).

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.

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.

In QUERY Studio the footer summaries (Grand Totals) are AUTOMATICALLY generated for MEASURES.

The SUB totals can be generated by creating the GROUPS.

In Query Studio the footer summaries (Grand Totals) are automatically generated for measures.

The sub totals can be generated by creating the Groups.

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.

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.

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.

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.

QUERY STUDIO is the ADHOC QUERYING TOOL.

Query Studio is the adhoc querying tool.

When a report CONTAIN a prompt EXECUTES a prompt QUERIES the data from DATABASE at very first time and STORES the results in prompt cache.

When a report contain a prompt executes a prompt queries the data from database at very first time and stores the results in prompt cache.

A Chart report is enhanced with following features:

1. The following new charts are add

• Gauge Charts
• 3D point chart
• By polar axis charts (USED for Bio-technology).

2. The chart can be applied with patterns, Fonts, Colors.
3. Can perform drill on chart.

4.Now we can create map REPORTS which INCLUDES Geographical information and compares the business with various GEOGRAPHIES.

A Chart report is enhanced with following features:

1. The following new charts are add

2. The chart can be applied with patterns, Fonts, Colors.
3. Can perform drill on chart.

4.Now we can create map reports which includes Geographical information and compares the business with various geographies.

Cross tab REPORT is enhanced with following features:

1. Can create the UNION Cross tabs.
2. Can create HEADERS and footers for a cross tab.
3. LIST like cross tab.

Cross tab report is enhanced with following features:

A list report is ENHANCED with FOLLOWING features:

1. Can apply List COLUMN Title STYLE
2. Can apply list column Body Style
3. Can apply the table Style

A list report is enhanced with following features:

It RESTORES the DETAILS. A report NEEDS to be DESIGNED with GROUP.

It restores the details. A report needs to be designed with group.

It will SUPPRESS (HIDE) the DETAILS of a GROUPED REPORT.

It will suppress (hide) the details of a grouped report.

1. COLUMN CHART
2. BAR Chart
3. PIE Chart
4. LINE Chart
5. Area Chart
6. Point Chart
7. Radar Chart

• A Chart is a graphical presentation of BUSINESS data.
• A chart REPORT is DESIGNED for COMPARATIVE Analysis.

Cognos REPORTNET supports only Basic and Nested Cross TAB LAYOUTS.

Cognos Reportnet supports only Basic and Nested Cross Tab layouts.