cognos transformer interview questions

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:

  • Advanced modelling capabilities
  • Leverages aggregate and fact tables
  • Intergation of the query data into the model
  • The models are defined by dimension structures and measures which can be easily customized
  • No custom programming required
  • Time periods are handled in a specific way which makes data delivery easy
  • High flexibilty and portability
  • Gather business users requirements
  • Create a Model Plan which will include design and data requirements for the model and decide on the cube distribution methodology
  • Select measures
  • Plan dimensions and levels
  • Design and develop the PowerPlay model in Transformer
  • Create PowerPlay cubes and distribute them to the end users
  • Analyze and explore the cube data using PowerPlay
  • Cognos Cube Designer is a modeling tool used for dynamic cubes and dimensional metadata. The object editors, data source explorer, the project explorer tree, and properties panes are the essential elements of the Cognos Cube Designer user interface.

    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.

    Warehouse Cubing services provide a multidimensional view of data collected in a relational database. We can create, import, edit, export, and deploy cube models across relational warehouse schema using the cubing services. Optimization techniques are also supported by cubing services for improving OLAP queries performance.

    Cognos is an IBM reporting tool which is used for reporting and analysis of various data from different data warehouses.

    The Cube is set to be a multi-dimensional view of dimension and measures and it is used to analyze the data in various forms like Slicing and Dicing.

    Cognos Configuration is a BI administrative tool which is used to define the behavior of Cognos 8 version. This will manage configuration parameters.

    Macro is used to run set of instructions to execute the report but prompt provide a way to change the report dynamically.

    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.

    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.

    3. What are the types of catalogs in Cognos?Answer:There are four types of catalogs in Cognos. They are:

    15. What are the types of security?Answer: There are three different types of Security are : Data security: Create a security filter and apply it to a specific query subject. Object security: Secure an object directly by allowing users access to the object, denying users access to the object, or keeping it hidden for all users. Package security: Apply security to a package and identify who has access to that package.

    21. What Is Model And How To Create Model And How To Test Model?Answer: Create a Model In framework Manager and then publish it, make sure that Model meets the requirements, don’t overload the model with unwanted query items.

    The page can be broken down into three major sections : The Studio Toolbar The Utilities Toolbar The Tab Navigator Post Your Answers

    Drilling let s you quickly move from one level of detail to another to explore different aspects of your business. Drilling down moves you down in the hierarchy. drilling up moves you up in the hierarchy. Slicing and Dicing While you can drill to look at the information at any level, you can slice and dice to select the exact information you want in your report.

    FAQ

    What is Cognos Transformer?

    IBM® Cognos® Transformer is a multi-dimensional data modeling component designed for use with IBM Cognos Business Intelligence. You use this component to create a multi-dimensional model: a business presentation of the information in one or more different data sources that share common data.

    What are the three general categories of reporting in Cognos?

    List, Crosstab, and Chart Reports.

    What are all the types of report in Cognos?

    When you are using data from an IBM® Cognos® Analytics package, you can work in three different ways: Exploration Views, lists, or Custom Reports. You can move between the methods. Each of these methods has its own benefits and limitations.

    What is Dynamic Cube in Cognos?

    Cognos Dynamic Cubes introduces a performance layer in the Cognos query stack to allow low-latency, high-performance OLAP analytics over large relational data warehouses. By using the power and scale of a relational database, Cognos Dynamic Cubes can provide OLAP analytics over terabytes of warehouse data.

    Related Posts

    Leave a Reply

    Your email address will not be published. Required fields are marked *