Interview Qustions

What is exact catalog size?

There is no limit for catalog size. It may be 3MB Or 4MB.

Give me some examples for Lifecycle reporting, I mean which lifecycle we will use for reporting?

There is no specific reporting lifecycle. We can generate the reports from data warehouse/data marts or we can generate the reports directly from OLTP systems.What I mean generating reports from OLTP systems is loading data into one system and generating the reports. But this is not recommended. This will depends on the business.

1) Generating reports from the OLAP interface system retrieving the data from the data warehouse to generating forms and reports.

2) They can use Business intelligence project life cycle.

HOW MANY LEVELS CAN BE USED IN DRILL THROUGH REPORTS?

Two levels summary and detail.

Where u can save the Report net documentation in our local system?

Whenever we Install Cognos Server we get it documentation alone otherwise we can store it in Deployment Folder of Cognos

What is model and how to create model and how to test model?

Create a Model In framework Manager and then publish it, make sure that Model meets the requirements, don't overload the model with unwanted query items

Model is nothing but a project. And the project will be created by framework manager in which we can extract the metadata from the various operational sources... we will test the model by using the TOAD

Model contains meta data which is related to business reporting Information. We import this data from the data base. Using this metadata we are creating Packages, Publishing packages, This metadata contains query subjects and namespaces.........

How to crate cubes in transformer ?

Cube can be created by using different data sources. Data sources: iqd, tex file Cube creation by using iqd data sources.
1) These iqd sources are coming from impromptu

Interview Questions

How u burst the reports? if u r bursted reports is not reached to destination how u identify???When You Import data into catalog You have complex columns names. How do you change the Name of those columns?

First you have to click on column header which you have to change. Then in property pane you will found name option. Then change column name.

How to create measures and Dimensions?

By using the Framework Manager we can create measures and dimensions according to our business needs.

How to pass parameter value into html design page?

(That is YOU Create a html page and use that page in your cognos 8 report header.take my question is how to use parameter value in the html page .)

By writing the JavaScript code in the html item, we can insert the parameter values. Here is the URL to use to call report from java The following URL will work. Please note that prompt names are case sensitive and we need to prefix 'p_' to the defined prompt names. Although this passes the prompt values, it doesn’t suppress the prompt page.

So, in order to achieve that we include an additional expression (&run.prompt=false) http:///cognos8/cgi-bin/cognos.cgi?b_action=xts.run&m=portal/report-viewer.xts&ui.action=run&ui.object=%2fcontent%2fpackage%5b%40name%3d%27(optional)%27%5d%2freport%5b%40name%3d%27%27%5d&run.prompt=false&p_p_year=2007&p_p_month=09
Here p_year and p_month are the parameter name for prompt

WHAT IS THE DIFFERENCE BETWEEN LIST REPORT AND CROSSTAB REPORT?

List report show data in rows and columns versus a cross tab report show data in grids with dimension in rows and columns and measures in cells or in the intersection points.

List Report and Cross tab report both contains rows and columns but difference is list report is a detail report for analysis whereas cross tab report is the intersection of data or summarized data for analysis.