IBM Cognos FAQ’s

147) Cognos 8

Cognos Report Net with enhancements + EP7 series.

148) which server tire is responsible for transforming information to Cognos 8 Application Server?

A Web server contains one or more web gateways which is responsible for transforming the information from one server to an appropriate server.( Cognos 8 Application Server) .

149) Which Server Tire processes the users request?

Application Tire server, It’s a main server which process users request.

150) what is the role of Data Tire?

Data tire contains content store and data source.

151) what is content store?

The database that contains all data that Report Net needs to operate, such as

• Report specifications, published models, and the packages that contain them

• Connection information for data sources

• Information about the external namespace, and the Cognos namespace itself

• Information about scheduling and bursting reports

Design models and log files are not stored in the content store.

The ReportNet service that uses the content store is named Content Manager.

152) What the gateways Cognos web server supports?

CGI (Common Gateway Interface):- This is the default gateway supported to all web servers.

ISAPI (Internet service Application Programming Interface):-  Use this gateway for Microsoft Internet Information Services (IIS) web server.

Apache-Mod :- This gateway is used for Apache Web Server.

Report Studio

153) What are enhancements in list report in Cognos 8 Report Studio?

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

154) What are enhancements in cross tab report in Cognos 8?

A Cross tab report is enhanced with following features:

a.     Can create the union Cross tabs.

b.    Can create headers and footers for a cross tab.

c.     List like cross tab.

155) What are enhancements in Chart report in Cognos 8?

A Chart report is enhanced with following features:

1. The following new charts are add

a.     Gauge Charts

b.    3D point chart

c.     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 include Geographical information and compare the business with various geographies.

156) what is 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.

Analysis Studio

157) what is Analyses studio?

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.

158) what are report Analyses Studio supports?

Analyses studio supports only cross tab, charts.

159) what is Cube?

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.

Query Studio

160) what are enhancements in Cognos 8 Query Studio?

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 analyses. (Drill Up, Drill Down, Drill Across).

161) what is Conditional format?

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

Metric Studio Application

162) A set of metric types, metrics, and scorecards that monitor the performance of an organization.

Each organization may have several Metric Studio applications monitoring distinct units, such as operating companies or divisions that have different user communities, metric types or reporting calendars.

163) Define Metric designer?

It’s a Cognos 8 modeling tool use to create extracts for using Cognos 8 score cording applications.

Transformer

164) what is Transformer in Cognos 8?

It’s a modeling tool for creating the Power Cubes for use with Cognos EP7 series and Cognos 8.

165) what is a Power Cube?

A file that contains data that is structured to provide for fast retrieval and exploration of data in Power Play.

166) what is the role of Transformer?

Transformer is used to create dimensional models and also create cubes.