- World's Largest Collection of Interview Questions & Answers, FAQs, queries, sample papers, exam papers, dumps, what, why, how, where, when questions
Our Services
Get 9,000 Interview Questions & Answers in an eBook.

Get it now !!
Send your Resume to 6000 Companies
Cognos Interview Questions & Answers - Learning Mode

Cognos Interview Questions & Answers - Learning Mode

Cognos is IBM's business intelligence (BI) and performance management software suite. The software is designed to enable business users without technical knowledge to extract corporate data, analyze it and assemble reports. Cognos (Cognos Incorporated) was an Ottawa, Ontario-based company making business intelligence (BI) and performance management (PM) software. Founded in 1969, at its peak Cognos employed almost 3,500 people and served more than 23,000 customers in over 135 countries until being acquired by IBM on January 31, 2008.

Try Cognos Interview Questions & Answers - Exam Mode

1 2 3 Next

Sort By : Latest First | Oldest First | By Rating

Cognos Interview Questions & Answers - Learning Mode
Try Cognos Interview Questions & Answers - Exam Mode
Question: 1.what is difference between PAGE BREAK and Section Report?

2.what is Main Advantage Datawarehousing over Oracle?

Answer: Section-section is eliminate the duplicate recod.but report looking separate bluck.
setpagebreak means to display the reports in onepage. eg. suppose u create a list report ordermethod,orderyear,revenu
when u create section on will eliminate the duplicate record.but when u apply the set display in fax reports in onepage,email reports in another page.this in cognos 8 querystudio.
but in report studio u can do using propetispan.its right or wr Source:
Question: How to publish powerplay reports using PPES?
Explain the steps??

Answer: No answer available currently.
Question: How can create users and permissions in cognos?

Answer: In impromptu menu go to Catlog->User profiles -> userclass tab -> click on Creator ->u can give there folder access,table access,filters,Governor etc
Question: What you mean by Drill across and what is the difference between drill through,drill across?

Answer: Drill across means when you are moving from one report to another report like country in one report and States in another Report whereas if the report is using same report from moving from country to state. In other when you are moving details level if you are using the different report it is drill across and if you are using same report it is drill through. Source:
Question: What is Zero-foot print?
What are the other methods working as deployment functionality?

Answer: Cognos offers Portal Services that allow organizations to easily manage and display Cognos business intelligence, planning, and scorecarding in your existing enterprise information portals. Including Cognos reports, analysis, dashboards, scorecards, and other capabilities drives higher returns in your information and portal investments.

Cognos portals offer:

Zero Footprint: Cognos portals have no footprint on the user's desktop. Anyone inside or outside the organization with a Source:
Question: What is drill down and slicing and dicing whats the difference between them.

Answer: Drilling lets you quickly move from one level of detail to another to explore different aspects of your business. Drilling down moves you down in the hierarchy; drilling up moves you up in the hierarchy.

Slicing and Dicing

While you can drill to look at information at any level, you can slice and dice to select the exact information you want in your report.

Question: What is the difference between filter and condition? clear definition?

Answer: No answer available currently.
Question: Please explain the different stages in creating a report in cognos report net

Answer: Before creating any report in report net make sure you are have the planning information you need.

Creating a report involves following steps:

Specifying a package
Choose a package through cognos connection>report studio>Select a module from the list.
Choosing a report template
Create a empty report first,click one of the predefined report templates ,click OK.
Adding query items
In the insertable objects plane,select the query item that you want to add to repor Source:
Question: What is model and say about process how to create model and how to test model

Answer: Model Definition

Model in PowerPlay Transformer is combiantion of five windows- Dimension Map,Data Source, Measures,Power cube,Sign On. Models specify the data sources and then defining the dimensions, levels,and measures.They may also contain dimension views, user classes, user class views, and other authentication-related information.
The information for a model is stored in a model file, with the extension .pyi (binary, means platform depentent) or .mdl (text,platform independent). Source:
Question: What is Cognos Powerhouse and what is it used for?

Answer: Cognos Powerhouse is High-Productivity Application Development Solutions equips you with high-productivity development environments for creating your data-driven business solutions faster,whether for Web-based, client/server, or traditional terminal-based access. PowerHouse has gained a worldwide reputation for productivity, reliability, performance, and flexibility. Source:
Question: How can i schedule reports in cognos

Answer: By using Cognos Schedular, one can schedule the running reports in Impromptu to execute and save it in desired format.

By using Cognos MACRO script language the reports can be executed and distributed to recipients by using mail applications.

Compiled Cognos MACROs can be scheduled using Cognos Schedular.
Question: What are the limitations of cognos reportnet?
What are the enhancements in reportnet ?








Question: What are products of cognos

Answer: Cognos 6.6 7.0,7.3(PowerPlay, Impromptu)--ReportNet1.0,1.1mr1, 1.1mr22---ReportNet 8.0(latest)IWR is use by Impromptu to publish reports, PPES is used by PP, Cognos Connection is used by repornet. there are many other tools but these are the main. Source:
Question: use this query i am retriving all years OCt data from 01-10-2004 to 30-10-2007

i need to restrect this query to current date and current year

[gosales_goretailers].[Orders].[Order month]between 01 and to_number(to_char(current_date,'MM'))and [gosales_goretailers].[Orders].[Order month]=to_number(to_char(current_date,'MM'))
pass polar ID

Answer: You have a function called 'extract' in cognos.

Ex:- extract(month,the dte field). by giving like this you will get month. so you can keep a filter to restrict the rows only for october.
Question: What are the different ways of adding data in Transformer?

Answer: Steps1. Right-click in the Data Sources list of your model and select Insert Data Source.2. In the New Data Source wizard, enter the name of the data source in the Data Source Name box.3. In the Source Type box, select the type of data source that corresponds to your source type and click Next.4. In the Local Data File box, enter the name of the source file.5. Enter the remaining parameters appropriate to your selected source, and then click Finish.Note: Depending on the type of data source, Tra Source:
Question: How do add dynamic titles in PP?

Answer: PowerplayFrom format menu-->title, header & footer-->title-->insert report filename Source:
Question: Suppose you run a report with empty data , how will you inform the end user that it has no data ,while running the report in report studio?is it possible , if so how?

Answer: Add a list footer and a text messsage inside "No Data". create a booloean conditional variable "Test" with code "rownum()>0". Select the complete list footer and set Style Variable, if Yes, Box Type of the List footer should be set to "none". This should work...RD Source:
Question: What are the Ways to Import Data into Catalong?(2 ways)

Answer: one through Database optionother one though hotfile option Source:
Question: What Junk Dimension contains?

Answer: Problem Description<br><br>What are looping joins and how do you resolve them?<br><br>Solution Description<br><br>Looping joins could potentially return incorrect data.<br>An example of a looping join, <br><br>B -> C<br>A -> < > -> D<br>E -> F<br><br>When you select an item from table A and D, Impromptu will try to choose the shortest path, e.g. if A -> D existed, then this is the path Impromptu wi Source:
Question: what is meant by alternate drill down with ex?

Answer: Ans of Quest. 7 - Alternate drill down path means there will be two path to opt.For example- We will have time dimension now the client requirement is they want two type of year -one is claender year(Jan-Dec) and another is fiscal year(Apr-Mar).


1 2 3 Next

India News Network
Latest 20 Questions
Payment of time- barred debt is: (a) Valid (b) Void (c) Illegal (d) Voidable
Consideration is defined in the Indian Contract Act,1872 in: (a) Section 2(f) (b) Section 2(e) (c) Section 2(g) (d) Section 2(d)
Which of the following is not an exception to the rule, "No consideration, No contract": (a) Natural love and affection (b) Compensation for involuntary services (c) Completed gift (d) Agency
Consideration must move at the desire of: (a) The promisor (b) The promisee (c) The promisor or any other party (d) Both the promisor and the promisee
An offer which is open for acceptance over a period of time is: (a) Cross Offer (b) Counter Offer (c) Standing Offer (d) Implied Offer
Specific offer can be communicated to__________ (a) All the parties of contract (b) General public in universe (c) Specific person (d) None of the above
_________ amounts to rejection of the original offer. (a) Cross offer (b) Special offer (c) Standing offer (d) Counter offer
A advertises to sell his old car by advertising in a newspaper. This offer is caleed: (a) General Offer (b) Special Offer (c) Continuing Offer (d) None of the above
In case a counter offer is made, the original offer stands: (a) Rejected (b) Accepted automatically (c) Accepted subject to certain modifications and variations (d) None of the above
In case of unenforceable contract having some technical defect, parties (a) Can sue upon it (b) Cannot sue upon it (c) Should consider it to be illegal (d) None of the above
If entire specified goods is perished before entering into contract of sale, the contract is (a) Valid (b) Void (c) Voidable (d) Cancelled
______________ contracts are also caled contracts with executed consideration. (a) Unilateral (b) Completed (c) Bilateral (d) Executory
A offers B to supply books @ Rs 100 each but B accepts the same with condition of 10% discount. This is a case of (a) Counter Offer (b) Cross Offer (c) Specific Offer (d) General Offer
_____________ is a game of chance. (a) Conditional Contract (b) Contingent Contract (c) Wagering Contract (d) Quasi Contract
There is no binding contract in case of _______ as one's offer cannot be constructed as acceptance (a) Cross Offer (b) Standing Offer (c) Counter Offer (d) Special Offer
An offer is made with an intention to have negotiation from other party. This type of offer is: (a) Invitation to offer (b) Valid offer (c) Voidable (d) None of the above
When an offer is made to the world at large, it is ____________ offer. (a) Counter (b) Special (c) General (d) None of the above
Implied contract even if not in writing or express words is perfectly _______________ if all the conditions are satisfied:- (a) Void (b) Voidable (c) Valid (d) Illegal
A specific offer can be accepted by ___________. (a) Any person (b) Any friend to offeror (c) The person to whom it is made (d) Any friend of offeree
An agreement toput a fire on a person's car is a ______: (a) Legal (b) Voidable (c) Valid (d) Illegal
Cache = 0.014648 Seconds