CoolInterview.com - 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
COOLINTERVIEW.COM DATA WAREHOUSING INTERVIEW QUESTIONS COGNOS INTERVIEW QUESTIONS 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: 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: CoolInterview.com
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.
Source: CoolInterview.com
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: CoolInterview.com
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
Source: CoolInterview.com
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: CoolInterview.com
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).



Source: CoolInterview.com
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: CoolInterview.com
Question: How u can connect different database in reportnet?
wht is the extension file to save a template?
give example for drillthrough and masterdetail reports in CRM domain?



Answer: Template?extension is .imt Source: CoolInterview.com
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 ordermethod.it will eliminate the duplicate record.but when u apply the set pagebreakc.report display in onepage.like 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: CoolInterview.com
Question: How create measures and Demensions?



Answer: You can create measure once you import all the data into the data source.You can create measures and dimensions by draging the required source from datasource into dimension map and measure tab.(need to find scope of measures for all the dimensions)


Source: CoolInterview.com
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: CoolInterview.com
Question: What is IQD?What is contained in IQD? How you create IQD In ReportNet FrameWork?



Answer: 1. Create a new namespace.<give it a name, say, IQDReportNet>

2. Create a new query subject inside IQDReportNet.

3.In the query subject definition window, pull in all the data you need.

4. after creating, click on the new query subject, from the properties pane, select "IQD" from the drop down menu of externalizeMethod.

DONE.

to Publish. u need to create a package.

1. create a new package. a WIZARD will open.

2. Name the new Package; select Source: CoolInterview.com
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.


Source: CoolInterview.com
Question: What are the Ways to Import Data into Catalong?(2 ways)



Answer: one through Database optionother one though hotfile option Source: CoolInterview.com
Question: What is the difference between filter and condition? clear definition?

Answer: No answer available currently.
Question: How you drill from powerPLay to Impromptu?Explain all Steps.



Answer: goto tranformer,

build the cube

right click on the cube and open properties

go to drill through tab and select your report from that browse option
Source: CoolInterview.com
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.
Source: CoolInterview.com
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: CoolInterview.com
Question: What are the limitations of cognos reportnet?
What are the enhancements in reportnet ?



Answer: ADVANTAGES:

1)PURELY WEB BASED REPORTING TOOL

2)WE CAN CREATE MULTILINGUAL REPORTS

3)IT CAN SUPPORT ANY TYPE OF OPERATING SYSTEM & DATA BASE

4)WE CAN CREATE SINGLE MODEL IN FRAMEWORK MANAGER COMING FROM MULTIPLE DATA SOURCES

DISADVANTAGES:

1)WE CAN'T DRILL DOWN AND DRILL UP

2)IT CAN'T SUPPORT MULTI DIMENSIONAL ANALYSIS
Source: CoolInterview.com

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