This Cognos interview questions and answers have been created to help professionals clear the Cognos interview. Through this set of interview questions you will get to know what are the characteristics of Cognos, types of reports, framework manager, hierarchies, dimensions, query subjects, facts, Cognos administrator responsibilities and more.Learn Cognos from Intellipaat Cognos Certification training and fast-track your career.
It’s nothing but a query item when it is drag and drop into the work area.
It’s mainly used in Reporting and for BI Authors it is the most essential object from the framework manager. These have lot of properties associated with them and are present in query subjects. They are similar to subsets of query subjects.
The advantages of Cognos are: A) Planning B) Analysis C) Forecasting D) Score carding
A) List report B) Cross report C) Blank report D) Repeater report E) Chart report
It’s a reporting tool of IBM which help us in reporting and analysis of different data from a data warehouse.Read this blog to find out why Business Intelligence tools are critical to today’s enterprises.
There are three types of gateway: A) CGI (Common Gateway Interface) B) ISAPI (Internet Service Application Interface) C) Tomcat
It defines the structure of a cube. Any dimension must have at least one key attribute and other attributes so that it may define hierarchies.
There are two types of hierarchies in Analysis Services: A) One is Attribute hierarchies B) Second is User defined hierarchies.
It’s a development tool which is used to create the end-user layer used by authors to build their BI objects.
It permits one to move from data at the bottom level in a cube to the data in the operational systems from which the cube was derived.
A) Drilling Down B) Drilling Across C) Handling Time
Cognos Access Manager
1) Metrics Studio 2) Report Studio 3) Event Studio 4) Query Studio 5) Analysis Studio
1) The Studio Toolbar 2) The Utilities Toolbar 3) The Tab Navigator
Prompt It provides a way to do dynamically changes in the reports. Macro It’s a set of instructions to run the report.
It is a complete set of query subjects and query objects that are used for reporting.
It transforms the data received from the reader buffer and it moves transformation to transformation on row by row basis and it is uses the transformation caches when necessary.
It is a table that contains summarized numerical (facts) and historical data. It has a foreign key – primary key relation with a dimension table.
At the initial metadata import operation, a default data source query subject is created for those each object you have select.
By setting governors we can restrict the tables retrieved by a query solution.
BI is a broad category of application programs and technology used for query, by which we can do the reporting and analyzing the business multi dimensionally.
Learn more about Business Intelligence in this Cognos Training Videos.
Interested in taking the Cognos training? Well, we have the comprehensive industry-designed training course.
The phases are:
It represents the collection of users that performs the similar task.
It is a container for models, reports, and so on. Modelers can create packages in Framework Manager to publish the models to the Report Net server.
Model and Query
It is used to restrict the data displayed on the Report. Model filter are reusable.
If any dimension will be connected with multiple fact tables then it is called confirmed dimension.
It can be done in the Run Metadata Wizard. First of all Go to Run Metadata Wizard–>Select another database ( ex. suppose SQL Server is choose in prior attempt, then you can choose Oracle as new data source). At the last import it.
A query subject that behaves as a dimension has multiple levels of granularity and it will be joined on the different sets of keys to fact data.
After creating the IQD file from the framework manager that IQD file will be used by the transformer to generate the cube.
It is a key value pair used in creation of conditional Query Subjects. It sub situates the values at the query at runtime.
According to the requirements of the report derive the new items with the help of existing Query Items.
An operation that allows one to select a portion of the data of a fact on the basis of specified values in one or several dimensions.
You can’t enter non standard sql.
A project in the framework manager looks as a folder that contains a project file (.cpf) and the specific XML files that define the project
Cognos Certification can help you get ahead in your career. Get an in-depth Cognos Certification training now.
These QA help me a lot in interview preparations. Thanks
Very nice Cognos Interview Questions with detailed answers and examples.It’s helped me a lot. Thanks to Intellipaat team.
Your email address will not be published. Required fields are marked *
Solve : * 11 + 7 =