Cognos Cognos Interview Questions

 Cognos Interview Questions
  
   How to create users and permissions in cognos ?

• Users and Permissions can be given in Access manager - Administration.

• Individual users can be created using their names or their Ids (if any) in Access manager and then be given permissions.

• This tool is loaded when you install Cognos 7.x in your machine.

• In content manager--we have one component called cognos process manager, using process manager we can integrate with third party tools like LDAP or NTLM. we cannot create users in report net directly. in real time we can use LDAP.

   What is the difference between macros and prompt ?

• Macro is set of instructions to run report.

• Prompt is just like a dialog box which will ask user to select/enter the information what he needs.

• A MACRO IS RUN TIME PARAMETER WHICH CAN BE PLACED IN ANY PART OF SQL SELECT STATEMENT,WHERE AS PROMPT IS USED TO GIVE CONDITIONS.

   What is Cognos Visualizer and Cognos Scripting ?

• Cognos scripting is like a language, with this we will create macros, Macro is a set of instructions to run a report.
• Cognos Visualizer is a tool for creating charts(bar, pie, histogram......) & maps using data sources (datafiles like mdc,iqd,csv,excel etc).

    What is query subject?

A query subject is the basic building block in Framework Manager. A query subject is a set of query items that have an inherent relationship.

   What are the Ways to Import Data into Catalog ?

Create a catalog with .cat file...

   When we save a report in report studio with what extn it save ?

• It saves as .XML

• It will save as .CRR

• When we save the report it save our specifications like u can choose(in report studio RUN MENU by clinking down icon) HTML,XML,CSV,OR PDF Format if u save the report HTML u can also run report different format as u like or different language also Depends on the format on which the report is being run.

• By default its .html format. The report can be made to run in any formats like HTML, PDF, XLS, CSV ( Comma separated format) and XML and based on that, report can be saved in either .html, .pdf, .xls, .csv or .xml

• When you r viewing the report in the package is shown with extension .crr

  How can I convert a list report/Cross tab Report in Cognos EP series into a bar chart or pie chart etc.?

This can be done in Impromptu administrator

   How many numbers of cubes can we create on a single model? How can we navigate between those cubes ?

Using a single Model, we can create as many number of cubes u want. By using the dimension views...etc. Regarding the navigation, when we save cubes, these act as separator multidimensional databases. There wont be any relations. Navigate means opening the cubes separately.

  What is the difference between drill down and drill through ?

Drill down means it will navigate from detail information to summary level information within report. Drill through means it will navigate from summary to detail from report to report.

  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

   What are the special features in COGNOS REPORT NET ?

CRN is web based tool. So it will very useful to view the reports very easily. So that they preferred CRN

   How you create IQD In Report Net Framework ?

Open framework manager click on any query subject and go Open the properties dialogue box and u can observe the EXTERNALIZE METHOD u change the iqd.

   What is Snapshot ?

A Snapshot is a Permanent Local Copy Of the Report.Snapshot is Static Data Source it is saved with .imr File it is suitable for Disconnected Network....

   What is log in cognos ?

While creating reports or creating models logs have all information till session closed.