Interview Questions

What are the Ways to Import Data into Catalog?

Create a catalog with .cat file...

Report studio has two SQL tabs one native SQL and another one cognos SQL which one is get more preference? which one we need to consider?

Cognos sql

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.