What is called Cognos Reporting tool?
Cognos is an IBM reporting tool which is used for reporting and analysis of various data from different datawarehouse.
What is Report item?
Report item is defined as a query item which can be dragged and dropped into a work area.
What is set to be Cardinality?
Cardinality is defined as relationships between the tables. Following are relationship formed between the tables.
- One to One
- One to Many
- Many to Many
- Many to One Get more additional info from Cognos Training
What is defined as Data mining?
Data mining is the process of getting hidden trends from a data ware house.
What are all the different types of prompt in Cognos?
Following are the different types of prompt in Cognos:
- Value prompt
- Text Prompt
- Date prompt
- Time prompt
- Date and time prompt
Name the types of gateway?
There are three types of gateway:
A) CGI (Common Gateway Interface)
B) ISAPI (Internet Service Application Interface)
C) Tomcat
Define dimensions?
It defines the structure of a cube. Any dimension must have at least one key attribute and other attributes so that it may define hierarchies.
Name the types of hierarchies?
There are two types of hierarchies in Analysis Services:
A) One is Attribute hierarchies
B) Second is User defined hierarchies.
What is Dynamic Cube?
Dynamic Cubes are in-memory OLAP cubes that load data directly from relational data sources that are structured in a star or snowflake schema
- Introduced as a new feature from IBM Cognos BI 10.2
- The Cognos Dynamic Cubes technology is part of the IBM Cognos BI query stack
- The goal of IBM Cognos Dynamic Cubes is to provide quick response to reports and analyses on large volumes of data.
- Enabling high-performance interactive analysis over terabytes of data. Learn more skills from Cognos TM1 Online Training
Cognos Dynamic Cube solution consists of what elements?
IBM Cognos Dynamic Cube consists of the following elements, they are:
- IBM Cognos Cube Designer
- IBM Cognos Dynamic Cubes Server
- Aggregate Advisor (part of IBM Cognos Dynamic Query Analyzer)
When to use Cognos Dynamic Cubes?
Data warehouse with star or snowflake schema
- A server with adequate memory
- A database with approximately 25 million or more fact table rows
What are all the advantages of Cognos?
Following are the advantages of Cognos
- Planning
- Analysis
- Forecasting
- Scorecard
What are all the types of indexes in Cognos?
Following are the types of Indexes in Cognos:
- Bitmap index
- B-tree index
- Function based index
- Reverse key and composite index
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.
To get indepth knowledge, enroll for live free demo on Cognos online Training
How Can I Schedule Reports In Cognos?
By using Cognos Schedular, one can schedule the running reports in Impromptu to execute and save it in desired format.
By using Cognos MACRO script language the reports can be executed and distributed to recipients by using mail applications.
Compiled Cognos MACROs can be scheduled using Cognos Schedular.
How Can Create Users And Permissions In Cognos?
impromptu menu go to Catlog->User profiles -> userclass tab -> click on Creator ->you can give there folder access,table access,filters,Governor etc.
you can create users by using USERS PROFILE option..and you can give permissions using ROLE IN C8 and GOVERNERS in C7.
What Is Loop In Frameworkmanager?
Loop: loop is a closed path (relation) that exists among 3 (or) more tables. For example, if we have '3' tables T1, T2, T3 then, a loop exists among these tables only when we create joins in the following fashion:
Loop: T1 ---> T2 ---> T3 ---> T1
To resolve the above problem, we have to create a shortcut (or) Alias to the Table T1.
No Loop: T1 ---> T2 ---> T3 ---> Alias (or) Shortcut of T1
Take your career to new heights of success with a Cognos TM1 Training