Interview Questions

How to perform single sign on in Cognos by using URL?

In cognos configuration under authentication allow anonymous access should be false.In cgi-bin properties (under iis) the enable anonymous access should be false.

What is loop in framework manager?

Loop is closed path in reportnet it called as ambiguous relationship. That means a query subject contains multiple paths to retrieve the data. It is an exception to resolve to create a shortcut on that query subject otherwise it displays wrong results in reports and performance is degrades.

An undefined join between two tables is known as loop.To resolve loop delete the joins, if these joins are necessary then we have to create shortcuts nothing but alias tables. Place the joins in alias tables.

A LOOP IS A CLOSED PATH IN FRAME WORK MANAGER DUE TO JOINS.

WE ILL RESOLVED IT BY CREATING ALLIAS AND CREATING SHORT CUTS.

How you migrate reports to cognos 8 from previous versions?

Migration means report net reports to cognos8.rn Upgrade .bat/rs upgrade .sh is a standalone utility that upgrades a single report specification at a time out side of the cognos.

What are the filters in Framework Manager and Report Studio?

Filters in framework manager are

1. Standalone filters

2. Embedded filters

Report studio Filters are

1. Detail filters

2. Summary filters

How u migrate the reports from impromptu to reportnet???

It's possible to to migrate impromptu reports to reportnet using the migration tool(own by reportnet 1.1)Using this syntax: migratetocrn
HERE crn----Cognos RoportNet

What is IQD? What is contained in IQD?

IQD stands for Impromptu query definition. It is report save extension with .iqd it is use for creating a cube in power play transformer

IQD is Impromptu Query Definition. It contains the SQL query to display the data from the database and SQL query is automatically created based on the columns selected from database.

IQD MEANS IMPROMPTU QUERY DEFFINITION,IT CONTAINS MULTIDIMENTIONAL DATA STRUCTURE WITH ARRAY FORMAT FOR CREATING CUBES.

THIS REPORTS CAN BE SAVED WITH .IQD FILES.