-
Stiched Query
What is meant by Stiched Query?
sandeep8000861
- Apr 29th, 2009
When a report fetches data from more than 1 data source, multiple queries are sent to each of the data sources. The result-sets, from these individual queries sent to multiple data sources, are sticth...
-
Cognos 8.3 Version New Features
What are the new features in Cognos 8.3 v?
maudgalyasa
- Apr 18th, 2009
It is a complete web based, dynamic, BI reporting solution from IBM, when we installing Cognos 8.3 and later two types of components get installed...i.e.,-> windows based components????? |-- Fram...
-
Burst Report
How to create burst report?
rajitha_2000
- May 21st, 2009
We have Burst option in a query studio while you have to create calculation how to divide the report and whom to get the the divide part of report. The same calculated Put it in Report Studio file ...
-
Framework Manager Dimensions
How to create Regular and measure dimensions? How we will use these dimensions in the report?
Lokesh M
- Dec 10th, 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...
-
Cognos Logs
Production Support: Where and how to check Cognos Logs?
-
Report Page Breaks
How page breaks work in the report?
sreenu007
- 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...
-
FrameWork Manager Properties
Explain the limited local and database only properties in Framework Manager? Why do we use these properties?
itgowrishankar
- 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...
-
Build A Cube
How to build a Cube in Cognos 8 using Framework Manger?
rajitha_2000
- May 21st, 2009
In Cognos 8 Framework Manager we have a regular dimension and Measure Dimension.Regular Dimension means categories which we have in Transformer.Measure Dimension holds the measure data like as tr...
-
Measure Dimension
What is Measure Dimension?
Lokesh M
- 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.
-
Repeater Object
What is the usage and procedure to create a repeater object?
freaky_priscilla
- Jul 21st, 2009
Repeater Object is used to repeat data in a particular order. Its mainly used for mailing lists. for example, say you want the Name, Address and telephone, one below the other in a 3X3 table. You...
-
Report Scheduling
How do you schedule reports in Cognos?
santhosh243
- Jan 12th, 2011
We can do by setting schedule in individual report properties or can be done using event studio.
-
Bubble Charts
What is Bubble Chart? Give an example for the usage of Bubble Chart?
-
Recursive Relationship
What is a Recursive Relationship?
-
Identify Duplicate Values in Report
How to identify duplicate values in a report?
-
Master Detail Report
What is advantange and disadvantage of Master Detail report?
kishore.g
- 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.
-
Cognos Dashboards
How to create Dashboards in Cognos
kishore.g
- 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 ...
-
What is the use of Generated Prompt?
what is the use of Generated Prompt? Can u give Complete information with scenario
Cognos
- Jul 17th, 2011
The prompt should be used when you are not sure of which type of prompt best suits for requirement.
shailendra32
- Jul 15th, 2011
Generated Prompt is a kind of prompt which automatically chooses & display any of the other prompt(Text prompt,value Prompt etc) at run time according to the data type of the data item added for the f...
-
Aggregation and roll-up aggregation
What is the difference between aggregation and roll up aggregation
shailendra32
- Jul 23rd, 2011
Aggregate Function Specifies the type of aggregation to apply. The Automatic setting means that the application groups or summarizes based on the data type. The Summarize setting means that any sett...
Cogbnos
- Jul 17th, 2011
Aggregate Function: This function specifies what type of Aggregation to be applied on a data item. The Aggregation can be of the types "Total", "Average", "Minimum", "Maximum" etc. Roll Up Aggregatio...
-
What is the best way to convert Crystal Reports to Cognos ?
FantaGuy
- Nov 20th, 2011
Crystal Reports and Cognos are fundamentally two different technologies with very different solutions. As per my knowledge, there are'nt any such ready tool to do the conversion. Though Cognos offers...
-
What is cardinality and what are the security types?
Aruna2008
- Dec 10th, 2011
Cardinality, a component of relationship. defines how query subjects are related. 1..1 one and only one record from this side of the relationship 1..n one or more records from one side of the relati...
Cognos Interview Questions
Ans