Top Cognos Interview Questions And Answers
1. Cognos Characteristics
| Criteria | Result |
| Ability to deploy charts | Bar, Pie, Line, Crosstabs, Funnel, Scatter, etc |
| Speed of data access | High performance access across all data sources |
| Data Export formats | Excel, HTML, PDF, CSV, XML |
2. Characterize Report thing?
It's only a question thing when it is intuitive into the work region.
3. Characterize question things?
It's predominantly utilized in Reporting and for BI Authors it is the most basic item from the system director. These have part of properties related with them and are available in inquiry subjects. They are like subsets of inquiry subjects.
4. Give the benefits of Cognos?
The benefits of Cognos are:
A) Planning
B) Analysis
C) Forecasting
D) Score checking
5. Name the sorts of report?
A) List report
B) Cross report
C) Blank report
D) Repeater report
E) Chart report
6. Characterize Cognos Reporting apparatus?
It's an announcing instrument of IBM which help us in detailing and investigation of various information from an information warehouse.Read this blog to discover why Business Intelligence apparatuses are basic to the present endeavors.
7. Name the kinds of passage?
There are three kinds of door:
A) CGI (Common Gateway Interface)
B) ISAPI (Internet Service Application Interface)
C) Tomcat
8. Characterize measurements?
It characterizes the structure of a solid shape. Any measurement should have in any event one key quality and different ascribes with the goal that it might characterize progressions.
9. Name the kinds of progressive systems?
There are two kinds of chains of command in Analysis Services:
A) One is Attribute progressions
B) Second is User characterized chains of command.
10. Characterize system director?
It's an improvement device which is utilized to make the end-client layer utilized by creators to construct their BI articles.
11. Characterize drill through?
It grants one to move from information at the base level in a 3D square to the information in the operational frameworks from which the shape was determined.
12. Name the three significant major topics which are in information distribution center?
A) Drilling Down
B) Drilling Across
C) Handling Time
13. Which security module utilized in Cognos?
Cognos Access Manager
14. Name the sorts of studio?
1) Metrics Studio
2) Report Studio
3) Event Studio
4) Query Studio
5) Analysis Studio
15. What are the underlying page parts of Cognos association?
1) The Studio Toolbar
2) The Utilities Toolbar
3) The Tab Navigator
16. Separate among brief and macros?
Brief
It gives an approach to do powerfully changes in the reports.
Full scale
It's a bunch of guidelines to run the report.
17. Characterize model?
It is a finished arrangement of question subjects and inquiry protests that are utilized for revealing.
18. Separate among independent and installed channel?
Independent Filter
It is utilized to reuse the expressionEmbedded Filter
To utilize the channel with just one measurement or question subject.
19. Characterize DTM
It changes the information got from the peruser support and it moves change to change on column by line premise and it is utilizes the change stores when important.
20. Would you be able to erase Cognos Namespace?
No
21. What are Fact Tables?
It is a table that contains summed up mathematical (realities) and chronicled information. It has an unfamiliar key – essential key connection with a measurement table.
22. Separate between actual layer and introduction layer?
Actual Layer
It gives the actual inquiry layer and is made up fundamentally of information source and put away method question subjects. It acts like an establishment for the introduction layer
Introduction Layer
The Presentation layer is made up principally of model inquiry subjects that you make.
23. Name the sorts of realities?
Added substance
Non Additive
Semi Additive
24. At what time default information source question subject will be made?
At the underlying metadata import activity, a default information source question subject is made for those each item you have select.
25. Name the kinds of Query subjects?
Default
Model
Put away
26. What is the best approach to confine the tables recovered by a question Solution?
By setting lead representatives we can limit the tables recovered by a question arrangement.
27. Characterize the term Business Intelligence?
BI is a general class of use projects and innovation utilized for inquiry, by which we can do the announcing and examining the business multi dimensionally.
28. Name the obligations of Cognos Administrator?
Making the Repository
Playing out the undertaking of reinforcement and recuperation of the Meta Data.
Tuning the workers.
Establishments and setups in disseminated network climate
Building up the client Administration
Organization
29. Name the segments which get introduced at the hour of establishment of Cognos Report Net Software?
Window Based
Electronic
30. Name the periods of Cognos report net work process?
The stages are:
Plan
Oversee
Model
Creator
Burn-through
31. Characterize crafted by Group and Roles?
It speaks to the assortment of clients that plays out the comparative assignment.
32. Characterize Package?
It is a holder for models, reports, etc. Modelers can make bundles in Framework Manager to distribute the models to the Report Net worker.
33. Name the kinds of channel in system supervisor?
Model and Query
34. What is Model Filter?
It is utilized to limit the information showed on the Report. Model channel are reusable.
35. Name the kinds of channel in the report studio?
Plain Grouped
36. Name the sorts of Tabular channel in the report studio?
Outline
Nitty gritty
37. Characterize affirmed measurement?
In the event that any measurement will be associated with numerous reality tables, at that point it is called affirmed measurement.
38. What are the means to import the two information sources in structure director?
It very well may be done in the Run Metadata Wizard.
Most importantly Go to Run Metadata Wizard–>Select another information base ( ex. assume SQL Server is pick in earlier endeavor, at that point you can pick Oracle as new information source). At the last import it.
39. Where the Determinants are utilized in Cognos structure director?
A question subject that carries on as a measurement has numerous degrees of granularity and it will be joined on the various arrangements of keys to truth information.
40. What is the best approach to create 3D square in system supervisor?
In the wake of making the IQD record from the structure director that IQD document will be utilized by the transformer to produce the solid shape.
41. What is the best approach to produce IQD document from structure supervisor?
Make a Query Subject
Utilizing properties sheet select externalize.
We have four choices in that select IQD
42. What is the contrast among static and dynamic conditions?
Static Condition
At whatever point you run the report the condition won't change.
Dynamic Condition
Condition which keep on change at whatever point you run the report.
43. Characterize Parameter Map?
It is a key worth pair utilized in making of restrictive Query Subjects. It sub arranges the qualities at the inquiry at runtime.
44. What is the significance of cleaning at the Project level?
As indicated by the prerequisites of the report determine the new things with the assistance of existing Query Items.
45. Characterize Slice and Dice?
An activity that permits one to choose a bit of the information of a reality based on determined qualities in one or a few measurements.
46. Name the kinds of SQL?
Cognos
Local
Pass-through
47. What are the upsides of utilizing Cognos SQL?
It can contain metadata from the numerous information sources.
It has less information base limitations
Give the office to cooperate all the more viably with Cognos applications.
48. What are the drawbacks of utilizing Cognos SQL?
You can't enter non standard sql.
49. What really an undertaking contains?
Models
Namespace
Information source
Boundary Map
Bundles
Organizer
Inquiry Subject
Inquiry Item
Relationship
50. How an undertaking does glances in structure director?
A task in the structure director looks as an envelope that contains a venture document (.cpf) and the particular XML records that characterize the undertaking
51. Name the kinds of OLAP's?
DOLAP
ROALP
MOLAP
HOLAPA
