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.
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
- Think about the intended reader. When writing anything for anyone to read, you must first consider who that audience is going to be. ...
- Identify the key takeaways. ...
- Outline the entire report before you actually write it. ...
- Keep it concise. ...
- 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
- Database layer
- Logical Layer
- 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.