Cognos is an IBM reporting tool which is used for reporting and analysis of various data from different datawarehouse.
Report item is defined as a query item which can be dragged and dropped into a work area.
Drill through reporting is used to link from one report to another report. It has parent and child relationship between the reports.
Macro is used to run set of instructions to execute the report but prompt provide a way to change the report dynamically.
Cube is set to be multi-dimensional view of dimension and measures and it is used to analyze the data in various forms like Slicing and Dicing.
A snapshot is created to copy the exact data that is related to current report and compare with another report.
Transformer is used for making the Cubes which is for the Multidimensional structure on OLAP processing.
A catalog is defined as a file which contains information on Database tables and Impromptu users can create reports.
No, it is not possible to join multiple databases in a catalog and it can be achieved by Hotfile.
A Cognos Impromptu is set to be a tool which is used for the generation of business intelligence reports.
Query items are the most important object in framework manager and it has a lot of properties associated with it. This is mainly used for reporting and business intelligence.
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.
A folder consists of repository objects like sources, targets, transformation and mapping that help to organize data warehouse.
A data store is nothing but a query database or a relational database or files that can be accessed through IBM Cognos.
A Query subject is a set of query items that have inherent relationship and it is basic building block on framework manager.
Dimension is defined as structure of a cube. A dimension should have at least one key attribute and remaining attribute can define hierarchies.
Query studio is one of the studios in Cognos which is used to perform Adhoc queries.
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.
Drill down is addition of grouping columns from the dimension tables whereas drill up is removing grouping columns from the dimension tables.
There are two shortcuts – Local and Global. Local is used for the local repository and Global for global repository. Advantage is to reuse an object instead of creating multiple objects.
A materialized view is a view which is physically stored in a database. This view is used to increase query performance by calculating costly operations.
Pivot is used to rotate the axis of the cube to provide a different presentation on the data.
The slice is used to perform the operation on one dimension of a cube and it is results in a sub-cube.
Frame manager is a tool, which is used to develop end user layer and it can be used by Authors to build their own BI objects.
Metrics Designer is a tool which is used to model, deploy score cards and data loading procedures.
Cognos Configuration is a BI administrative tool which is used to define the behavior of Cognos 8 version. This will manage configuration parameters.
Drill through report is used to extract the data by selecting the column in a report and it can be drilled down by clicking the column data.
Cognos Transformer | Cognos Online Training | IBM Cognos Analytics
Main PowerPlay Transformer features:
Cognos is an IBM reporting tool which is used for reporting and analysis of various data from different data warehouses.
If the rule defines string values for any cells, then FEEDSTRINGS must be inserted as the first line of rule. FEEDSTRINGS declaration ensures that cells containing rules-derived strings are fed. Every calculation statement in a rule should have a corresponding feeder statement.
Cognos Access Manager establishes a centralized environment for defining, storing, and managing security data to IBM Cognos business information applications.We can set up and manage secure user access to data at one central location itself. With this, we can even handle user sign on information and auto access privileges for the servers and data sources containing necessary data.
Cognos Report Net is a web-based business intelligence suite of reporting applications, which is used for creating and running reports. It doesn’t require any additional software to access. Just through a web browser, we can access it. It supports multiple formats such as PDF, Excel, HTML, XML, and CSV.
Both Embedded filters and standalone filters are supported by the Framework Manager. For the purpose of using only one query object or dimension in the filter, we use embedded filters. For reusing the expression, we use standalone filters.
Pivot is used to rotate the axis of the cube to provide a different presentation on the data.
Transformer is used for making the Cubes which is for the Multidimensional structure on OLAP processing.
Cognos is an IBM reporting tool which is used for reporting and analysis of various data from different datawarehouse.
Cognos Configuration is a BI administrative tool which is used to define the behavior of Cognos 8 version. This will manage configuration parameters.
Drill down is addition of grouping columns from the dimension tables whereas drill up is removing grouping columns from the dimension tables.
Top 10 Frequently Asked Cognos Interview Questions
Here are frequently asked Cognos Interview Questions and Answers, lets have a look into them.
FAQ
What is IBM Cognos Transformer?
What are the three general categories of reporting in Cognos?
What appeals to you about Cognos?
For what purpose are custom views used in transformer?
