Corporate Training
Request Demo
Click me
Menu
Let's Talk
Request Demo

IBM Cognos Cube Interview Questions and Answers

by Sachin, on Jul 12, 2022 11:03:46 PM

IBM Cognos Cube Interview Questions and Answers

Q1. What is DTM in Cognos?

Ans

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.

Q2. What are the three general categories of reporting in Cognos?

Ans

  • List
  • Crosstab
  • Chart Reports

Q3. What are all the different types of prompt in Cognos?

Ans 

A Text Box Prompt is a prompt control that allows you to type in a value. A Value Prompt is a prompt control that allows you to select one or more values from a list. A Select & Search Prompt is an advanced prompt control that allows you to search for values.
 

Q4. What are the advantages of Cognos analytics Mcq?

Ans

  • Value prompt.
  • Text Prompt.
  • Date prompt.
  • Time prompt.
  • Date and time prompt.

Q5. What is Cognos software used for?

Ans 

Everyone in your organization can use IBM Cognos BI to view or create business reports, analyze data, and monitor events and metrics so that they can make effective business decisions. IBM Cognos BI integrates the following business intelligence activities in one Web-based solution.
 
IBM Cognos Cube Online Training
 

Q6. What is Cognos architecture?

Ans 

IBM Cognos is a solution designed to address the challenges of enterprise-scale reporting, analysis, scorecarding, and event notification. The web-based IBM Cognos architecture was designed for scalability, availability, and openness.
 

Q7. What type of analysis is Cognos?

Ans 

Cognos Analysis Studio uses sets, which are collections of similar items. You manipulate items by applying actions to sets. You can sort, filter, and nest sets. You can also save custom sets and view subtotals for your sets.
 

Q8. What are Cognos parameters?

Ans 

Parameters in Cognos are based on prompts whereby a prompt is created that has an associated parameter value. This parameter value can be used in the filter in a query or it can be displayed on a report page. Prompt controls provide the user interface in which the questions are asked.
 

Q9. What is cascading prompt in Cognos?

Ans

Cascading prompts are typically used to improve the user experience when dealing with related data items consumed by the prompt page. The cascade functionality limits the displayed prompt values based on the user's selection within the parent prompt.

Q10. What is active report Cognos?

Ans 

IBM Cognos Active Report is a report output type that provides a highly interactive and easy-to-use managed report. Active reports are built for business users, allowing them to explore their data and derive additional insight. Active reports make business intelligence easier for the casual user.
 

Q11. What is Cognos Controller?

Ans

IBM Cognos Controller is financial consolidation software that supports the complete close, consolidate and report process, all in one solution managed by finance and accounting.

Q12. What is three tier architecture in IBM Cognos?

Ans 

IBM Cognos Business Intelligence has a multitiered architecture. For description purposes, it can be separated into three tiers: Web server, applications, and data. The tiers are based on business function, and are typically separated by network firewalls. IBM Cognos BI user interfaces sit above the tiers.
 

Q13. What is a Cognos server?

Ans

An IBM Cognos BI server runs requests, such as reports, analyses, and queries, that are forwarded by a gateway. An IBM Cognos BI server also renders the Cognos Connection interface. The application tier is made up of three main server components: IBM Cognos Dispatcher. IBM Cognos Report Server.

Q14. What are the 5 steps in report writing?

Ans

  1. Think about the intended reader. When writing anything for anyone to read, you must first consider who that audience is going to be. ...
  2.  Identify the key takeaways. ...
  3.  Outline the entire report before you actually write it. ...
  4.  Keep it concise. ...
  5.  Make it digestible.

Q15. What is parameter map in Cognos?

Ans

A parameter map is a collection of Keys and Values that may be used to replace values during the execution of the query. Manually or depending on query elements, we may generate parameter mappings. This article will walk you through the process of creating parameter mappings in Cognos framework manager.

Q16. What is Cognos dashboard?

Ans

IBM Cognos Dashboard Embedded gives developers a way to embed an intuitive, drag-and-drop visualization tool, providing end users the ability to explore data and create visualizations that answer the unique questions important to your business.

Q17. What are all the different types of prompt in Cognos?

Ans 

A Text Box Prompt is a prompt control that allows you to type in a value. A Value Prompt is a prompt control that allows you to select one or more values from a list. A Select & Search Prompt is an advanced prompt control that allows you to search for values.
 

Q18. What is cascading prompt in Cognos?

Ans

Cascading prompts are typically used to improve the user experience when dealing with related data items consumed by the prompt page. The cascade functionality limits the displayed prompt values based on the user's selection within the parent prompt.

Q19. What is complex report in Cognos?

Ans 

Complex reports is a when we have to retieve the metadata from different datasources where located at different places, and design the reports using different report types(list, crosstab,graphs & repetars) more times in single report.
 

Q20. What are prompts functions?

Ans 

Prompts act as questions that help users to customize the information in a report to suit their own needs.
 

Q21. What is the Framework Manager?

Ans

Framework Manager is a tool that allows you to make data sources known for use within the various Cognos suites and allows you to add additional logic and details. Within a logical Cognos architecture, a Framework Manager model contains the logic and information required for one of the Cognos tools to use a data source.

Q22. What are the layers available in the Framework Manager Model?

Ans

  1. Database layer
  2. Logical Layer
  3. Dimensional layer

Q23. What is IBM Predictive Maintenance and Quality?

Ans

With IBM Predictive Maintenance and Quality, you can monitor, analyze, and report on information that is gathered from devices. In addition, recommendations for actions can be generated by Predictive Maintenance and Quality.

  • IBM Predictive Maintenance and Quality is an integrated solution that you can use to perform the following tasks:
  • Predict the failure of an instrumented asset so that you can prevent costly unexpected downtime.
  • Make adjustments to predictive maintenance schedules and tasks to reduce repair costs and minimize downtime.
  • Quickly mine maintenance logs to determine the most effective repair procedures and maintenance cycles.
  • Identify the root cause of asset failure faster so that you can take corrective actions.
  • Identify quality and reliability issues definitively and
  • in a timely way.
Topics:Interview Questions with Answers

Comments

Subscribe

Top Courses in Python

Top Courses in Python

We help you to choose the right Python career Path at myTectra. Here are the top courses in Python one can select. Learn More →

aathirai cut mango pickle

More...