Cognos FAQ

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.

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

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.

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.

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

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...

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...

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.

Regular dimensions and measure dimensions.

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 ...

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...

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.

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...

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 -...

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

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

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

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

IQD is an SQL statement which is generated by Impromptu

"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...

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 ...

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.

Open Cognos Impromptu, select file>new
Bingo

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

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...