GeekInterview.com
Series: Subject: Topic:

Cognos FAQ

Showing Questions 1 - 20 of 92 Questions
First | Prev | | Next | Last Page
Sort by: 
 | 

Scenario of determinents

Asked By: sreenu007 | Asked On: Jun 20th, 2010

What is scenario of determinents?

Answered by: Sreenivasulu pokuru on: Apr 8th, 2013

Determinants are nothing but a need two joins between two query items at lowest granularity of data.Determinants are used for avoiding double counting results in Framework manager.

Answered by: Vijay on: Apr 25th, 2012

Determinants are used when we need to join tables with different granularity. Determinants are generally used to avoid double counting.

How to use join in cognos(in tabular sets)?Is the union concept is different in cognos? Y should it contain the same columns in both the tabular sets?

Asked By: vishnukumar | Asked On: Jun 1st, 2007

Answered by: shailendra32 on: May 26th, 2012

Join concept is same in cognos.Union concept is also same in cognos.
Since you are doing union of two tables so it will need same kind of columns in order and number this is similar to SQL.

Metadata

Asked By: abcd132881 | Asked On: Jul 23rd, 2009

What is use of metadata?

Answered by: shailendra32 on: May 26th, 2012

MetaDeta - Is the raw data that we model as per our business requirement. Thats why we do modelling of the data (Tables and joins) in frame work.

Answered by: karthi on: May 22nd, 2012

Allowing the user to search for the existing data and avoid the data duplication.

Report performance tuning

Asked By: abcd132881 | Asked On: Jul 23rd, 2009

How we will tune reports to have better performance?

Answered by: shailendra32 on: May 26th, 2012

There are few points - 1) If you need one parameter in your report then use equal to (=) in place of in. 2) In Framework manager -> Governor -> allow usage of local cache. 3) In Report Studio -> Quer...

Answered by: balajishriram on: Aug 5th, 2011

We can Improve the performance of reports in Report Studio with the help of following points : 1. We should create indexes on tables 2. We should avoid using FULL outer joins if possible.... 3. We sh...

Framewok manager dimensions

Asked By: sreenu007 | Asked On: Jun 20th, 2010

How many types of dimensions in framework manager? Which dimension are used in project and who decide that?

Answered by: shailendra32 on: May 26th, 2012

Regular dimension and Measure dimension are two dimension.Regular dimension is used in dimensional modelling of Relational data.It generally gives drill up drill down facility of OLAP to relational data.Generally Business analyst or Data Modeller experts decide this.

Answered by: biuser on: Aug 5th, 2011

Regular dimensions and measure dimensions.

How to create standalone and embedded filters in cognos framework manager?

Asked By: kadarla | Asked On: Dec 4th, 2011

Answered by: shailendra32 on: May 26th, 2012

Framework Manager supports stand-alone filters and embedded filters. Use a stand-alone filter when you want to reuse the expression. You can add a stand-alone filter to one or more dimensions or ...

Framework manager dimensions

Asked By: srikala123 | Asked On: Sep 17th, 2009

How to create regular and measure dimensions? How we will use these dimensions in the report?

Answered by: Lokesh M on: Dec 9th, 2011

A regular dimension organizes the information. It is stored in a hierarchy, from the highest level of granularity to the lowest. It usually has multiple levels. Each level requires a key and a captio...

Measure dimension

Asked By: Sandhya Madhu | Asked On: Jun 10th, 2009

What is measure dimension?

Answered by: Lokesh M on: Dec 8th, 2011

A measure dimension is nothing but a collection of facts.
A measure dimension can be created for one or more query subjects provided they have a valid relationship between them.

Deployment process

Asked By: gangireddy_j | Asked On: Jul 30th, 2010

What is procedure of deployment in cognos installation?

Answered by: Jimmy Zorald on: Nov 20th, 2011

After completing the preceding configuration procedures, you can deploy IBM Cognos Now! on the application server. Start the IBM WebSphere application server, if it is not currently running, and open...

Answered by: Namrata Gade on: Aug 13th, 2011

1. Copy contents of attached notepad file i.e. XML code of the report. 2. Launch Report studio, select package Package Name. 3. Open Report studio as a blank report. 4. In Report Studio, go to Tools -...

Bubble charts

Asked By: mahicatchme | Asked On: Jan 5th, 2010

What is bubble chart? Give an example for the usage of bubble chart?

Answered by: Ravi on: Aug 5th, 2011

A point chart that is used for x-y-z analysis.

Recursive relationship

Asked By: Shwethadeepu | Asked On: Feb 11th, 2010

What is a recursive relationship?

Answered by: ravi on: Aug 5th, 2011

Relationship existing between the columns of the table itself.
Employee having Manager id and employee is manger - details in the same table.

Alternative color rows

Asked By: vannur_basha | Asked On: Mar 29th, 2010

How to add 2 different colors for alternative rows in a report?

Answered by: santhosh243 on: Jan 12th, 2011

You must use mod function along with style variable to set the alternative
colors in rows.

First do a mod function for row number.

Then create a style variable with two values.

Apply the conditional style for even and odd row numbers.

That is it done.


by,

Santhosh


Report scheduling

Asked By: raghudu | Asked On: Aug 12th, 2009

How do you schedule reports in cognos?

Answered by: santhosh243 on: Jan 12th, 2011

We can do by setting schedule in individual report properties or can be done using event studio.

Cognos iqd

Asked By: ravimantur | Asked On: Jun 12th, 2009

How to create a iqd in cognos? Which is tool used?

Answered by: sravan.job on: Dec 25th, 2010

IQD is an SQL statement which is generated by Impromptu

Framework manager properties

Asked By: srikala123 | Asked On: Sep 17th, 2009

Explain the limited local and database only properties in framework manager? Why do we use these properties?

Answered by: itgowrishankar on: Dec 8th, 2010

"Limited locally" and "Database only", those are called as query processing methods. Database only:  All queries are processed by Database instead of Cognos. If it is failed&n...

Cognos dashboards

Asked By: kbonela | Asked On: Jul 23rd, 2010

How to create dashboards in cognos

Answered by: kishore.g on: Sep 11th, 2010

select "file" menu click on newselect "blank" click okfrom "tool box" drag the table drop on blank layoutset the no.of coloumns: 2set the no.of rows:   2select show ...

Master detail report

Asked By: raviws314 | Asked On: Jul 23rd, 2010

What is advantange and disadvantage of master detail report?

Answered by: kishore.g on: Sep 11th, 2010

The main advantage of master detailed report is two list reports can be merged using this report and there should be a common query item between the two list reports.

Create new report

Asked By: jenibala | Asked On: May 13th, 2008

How can we create a new report using cognos impromptu?

Answered by: sidney on: Jul 27th, 2010

Open Cognos Impromptu, select file>new
Bingo

You'll have to select the type of report you want to create list, cross tab etc

Report page breaks

Asked By: srikala123 | Asked On: Sep 17th, 2009

How page breaks work in the report?

Answered by: sreenu007 on: Jun 3rd, 2010

In Cognos8 version we have one option directly.see for eg if you break on country page breaks, first select that column and select structure tab, in that we have one option call 'page break'. select t...

First | Prev | | Next | Last Page

 

 

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Ads

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.