TOP Cognos Interview Questions and Answers

Read Latest Cognos Interview Questions and Answers for Freshers, 2+ Years Experienced Q and A with Explanation PDF.

How you drill from powerPLay to Impromptu? Explain all Steps?

go to tran former,

build the cube

right click on the cube and open properties

go to drill through tab and select your report from that browse option

What is Drill Through?

Drill-through reporting allows you to link from one report to another. You can drill through in a number of ways. > A Drill Through id developed with two reports.

1. Parent Report > 2. Child Report.

How to generate cubes in cognos?

Power Play Transformer contain dimension,measure,model and cube. we can generate cube different way. > Just right click on cube name and build.

we can write script in unix. using that we can generate cube.

What is main difference mapplets and mapping?

Reuse the transformation in several mappings, where as mapping not like that.

If any changes made in mapplets it automatically inherited in all other instance mapplets.

What are products of Cognos?

Cognos 6.6 7.0,7.3(PowerPlay, Impromptu)–ReportNet1.0,1.1mr1, 1.1mr22—ReportNet 8.0(latest)IWR is use by Impromptu to publish reports, PPES is used by PP, Cognos Connection is used by repornet. there are many other tools but these are the main.

What is Zero-foot print? What are the other methods working as deployment functionality?

Cognos offers Portal Services that allow organizations to easily manage and display Cognos business intelligence, planning, and scorecarding in your existing enterprise information portals. Including Cognos reports, analysis, dashboards, scorecards, and other capabilities drives higher returns in your information and portal investments.

Zero Footprint: Cognos portals have no footprint on the user’s desktop. Anyone inside or outside the organization with a Web browser can access and interact with content.

Intuitive User Interface: No special training is required to use the portal. Standard browser interface actions-such as following hypertext links, copying, and pasting-allow users to access and organize business intelligence content quickly and easily

What are the components of Report Net?

Framework manager ,Cognos connection, Query Studio, Report Studio

What is snapshot?

A Snapshot is the copy of data, when we create a snapshot it copies the exact data that’srelated to the at perticular report, we use snapshot when ever we want to compare reports.(Example :we want to compare this months report with previous months).

Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output?

5 Rank.

How can i test reports in cagonos?

In cognos report net by the validate report option a report can be tested. If there will be any error, it will specify the the error, unless it will give message -‘report specification is valid’.

After creating the report we will connect to the oracle and we will write the sql query and we will compare this 2 reports .

What are shortcuts? Where it can be used? What are the advantages?

There are 2 shortcuts(Local and global) Local used in local repository and global used in global repository. The advantage is reuse an object without creating multiple objects. Say for example a source definition want to use in 10 mappings in 10 different folder without creating 10 multiple source you create 10 shotcuts.

What is difference between content store and content manager?

A content store is a data base which stores the meta data of the reports.

But where as a content manager is a service which is available in dispatcher. which it manages the security.

Define datastores in Cognos?

Data sources, also known as query databases, are relational databases, dimensionalcubes, files, or other physical data stores that can be accessed through IBM Cognos8. Application Tier Components use data source connections to access data sources.

What is bitmap index?

A bitmap for each key value replaces a list of rowids. Bitmap index more efficient for data warehousing because low cardinality, low updates, very efficient for where class.

How can i schedule reports in cognos?

By using Cognos Schedular, one can schedule the running reports in Impromptu to execute and save it in desired format.

By using Cognos MACRO script language the reports can be executed and distributed to recipients by using mail applications.

Compiled Cognos MACROs can be scheduled using Cognos Schedular.

Give me any example of semi and non additive measures?

Semi-Additive: Semi-additive facts are facts that can be summed up for some of the dimensions in the fact table, but not the others. Non-Additive: Non-additive facts are facts that cannot be summed up for any of the dimensions present in the fact table. Current Balance and Profit Margin are the facts.Current Balance is a semi-additive fact, as it makes sense to add them up for all accounts (what’s the total current balance for all accounts in the bank?), but it does not make sense to add them up through time (adding up all current balances for a given account for each day of the month does not give us any useful information). Profit Margin is a non-additive fact, for it does not make sense to add them up for the account level or the day level.

What is OLAP?

OLAP stands for On Line Analytical Processing, a series of protocols used mainly for business reporting.

What is metric store database?

A metric store database is a special case of a query database. A metric storedatabase is used to store the information associated with metrics that appear in scorecards, including targets performance metrics , thresholds , embership in sorecards links to related reports.


Popular posts from this blog

TOP Agile Testing Interview Questions and Answers

Latest Agile Testing Interview Questions and Answers

Most Asked ADO.NET Interview Questions and Answers