1. What do you mean by Cognos?
Cognos is an analytical platform mainly used in the development of AI-based business tool. This tool is used to perform data aggregations, web-based integration, and generate user-friendly reports. Cognos is an Ontario-based company that supports business intelligence and performance development software. This analytical tool also provides an option to export the user-friendly report in XML or PDF formats and also enables you to view the reports in XML format.
2. What Are The Types Of Prompt In Cognos?
- Value prompt
- Text Prompt
- Date prompt
- Time prompt
- Date and time prompt
3. What Are The Components Of Report Net?
- Framework manager
- Cognos connection
- Query Studio
- Report Studio
4. What Is Difference Between Content Store And Content Manager?
A content store is a data base which stores the meta data of the reports. But whereas a content manager is a service which is available in dispatcher. which it manages the security.
5. What Is Multi Dimension Analysis?
It is a technique to modify the data so that the data can be view at the different levels of details.
6. What Are The Responsibilities Of Cognos Administrator?
A Cognos Administrator is assigned with following responsibilities:
- Installations and configurations in distributed network environment.
- Creating the Repository (Content Store).
- Perform backup and recovery of Meta Data.
- Developing the user Administration.
- Tuning the servers.
- Deployment.
7. What is Dynamic cube in Cognos?
Dynamic cubes are the in-built memory that helps to load the data directly from relational data management sources that are well structured.
Features:
- This is one of the new feature developed in IBM Cognos BI 10.2
- This is a part of the IBM Cognos BI query stack
- The goal of the dynamic cube is to provide quick responses to reports and analyses on the large volumes of data.
- Enables high performance over terabytes of data.
8. Cognos dynamic cube consists of what element?
The Cognos dynamic cube consists of three major elements, they are:
- Cognos cube designer
- Cognos Dynamic cubes server
- Aggregate advisor (this is a part of Cognos dynamic query analyzer)
9. What is the package in Cognos?
IBM Cognos Package or Report. You can import query items, and the associated filters and prompts, from IBM Cognos packages and reports. You do this by choosing the Package or Report data source type and browsing and selecting from the available metadata.
10. What is Impromptu in Cognos?
Cognos Impromptu is an intuitive, user-friendly system that enables non-technical personnel to quickly and easily design and distribute business intelligence reports.
11. When to use Dynamic cubes in Cognos?
When you working with data warehouse with star or snowflake schema
A server with Adequate memory
A database consists of more than 25 million table rows.
12. Explain the Cognos cube designer modeling workflow?
The following are the important steps involved in modeling workflow:
- First select the database schema
- Import the amount of metadata required
- Defines the dimension and measurements
- Creates the dynamic cube
- Auto generates the Cognos cube
- Using the primary-foreign key relationships and populate the dimensions
- Deploys the options in Cognos cube designer with publishing option.
13. What is a Cognos Controller?
IBM Cognos Controller is part of an integrated Financial Close Management (FCM) solution, built on an efficient, purpose-built platform. It helps you deliver complete financial results, create financial and management reports, and provide the CFO with an enterprise view of key ratios and metrics.
14. What is Cognos Planning?
Flexible enterprise software for planning, budgeting, forecasting, and analysis. IBM Cognos Planning enables you to develop plans, budgets, and forecasts faster and more efficiently. Cognos Planning lets you create, compare, and evaluate business scenarios.
15. How to create users and permissions in cognos?
Users and Permissions can be given in Access manager – Administration. Individual users can be created using their names or their Ids (if any) in Access manager and then be given permissions. This tool is loaded when you install Cognos 7.x in your machine. In content manager–we have one component called cognos process manager, using process manager we can integrate with third party tools like LDAP or NTLM. we cannot create users in reportnet directly. In real time we can use LDAP.
16. What is the difference between macros and prompt?
Macro is set of instructions to run report. Prompt is just like a dialog box which will ask user to select/enter the information what he needs. A macro is run time parameter which can be placed in any part of sql select statement, whereas prompt is used to give conditions.
17. What are Cognos Visualizer and Cognos Scripting?
Cognos scripting is like a language, with this we will create macros, Macro is a set of instructions to run a report. Cognos Visualizer is a tool for creating charts & maps using datasources datafiles like mdc,iqd,csv,excel etc.
18. What is Report item?
Report item is defined as a query item which can be dragged and dropped into a work area.
19. Explain about the Aggregate Advisor?
The aggregate advisor is a type of performance optimization utility:
- This advisor is a part of the Dynamic query analyzer
- Suggests the database aggregate table columns and in-built memory functionalities
- Make use of the Cognos cube’s model and statistics
- Make use of the log files that are generated from the execution of reports
- Run during the off-peak and offers non-critical business hours.
20. What is Model Durability?
- You need to create the design language for the model which is not the same as the user who chooses the design for the English language.
- The design language consists of namespaces, query subjects, and query items that are published in a package initially.
- The structure of the published package namespace, query subjects, query items, and dimensions should not change over time.
- This structure is stored in a specification definition, along with the design language’s names.
- All the elements are stored in a model. XML and usage of reference ID which are set to true.
21. What is defined as catalog and types of catalogs in Cognos?
A catalog is defined as a file which contains information on Database tables and Impromptu users can create reports.
Following are the types of catalog used:
- Personal
- Distributed
- Shared
- Secured
22. Is it possible to join multiple Databases in a Catalog?
No, it is not possible to join multiple databases in a catalog and it can be achieved by Hotfile.
23. What is defined as Cognos Impromptu?
A Cognos Impromptu is set to be a tool which is used for the generation of business intelligence reports.
24. How do you create security features for Cognos cubes?
The below steps involved in the creation of security features in Cognos cubes such as:
- Starting or stopping of the cube
- Monitoring the cube
- Managing the cache memory
- Scheduling the refresh of the cache memory management.
25. What is the Framework manager?
Framework manager is a type of tool that allows users to make sure that data sources should be available for various Cognos suites. And also enables you to add additional logic details. Within the logical Cognos architecture environment, a framework model consists of logic and important information which are required to use of Cognos tools in the time of software development.
26. What are all the types of gateway used in Cognos?
Following is the list of gateway used in Cognos:
- Common Gateway Interface (CGI)
- Internet Service Application Interface (ISAPI)
- Tomcat Server
27. What are determinants?
Determinants are the advanced features first introduced in Cognos 8 offers control over granularity when aggregating the data. This is also used to ensure that repeating data and offers index information in a database. These determinants are used by the framework manager to determine levels in default hierarchy when auto-generates the regular dimensions from the data query subjects.
28. What is dimensional modeling for reports and analysis?
This dimensional model relational database constructs the classic query mode structures. The following activities are such:
- Offers a logical dimensional layer over the top of the relational model.
- Provides single measurements over multiple regular dimensions
- Enables drill-up and drill-down analysis in the model studios.
29. What is called Cognos powerplay?
Cognos powerplay is nothing but a multidimensional on-line analysis of data.
30. What are the types of studio present in Cognos?
There are five types of studio are :
- Query Studio
- Metrics Studio
- Analysis Studio
- Report Studio
- Event Studio
31. What are regular dimensions and explain?
The regular dimensions are used to create the model query subjects or database query subjects. This also helps to define the hierarchies to organize levels and drill paths. With the help of a regular dimension, users can specify the multiple hierarchies in a single dimension.
32. What are all the types of indexes in Cognos?
There are mainly four types indexed used in Cognos such as:
- Bitmap index type
- B-tree index type
- Function based Index type
- Reverse key and composite index type.
33. What is the use of Cognos decision stream?
Cognos decision stream is set to be a tool which is used for extracting, transforming the data from different data sources to target data source.
34. What is Metrics designer?
Metrics Designer is a tool which is used to model, deploy score cards and data loading procedures.
35. What is set to be Cognos configuration?
Cognos Configuration is a BI administrative tool which is used to define the behaviour of Cognos 8 version. This will manage configuration parameters.
36. What is the difference between Standard and Metrics folder?
- Standard Folder – This is a container of all folders and it is used for Organizational purposes. It acts like a local computer folder. It is yellow in color.
- Metrics Folder – This folder is used by Metrics studio to store metrics related information. Metrics folder will open up directly in Metrics studio and it is dark blue in color.
37. What is the use of Cognos scenario?
Cognos scenario is used to find the hidden trends and patterns of data.
38. Mention the types of studios present in Cognos?
There are five types of studios available in Cognos:
- Query studio
- Metrics studio
- Analysis studio
- Event studio
- Report studio.
39. What are all the types of the gateway used in Cognos?
The list of the gateway used in Cognos such as:
- Common gateway interface (CGI)
- Internet service Application Interface (ISPAI)
- Tomcat
40. Mention the types of hierarchies used in Cognos?
The two levels of hierarchies used in Cognos;
Attribute Hierarchies
User-defined hierarchies.
41. What is Bitmap Index?
A bitmap index is used for replacement of list of rowids for each key value. This index is mainly efficient for data warehousing as it has low cardinality and low updates.
42. What is a Datastore in Cognos?
A data store is nothing but a query database or a relational database or files that can be accessed through IBM Cognos.
43. What is called Cognos powerplay?
Cognos powerplay is nothing but a multidimensional on-line analysis of data.
44. What is the use of Cognos decision stream?
Cognos decision stream is set to be a tool which is used for extracting, transforming the data from different data sources to target data source.