treeknox Cognos Interview Question and Answers.doc

Posted by Unknown On 9:26 PM No comments


1.
What is Data warehouse?

In 1980, Bill Inmon known as father of data warehousing. "A Data warehouse is a subject oriented, integrated ,time variant, non volatile collection of data in support of management's decision making process".
Subject oriented : means that the data addresses a specific subject such as sales, inventory etc.
Integrated : means that the data is obtained from a variety of sources.
Time variant : implies that the data is stored in such a way that when some data is changed.
Non volatile : implies that data is never removed. i.e., historical data is also kept.
 2.
What is the difference between database and data warehouse?

A database is a collection of related data. 
A data warehouse is also a collection of information as well as a supporting system.
 3.
What are the benefits of data warehousing?

Historical information for comparative and competitive analysis.
Enhanced data quality and completeness.Supplementing disaster      recovery plans with another data back up source.
 4.
What are the types of data warehouse?

There are mainly three type of Data Warehouse are :
1) Enterprise Data Warehouse 2) Operational data store 3) Data Mart
 5.
What is the difference between data mining and data warehousing?

Data mining, the operational data is analyzed using statistical techniques and clustering techniques to find the hidden patterns and trends. So, the data mines do some kind of summarization of the data and can be used by data warehouses for faster analytical processing for business intelligence.
Data warehouse may make use of a data mine for analytical processing of the data in a faster way.
6.
What are the applications of data warehouse?

Data warehouse are used extensively in banking and financial services, consumer goods. > Data warehouse is mainly used for generating reports and answering predefined queries. > Data warehouse is used for strategic purposes, performing multidimensional analysis. > Data warehouse is used for knowledge discovery and strategic decision making using data mining tools.
7.
What are the types of data warehouse applications?

Info processing, Analytical processing and Data mining
8.
What is metadata?

Metadata is defined as the data about data. Metadata describes the entity and attributes description.
9.
What are the benefits of Datawarehousing?

The implementation of a data warehouse can provide many benefits to an organization. A data warehouse can :
Facilitate integration in an environment characterized by un–integrated applications.
Integrate enterprise data across a variety of functions.
Integrate external as well as internal data.
Support strategic and long–term business planning.
Support day–to–day tactical decisions.
Enable insight into business trends and business opportunities.
Organize and store historical data needed for analysis.
Make available historical data, extending over many years, which enables trend analysis.
Provide more accurate and complete information.
Improve knowledge about the business.
Enable cost–effective decision making.
Enable organizations to understand their customers, and their needs, as well competitors.
Enhance customer servicc and satisfaction.
Provide competitive advantage.
Provide easy access for end–users.
Provide timely access to corporate information.
10.
What is the difference between dimensional table and fact table?

A dimension table consists of tuples of attributes of the dimension. A fact table can be thought of as having tuples, one per a recorded fact. This fact contains some measured or observed variables and identifies them with pointers to dimension tables.
11.
What is data mart?

A data mart can contain one fact table to address one subject. In such a case,when a number of data marts are integrated to create a DWH, it is important that the facts in each table mean the same thing. Such facts (i.e., measures or metrics) that have the same meaning in different data marts are called conformed facts.
12.
What are the different types of datasmarts?

Stand–alone Data Marts : Data marts that do not interact with other data marts are called stand–alone data marts. On the other hand, data marts can be integrated to create a data warehouse.
Multi–source Data Mart : A data mart for which the input data is obtained from multiple sources is called a multi–source data mart.
Personal Data Mart : A data mart for use by individuals such as Chief Executive Officer (CEO), Chief Technology Officer (CTO) or Chief Financial Officer (CFO) is called Personal Data Mart.
Operational Data Store : ODS is a database system that obtains data from different sources, consolidates it and keeps it at a single location. However, it does not have the sophistication of a data mart or a data warehouse for analytical processing. ODS is generally developed as a pre-cursor for ERP systems.
13.
What is fact table?

A fact table is the central table that contains the measures or facts of a business process.
14.
What is the mapplet?

Mapplet is a set of transformations that you build in the mapplet designer and you can use in multiple mappings.
15.
What is meant by grain?

Granularity of data is a very important factor in the design of fact table. In fact table, we can represent data at different atomic levels, called grains.
1.
What is Cognos Impromptu?

Cognos Impromptu is a tool for generation of business intelligence reports.
2.
What is Cubes?

A cube consists of a set of ordered dimensions and measures. A cube may have one or several dimensions.
3.
What is query subject?

A query subject is the basic building block in framework manager. A query subject is a set of query items that have an inherent relationship.
4.
What is Report item?

Report item is a query item when it is drag and drop into the work area.
5.
What is a query item?

Query items are mainly used in Reporting and for BI Authors it is the most essential object from the framework manager. These have lot of properties associated with them and are present in query subjects. Query items are similar to subsets of query subjects.
6.
What are the advantages of Cognos?

Planning, Analysis, Forecasting and Score carding
7.
What are packages?

Packages are used for reporting.
8.
What is materialized view?

A view which is physically stored in a database. Materialized views allow query performance to be enhanced by pre calculating costly operations.
9.
What is schema?

A schema is composed of a set of dimensions and a set of fact relationships.
10.
What is folder?

Folder contains repository objects such as sources, targets, mappings, transformation which are helps logically organize our data warehouse.
11.
What are the types of report?

Blank report, List report, Cross report, Chart report, Repeater report
12.
What are Slice and Dice?

An operation that allows one to select a portion of the data of a fact on the basis of specified values in one or several dimensions.
13.
What is pivot?

The pivot (or rotate) operation rotates the axes of a cube to provide an alternative presentation of the data.
14.
What are the types of gateway?

Common Gateway Interface(CGI),
Internet Service Application Interface(ISAPI) and Tomcat
15.
What is Cognos Reporting tool?

Cognos is a reporting tool from IBM which helps in reporting and analysis of various data from a data warehouse.
16.
What are the types of framework manager?

There are two types of framework manager are :
Presentation layer and Physical layer
17.
What are dimensions?

Dimensions define the structure of a cube. A dimension must have at least one key attribute and other attributes that may define hierarchies.
18.
What are the components of Report Net?

Report Net components are :
Framework manager, Cognos connection, Query Studio, Report Studio
19.
What are the types of hierarchies?

In Analysis Services, there are two types of hierarchies are :
Attribute hierarchies and User defined hierarchies.
20.
What is slice?

The slice operation performs a selection on one dimension of a cube, resulting in a sub cube.
21.
What are the types of prompt?

Value Prompt, Textbox, Select and search, Date, Time, Date and time, Interval, Generated Prompt.
22.
What is Cognos Connection?

It is a Web portal for Cognos 8 and a component which interacts with the Content Store. It is a frontend to publish, find, manage, organize, and view organization's business intelligence data.
23.
What is framework manager?

Frame manager is a development tool to create the end-user layer used by authors to build their BI objects.
24.
What is OLAP designer?

OLAP Designer is a development tool used to model and create multidimensional databases. A multidimensional database, often referred to as a cube, is a highly compressed database and contains summarized information that is optimized for analysis.
25.
What is metrics designer?

Metrics Designer is a development tool used to model and deploy scorecards and related data loading procedures.
26.
What is meant by drill across?

The drill–across operation executes queries involving more than one cube.
27.
What is meant by drill through?

The drill–through operation allows one to move from data at the bottom level in a cube to data in the operational systems from which the cube was derived.
28.
What is meant by drill down?

The drill-down operation performs the operation opposite to the roll-up operation, i.e., it moves from a more general level to a detailed level in a hierarchy, thus presenting more detailed measures.
29.
Define data mining?

A data mining dimension provides support for dimensions that result from data mining models.
30.
What is Metrics Designer?

Metrics Designer is a development tool used to model and deploy scorecards and related data loading procedures.
31.
What is cognos powerplay?

Cognos powerplay is for multidimensional on–line analysis of data.
32.
What is the use of cognos decision stream?

Cognos decision stream is a tool for extraction, transformation of loading of data from the source databases to the target database.
33.
What is the use of cognos scenario?

Cognos scenario is used to find the hidden trends and patterns in data.
34.
What is meant by drilling Up?

Drilling down is adding grouping columns from the dimension tables, then drilling up is subtracting grouping columns.
35.
What are the three important fundamental themes in a data warehouse?

The three most important fundamental themes are :
Drilling Down, Drilling Across and Handling Time
36.
How to create reports?

Use Report Studio to create more advanced business reports.
37.
What is the security module used in Cognos?

The security module used in Cognos is Cognos access manager.
38.
What is catalog ?

A catalog is a file containing the information (Database tables) that Impromptu users need to create reports.
39.
What are the types of catalogs in Cognos?

There are four types of catalogs in Cognos. They are :
Personal, Distributed, Shared and Secured
40.
What are the differences between Reporter report and Explorer report?

In a Cube, you can either modify or explore. Reporter is used to modify where as explorer is used to explore the cube.
41.
What is cognos connection?

Cognos Connection is used to monitor, configure and optimize a Cognos 8 BI installation through a web interface. It is the same tool used by Consumers, but contains other advanced options for administration.
42.
What is cognos configuration?

Cognos Configuration is the Cognos 8 BI administrative tool that is used to define the behavior of a Cognos 8 BI installation. It is used to manage configuration parameters.
43.
What are the types of folder?

There are three main types of folders are :
Standard folder, Package folder and Metrics folder
44.
What is the difference between standard and metrics folder?

Standard Folder : This is a container for other folders and/or BI objects, and is used for organizational purposes. It will behave just like a folder on your local computer, but will operate like a web page with active links. A bright yellow icon specifics Standard folders.
Metrics Folder : Metrics folders arc used by the Metrics Studio to store metrics-related information. While the standard behavior upon selecting the other two folder types is to show their contents, a Metrics Folder will open up directly into Metrics Studio. A dark blue icon with colored dots specifies Metrics folders.
45.
What is query studio?

Query studio are used to perform ad hoc queries.
46.
What is difference between drill through and drill down?

The drill through operation allows one to move from data at the bottom level in a cube to data in the operational systems from which the cube was derived. 
The drill down operation performs the operation opposite to the roll-up operation, i.e., it moves from a more general level to a detailed level in a hierarchy, thus presenting more detailed measures.
47.
What is the difference between a cascading report and drill through report?

Cascading prompt means to extract the data from one prompt to using values from another prompt.
Drill through report means to extract the data by selecting a column in a report, means to get the detailed information by clicking that column data.
48.
What are the types of studio?

There are five types of studio are :
Query Studio, Metrics Studio, Analysis Studio, Report Studio and Event Studio
49.
What are Cognos connection initial page components?

The page can be broken down into three major sections :
1) The Studio Toolbar 2) The Utilities Toolbar 3) The Tab Navigator
50.
What is the difference between macros and prompt?

Macro is set of instructions to run report.
Prompt provide a way to dynamically change the reports.
51.
What is Cognos scenario?

Cognos scenario is a tool that is used to find the hidden trends and patterns in data.
52.
How to create cubes in transformer?

Cube can be created by using different data sources.
53.
What are the components of Report Net?

There are four components of report net are :
Framework manager, Cognos connection, Query Studio and Report Studio
54.
What is transformer?

Transformer is used for building the Cubes (Multidimensional Structure used for OLAP processing).
55.
What is model?

A model is a complete set of query objects and query subjects that are used for reporting.
56.
What is IQD?

IQD stands for Impromptu Query Definition. It is report save extension with .iqd it is use for creating a cube in power play transformer.
57.
What is cascading prompts?

Cascading Prompts allows a user to use values selected from one prompt to filter values in another prompt.
58.
What is the use of charts?

Charts are a graphical way of presenting information. Use charts to reveal trends and relationships that are not evident in tabular reports.
59.
What are the filters in Framework Manager and Report Studio?

Filters in framework manager are :
Standalone filters and Embedded filters
Report studio Filters are :
Detail filters and Summary filters
60.
What is difference between content store and content manager?

A content store is a data base which stores the meta data of the reports.
Content manager is a service which is available in dispatcher. which it manages the security.
61.
What is Cognos 8 BI?

Cognos 8BI is a powerful suite of products that focuses on transforming raw data into powerful information for business decisions. Cognos 8 BI can be used across all levels in an organization, from users looking for pre-defined reports to analysts with complex data requirements.
62.
What are package folders?

This folder is similar to a Standard Folder, but internally it contains pre-defined business rules and metadata related to sources of information. It is used by the Studios to create new queries, reports, analyses, etc. A dark blue icon specifics Package folders.
63.
What are components of report studio?

There are four components of report studio are :
Insertable Objects pane ,Properties pane ,Explorer bar and Report Viewer
64.
What are the types of security?

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.
65.
What is metrics designer?

Metrics Designer is a development tool used to model and deploy scorecards and related data loading procedures.
66.
What is query studio?

Query Studio is a very user friendly ad hoc query tool that allows users to easily access information. With Query Studio, the user drags and drops fields to execute queries, and with multiple available options at a touch of the mouse, it can group data, create summaries, display charts, filter information and export data.
67.
What is metrics studio?

Metrics Studio is a powerful scorecard tool that allows for the creation and monitoring of goals through an organization.
68.
What is analysis studio?

Analysis Studio is the user friendly tool used to quickly analyze summarized information with powerful dimension and variable crossing for complex analysis, discovery of trends and forecasting.
69.
What is report studio?

Report Studio is the professional report authoring tool. The tool allows for the development of pixel perfect reports, such as invoices and statements, as well as very complex layouts, such as those required for enterprise dashboards.
70.
What is event studio?

Event Studio is a monitoring tool that allows for the definition of agents that will monitor certain user-defined events and will execute tasks accordingly. They can be saved to Cognos as ″agents″.
71.
What are the types of user roles?

The users of Cognos 8 BI can be grouped into four major roles based upon their respective business and technical requirements.
Consumers, Authors, Developers, Administrators
72.
What are repeaters?

Repeaters are tables in which you can insert items that are repeated when you run the report.
73.
What are cross tab reports?

Crosstab reports are reports that show data in rows and columns. However, the values at the intersection points of rows and columns show summarized information rather than detailed information.
74.
What is list report?

A list report is a report that shows data in rows and columns. Each column shows all the values for a query item in the database or a calculation based on query items in the database.

Read More

A2Z Cognos Interview Question and Answers

Posted by Unknown On 9:08 PM No comments


A2Z Cognos Interview Question and Answers
1.
What is Cognos Reporting tool?

Cognos is a Reporting tool from IBM which helps in reporting and analysis of various data from a data warehouse.
2.
What is Cognos Connection?

It is a Web portal for Cognos 8 and a component which interracts with the Content Store. It is a frontend to publish, find, manage, organize, and view organization’s business intelligence data.
3.
What is Report item?

Report item is nothing but a query item when it is drag and drop into the work area.
4.
What is Cardinality?

Cardinality is nothing but relation between tables.
One to One > One to Many > Many to Many > Many to One
5.
What is data mining?

Data mining is a process of extracting hidden trends within a data warehouse.
6.
What are the types of prompt in Cognos?

Value prompt ,Text Prompt, Date prompt, Time prompt, Date and time prompt
7.
What is Drill Through?

Drill-through reporting allows you to link from one report to another. You can drill through in a number of ways. > A Drill Through id developed with two reports. 
1. Parent Report  > 2. Child Report.
8.
What are the components of Report Net?

Framework manager ,Cognos connection, Query Studio, Report Studio
9.
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 where as a content manager is a service which is available in dispatcher. which it manages the security.
10.
What is OLAP?

OLAP stands for On Line Analytical Processing, a series of protocols used mainly for business reporting.
11.
What are components of report studio?

Insertable Objects pane > Properties pane > Explorer bar >Report Viewer
12.
What is Snap Shot?

snapshot is a static datasource it is a picture of of report once u created a snapshot report u can't add a data item.
13.
How do you define a cube?

Its a multidimensional view of dimension and measures. It is used to analyze the data in various aspects, which is called slicing and dicing.
14.
What is the Difference between PowerPlay transformer and power play reports?

Powerplay transformer' is an ‘MOLAP’ tool using which one can create multi dimensional structure called “CUBE”.
Powerplay for reports is used to generate report from the cube.Only one report can be generated from one cube.If u want ‘n’ reports u must create ‘n’ cubes.
15.
What is cube size?

2.0 GBIt depends on ur project requirements.
16.
What is meant by Junk Dimension?

The Junk Dimension also called as garbage dimension. 
A junk dimension is a convenient grouping of typically low-cardinality flags and indicators.
17.
What is transformer?

Transformer is used for building the Cubes (Multidimensional Structure used for OLAP
18.
What is catalog and types of catalogs in cagonos?

A catalog is a file containing the information (Database tables) that Impromptu users need to create reports. > personal > distributed > hared > secured
19.
What is Cardinality?

Relationships exist between two query subjects. The cardinality of a relationship is the number of related rows for each of the two query subjects. The rows are related by the expression of the relationship; this expression usually refers to the primary and foreign keys of the underlying tables.
20.
How to join multiple db in catalog?

Mutiple database could not be connected in a single catalog. So that we use hotfile for thispurpose.
21.
How to generate cubes in cognos?

Power Play Transformer contain dimension,measure,model and cube. we can generate cube different way. > Just right click on cube name and build.
we can write script in unix. using that we can generate cube.
22.
What is snapshot?

A Snapshot is the copy of data, when we create a snapshot it copies the exact data that'srelated to the at perticular report, we use snapshot when ever we want to compare reports.(Example :we want to compare this months report with previous months).
23.
Define datastores in Cognos?

Data sources, also known as query databases, are relational databases, dimensionalcubes, files, or other physical data stores that can be accessed through IBM Cognos8. Application Tier Components use data source connections to access data sources.
24.
What is metric store database?

A metric store database is a special case of a query database. A metric storedatabase is used to store the information associated with metrics that appear inscorecards, including targets performance metrics , thresholds , embership in sorecards 
links to related reports.
25.
What is difference between view and materialized view?

Views contains query whenever execute views it has read from base table Where as M views loading or replicated takes place only once which gives you better query performance.
26.
What is difference between data mart and data warehouse?

A data mart designed for a particular line of business, such as sales, marketing, or finance.
Where as data warehouse is enterprise-wide/organizational
The data flow of data warehouse depending on the approach.
27.
What is DTM?

DTM transform data received from reader buffer and its moves transformation to transformation on row by row basis and it uses transformation caches when necessary.
28.
What are the different uses of a repository manager?

Repository manager used to create repository which contains metadata the informatica uses to transform data from source to target. And also it use to create informatica user’s and folders and copy, backup and restore the repository.
29.
What is a folder?

Folder contains repository objects such as sources, targets, mappings, transformation which are helps logically organize our data warehouse.
30.
Explain Informatica Architecture?

Informatica consist of client and server. Client tools such as Repository manager, Designer, Server manager. Repository data base contains metadata it read by informatica server used read data from source, transforming and loading into target.
31.
How do you call a store procedure within a transformation?

In the expression transformation create new out port in the expression write :sp.stored procedure name(arguments).
32.
What is difference between Informatica power mart and power center?

Using power center we can create global repository
Power mart used to create local repository
Global repository configure multiple server to balance session load
Local repository configure only single server
33.
What are the batches and it’s details?

Sequential(Run the sessions one by one
Concurrent (Run the sessions simultaneously)
34.
What is main difference mapplets and mapping?

Reuse the transformation in several mappings, where as mapping not like that.
If any changes made in mapplets it automatically inherited in all other instance mapplets.
35.
Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output? Ans ) 5 Rank.
36.
What is bitmap index?

A bitmap for each key value replaces a list of rowids. Bitmap index more efficient for data warehousing because low cardinality, low updates, very efficient for where class.
37.
Why need staging area database for DWH?

Staging area needs to clean operational data before loading into data warehouse.
Cleaning in the sense your merging data which comes from different source
38.
What is slowly changing dimension?

Dimension attribute values may change constantly over the time. (Say for example customer dimension has customer_id,name, and address) customer address may change over time.
39.
What is difference between primary key and unique key constraints?

Primary key maintains uniqueness and not null values Where as unique constrains maintain unique values and null values.
40.
What are the types of index?

Bitmap index ,B-tree index, Function based index ,reverse key and composite index. We used Bitmap index in our project for better performance.
41.
What are the different uses of a repository manager?

Repository manager used to create repository which contains metadata the informatica uses to transform data from source to target. And also it use to create informatica user’s and folders and copy, backup and restore the repository.
42.
What are shortcuts? Where it can be used? What are the advantages?

There are 2 shortcuts(Local and global) Local used in local repository and global used in global repository. The advantage is reuse an object without creating multiple objects. Say for example a source definition want to use in 10 mappings in 10 different folder without creating 10 multiple source you create 10 shotcuts.




Cognos 8 and 10 Interview Question
1) What is a Data Warehouse?
A Data Warehouse is a collection of data marts representing historical data from different operation data sources (OLTP). The data from these OLTP are structured and optimized for querying and analysis in a Data Warehouse.

2) Define Cognos Report Net?
Cognos Report Net is the web-based, dynamic, business intelligence reporting solution from Cognos.

3) What are the tiers of the ReportNet Architecture?
The ReportNet architecture can be separated into three tiers:
* Web server
* Applications
* Data 

4) Define Business Intelligence
 Business Intelligence is a broad category of application programs and technology used for query, Reporting and analyzing the business multi dimensionally.

5) What is a Data Mart?
 A Data Mart is a subset of a data warehouse that can provide data for reporting and analysis.

6) What is HPQS ?
 Data Marts are sometimes also called as HPQS (Higher Performance Query Structure).

7) 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.
 8) What are the responsibilities of Cognos Administrator?
A Cognos Administrator is assigned with following responsibilities.
1. Installations and configurations in distributed network environment.
2. Creating the Repository (Content Store). 3. Perform back up and recovery of Meta Data.4. Developing the user Administration.5. Tuning the servers.6. Deployment.

9) Responsibility of Cognos Architect?
An Architect is responsible for designing the interface by fulfilling the user requirements.Once the interface has been designed it should be rigorously tested before distributing to the end user population.

10) Roles of the Application Developer?
 Design the Reports according to the Report requirement templates.
 Testing the each report with the following types of tests.
a. Unit Testing b. System Testing c. Performance Testing

11) What is OLAP?
 OLAP stands for Online Analytical Processing. It uses database tables (Fact and Dimension tables) to enable multidimensional viewing, analysis and querying of large amount of data.

12) What are the types of OLAPs?
1. DOLAP:-The OLAP tool which works with desktop databases are called as DOLAP
Ex:- FoxPro, Clipper, Dbase, Paradox.
2. ROLAP:-The OLAP tool, which works with Relational databases, are called as ROLAP.
Ex:-Oracle, SQL Server, Tera Data, DB2.
3. MOLAP: - The OLAP  tool, which works with Multidimensional databases, are called as MOLAP.
Ex:- ESSBASE, Power Cube
4. HOLAP:- The OLAP tool which works with Relational databases and Multidimensional database, are called as MOLAP.
Ex:- Cognos, Business Objects.
13) What is OLTP?
OLTP stands for Online Transaction Processing. Except data warehouse databases the other databases are OLTPs. These OLTP databases are designed for recording the daily operations and transactions of a business.
14) What is an Interface?
An Interface is a gateway between the user and database.
An Interface contains a logical pointers which pointes to data in the Data Warehouse.
An Interface is isolates the complexity and diversity if data bases.
A good OLAP Interface writes an efficient SQL read on accurate data from database.
An Interface needs to be designed by fulfilling the report requirement.
15) What is the role of a Data Warehouse in creating the Interface?
Data Warehouse acts as Source to the Interface.
16) What are the types of components installed while loading the Cognos Report Net Software?
When we install  the Cognos Report Net Software there are two types of components get installed :-
1. Windows based components. 2. Web based components.
17) Define Windows based components?
 A Framework manager is windows based modeling tool used for creating a project (interface).
18) Define Web based Components?
 The following are the web based components.
 A. Cognos connection  B. Query Studio C. Report Studio D. Analysis Studio
19) Components of Report Net:
1. Framework  manager.2. Cognos connection 3. Query Studio 4. Report Studio 5.Transformer 6. Analysis Studio
20) What are the phases of the Cognos ReportNet Workflow?
Plan, Manage, Model, Author, Consume.
21) What are the advanced features of Report Net?
The Cognos Report Net has multilingual database accessibility.
The parameter maps are key value phase, which are used for working with local Language that the default value is ‘EN’.
Framework Manager
22) What is Framework manager?
 Frame Work Manager is windows based metadata development or metadata modeling tool for Cognos Report Net.
23) Why we need Framework manager?
 To create the interface known as Project.
 To create model the metadata derived from one or more data sources
24) How a project appears in a FrameWork manager?
A frame work manager project appears as a folder that contains a project file (.cpf) and the specific XML files that define the project.
25) What are the Building Blocks in Frame Work Manager?
The Query subjects are called Building Blocks in Framework Manager.
26) What are phases the workflow process consists in Framework Manager?
The workflow process consists of the following phases:
* Design and create project > * Prepare Metadata >* Prepare the Business View
* Create and Manger Packages >* Set Security > * Publish >* Manage the Project
27) How you set the security Framework manager?
 To set the security you have to set as:* Define access to packages. >* Create security filters > * Define access to objects >* Define package administration access
28) Define Name Space?
In security, a collection of user accounts and user groups from an authentication provider.A  Name Space is a container, which holds the Query Subjects.A Name Space uniquely represents the Query Subjects.
 29) Can you delete Cognos namespace?
No, we cannot delete Cognos namespace

30) What is the Cognos Namespace? And what it contains?
The Cognos namespace is the ReportNet built-in namespace
It contains Cognos objects:
Groups , Roles, Sources, Distribution lists, Contacts

31) What are the Groups and Roles?
 Groups and roles represent collections of users that perform similar tasks.

32) What is Folder?
A Folder is used to organize the Query Subjects.

33) Define Relationship?
 A Relationship is a connection that explains how the data in one Query Subject relates to data in other Query Subjects.

34) What is a Package?
A container for models, reports, and so on. Modelers create packages in Framework Manager to publish models to the ReportNet server.
35) What is Physical layer?
The Physical layer provides the physical query layer and is made up primarily of data source and stored procedure query subjects. It acts as the foundation for the presentation layer.
36) What is Presentation layer?
 The Presentation layer makes it easier for report authors to find and understand their data. The Presentation layer is made up primarily of model query subjects that you create.
37) Define function set:
 A function set is a collection of vendor specific database.
 The Expression editor lists the function sets for all available vendors. However, you can restrict the function sets, so that it lists only the vendors that you want to use in your project.
38) What is a Metadata?
 Data about data is called as Metadata. The Metadata contains the definition of a data.
39) What is a Project?
 When we work with a framework manager you work in a project.
 Project is a set of metadata organized for Report Authors according to the Business rules and Model.
 A Project created appears as folder, which contains following files.
a. Project Name .CPF (Cognos Project File) > b. Model .XML > c. Preferences .XML
d. Custom data .XML >The files in the folder are unique to that Project.
40) Define Publish?
To transfer all or part of a Framework Manager model to the ReportNet server, so that report authors can use it.
41) What a Project contains?
A. A Model > B. Namespaces > C. Data sources > D. Parameter maps > E. Packages
F. Folders > G. Query Subject > H. Query Item >I. Relation ship
42) What is a Model?
 A model in Frame work manager is a business presentation of the structure of the data from one or more databases. Or A model is a set of related query subjects and other objects.
43) What are Dimensions?
Dimensions are categories by which summarized data can be viewed.
44) What are Confirmed Dimensions?
The Dimensions which are reusable and fixed in nature.
45) What are Fact Tables?
A Fact Table is a table that contains summarized numerical (facts)  and historical data. This Fact Table has a foreign key – primary key relation with a dimension table.
46) What are the types of Facts?
 The types of Facts are:
1. Additive Facts:- A Fact which can be summed up for any of the dimension available in the Fact Table.
2. Semi-Additive Facts:- A Fact which can be summed up to a few dimensions and not for all dimensions and not for all dimensions available in the Fact Table.
3.   Non-Additive Fact:- a fact which cannot be summed up for any of the dimensions available in the Fact Table.
47) Define Query?
 A description of the data to be retrieved from a database.
48) Explain about Data Source Query Subject?
Data Source query subjects contain SQL statements the directly reference data in a single data source. Frame work manager automatically creates a data source query subject for each table and view that you import into model.
49) When the default data source query subject is created?
 During the initial metadata import operation, a default data source query subject is created for each object you select (for example table) and creates the default relationships between query subjects for you automatically.
50) How can you edit the data source query subject?
i. Apply or embed a filter > ii. Apply or embed a calculation > iii. Insert a Macro
iv. Insert a data source reference. > v. Change the SQL type. > vi. Change how SQL is generated. >These all are we can find it in “Edit definition window”.
51) What are the types of SQL?
 SQL is the industry language for creating, updating and querying relational data base management system. Types of SQL.
1. Cognos SQL 2. Native SQL 3. Pass-through SQL.
52) Define Cognos SQL?
 By default Cognos FM uses Cognos SQL to create and edit Query subjects.
 Advantages:
1. Can contain metadata from multiple data sources. 2. Have fewer database restrictions 3. Interact more effectively with Cognos applications.
Disadvantages:
 You can not enter nonstandard SQL.
53) Define Native SQL?
 Native SQL is the SQL, the data source uses, such as Oracle SQL, but you cannot uses Native SQL in a query subject that references more than one data source in the project.
 Advantages:
1. Performance is optimized across all related query subjects.
2. You can use SQL that is specific to your database.
Disadvantages:
1. You cannot use SQL that the data source does not support for sub queries.
2. The query subject may not work on different database type.
54) Define Pass-Through SQL?
 Pass-Through SQL lets you use native SQL without any of the restrictions the data source imposes on sub queries.
 Advantages:
1. You can enter any SQL supported by the database.
Disadvantages:
1. There is no opportunity for Frame work manager to automatically optimize performance. The SQL may not work on a different data source.
55) What are Query Processing Types?
There are two types of query processing.
1. Limited Local: The database server does as much of the SQL processing and Execution as possible. However, some reports or report sections use local SQL processing.
2. Database only: The database server does all the SQL processing and execution with the exception of tasks not supported by the database. An error appears if any reports of report sections require local SQL processing.
56) What is Query Subject?
 A Query Subject maps to the table in the database.
 A Query Subject uses an SQL to retrieve the data from the data source.

 A Query Subject is also known as Business View.
57) What are the types of Query subjects?
1. Default data source query subjects 2. Model Query Subjects
3. Stored Query subjects
58) What is a Query Item?
 A query Item maps to columns to the database table. A Query Subject contains Query Items.
59) How can you restrict the tables retrieved by a query?
 By setting governors we can restrict the tables.
60) What is meant by Governors?
To apply privileges and restrictions for a user class. Governor settings are used to set restrictions on queries by user class, such as
1. Sorting on non-indexed columns 2. Outer joins 3. Suppress duplicates 4. Cross-product queries 5. Retrieval of large text items 6. Number of records 7. Number of tables 8. Query execution time
61) What is a User Class?
A defined group of users with the same data access needs, privileges and restrictions.
62) What is Scrubbing at Project level?
According to the report requirements derive the new Items with the help of existing Query Items. This process is known as Scrubbing at Project level.
63) How can you add the calculated data to a report?
a. Summarize existing detail values predefined summary functions (such as sum, avg)
b. Create new report items using data from existing report items.
c. Use model calculations provided in the package.
64) What are the sources to create new Query subjects?
 A new Query Subject can be created from the following sources.
1. Model (Query subjects & Query Items) 2. Data Sources (Tables and Columns)
3. Stored Procedure.
65) What is Multi Database Access in Cognos Report Net?
 In Cognos Report Net a Project can be created from multiple databases. The databases can be either homogenous or hydrogenous.
66) What are Parameter Maps?
 A Parameter Map is a key value pair used in creation of conditional Query Subjects.
 A Parameter map sub situates the values at the query at runtime.
67) What is the default formats of reports?
HTML, PDF, CSV, and XML.
68) What are the different ways to modify multi lingual metadata?
1. Macro :- To modify dynamically
2. Directly

69) What is a Macro?
A Macro is a runtime object, which uses the parameter maps and session parameters in developing the conditional query subjects.
70) What is usage property? And what are different setting to set usage property?
It identifies the intended use for the data represented by each query item.
It determines the aggregation rules of query items and calculations.
The different usage property settings are:
* Identifies * Fact * Attribute * Unknown
71) What are the types of filters in Framework manager?
In framework manager we can create two types of filters.
1. Model filters 2. Query filters.
72) Define Model Filter?
 A filter is a condition used to restrict the data displayed in the Report.
 Model filter are reusable.
73) Define Data restriction:
A filter is a condition, which restricts the amount of data displayed in the report.
74) What is condition?
An expression that yields a Boolean value. Conditions are used in query expressions, query filters, and Boolean report variables that can be used for conditional formatting, styles, data sources, layouts and blocks.
75) Types of Conditions:
Conditions are of 2 types:
1. Static Condition: - Condition doesn’t change whenever you run the report.
2. Dynamic Condition: -A condition can be kept on change whenever you run the report.
76) What are the types of filters in Report Studio?
 In the report studio we can find two types of filters.
1. Tabular Filters:- These filters are two types
a. Summary Filters b. Detailed Filters
2. Grouped Filter
77) What is a Loop?
A Loop is a closed path which is resulted due to joints.
A Loop causes performance degradation of query execution and wrong data will be displayed in the report.
A Loop can be resolved by creating the short cuts (Alias).
78) What is Alias Table?
An alternative name for a table generally used in self joins.
79) What are the uses of Alias Table?
The uses of Alias Table are :1. To resolve the Loops. 2. To create self-joins with in a table. 3. To Provide alternate join structure.
80) What is Associated Data Item?
A Data Item linked to the group data item. Associated data item suppress duplicate data values but do not generate a control break. The associated column displays only one data values for the group with which it is associated.
81) What is Automatic Association?
The group association of a newly created summary. The location of the group where you create the summary determines its automatic association.
82) What is an Ambiguous Relationship?
An ambiguous relationship is where there are multiple relationship paths between one or more query subjects leaving multiple options for how to write a query.
83) What is a Join and types of Joins?
 A Join identifies the columns from one table that are used to link to another table.
 A Join is commonly formed by a foreign key definition within the database.
Types of Joins :- 1. Equi-joins 2. Non equi-joins 3. Outer joins
84) What is a dimension?
A broad grouping of descriptive data about a major aspect of a business, such as products, dates, or markets. Each dimension includes different levels of members in one or more hierarchies, and an optional set of calculated members.
85) What is a Confirmed Dimension?
If a Dimension is connected to multiple fact tables then it is called as Confirmed Dimension.
86) What is a Junk Dimension?
A randomly used dimension is Junk Dimension.
87) Define Surrogate Key?
It has system-generated artificial primary key values, which allows to maintain historical records in the Data Warehouse more effectively.
88) What are the User Interface Components?
* Cognos Connection * Report Studio * Query Studio * Frame work manager
* Cognos configuration
1. What is significance of Framework Manager in Cognos Reporting?
ANS: Framework Manager is a metadata modeling tool. A model is a business presentation of the information in one or more data sources. When you add security and multilingual capabilities to this business presentation, one model can serve the reporting, ad hoc querying, and analysis needs of many groups of users
2. What is loop in framework manager?
ANS: Loop is closed path in IN FRAME WORK MANAGER DUE TO JOINS report net it called as ambiguous relationship. That means a query subject contains multiple paths to retrieve the data. It is an exception to resolve to create a shortcut on that query subject otherwise it displays wrong results in reports and performance is degrades.An undefined join between two tables is known as loop. To resolve loop delete the joins, if these joins are necessary then we have to create shortcuts nothing but alias tables. Place the joins in alias tables.
3. What are the filters in Framework Manager and Report Studio?
ANS: Filters in framework manager are
1. Standalone filters 2. Embedded filters
Report studio Filters are
1. Detail filters 2. Summary filters
4. How to import two data sources into Framework Manager?
We can import two data sources to FM  in the Run Metadata  Wizard.
Go to Run Metadata Wizard–>Select another database ( e.g. suppose SQL Server is choosed in prior attempt, then u can choose Oracle as new datasource).Then import it
5. How to perform single sign on in Cognos by using URL?
In Cognos configuration under authentication allow anonymous access should be false. In cgi-bin properties (under iis) the enable anonymous access should be false.
6. What is usage property? Where do we set usage property?
1.The Usage Property identifies the use for the data represented by query item.
It determines the aggregation rules of query items and calculations.
The different usage property settings are Identifier, Fact, Attribute, Unknown
2. To set the usage property: Click the query item u want to set the usage property for Then click the properties icon on the tool bar or you can see the properties pane on the right side of the browser. Go to “USAGE” tab and click “CLICK TO EDIT” option. And select the appropriate.
7. What is the use of prompts in Framework Manager?
ANS: Use of Prompt in Framework Manager:
Filter on query subject – to restrict the rows that are returned by filtering out the unwanted data by creating one or more embedded filters for query subject.
Prompt in filter with usage set to always – user need to supply a value to filter.
8. Where exactly determinants are used in cognos framework manager?
ANS: A query subject that behaves as a dimension has multiple levels of granularity and will be joined on different sets of keys to fact data.
9. How would you structure your Framework Manager Model?
ANS: A model is normally structured into two layers/views. Database/ Physical view and Business/ Presentation view. These can be implemented using Namespaces.
You import the metadata into Physical layer from DB using data source connection. You will use Import Metadata Wizard. You will change the Query Subjects & Query Items, create relationships (joins) and other activities here.
In the Presentation layer, you create Query Subjects taking input from the existing Physical layer. You change the names of the Query Items and other cosmetic modifications.You can choose only the Presentation layer while creating the Packages and apply appropriate security settings.
10. How to provide security in frame work manager for a query subject?
ANS: Procedure for providing security for query subject in frame work manager is:
Select querysubject -> in properties pane select ->security filters (click on edit)a specify data security wizard appears->click on add groups -> cognosnamesspace(select users and groups wizard opens)
11. How can we generate the cubes in framework manager?
ANS: You can create the IQD file from framework manager.
This IQD file will be used by Transformer to create the cube.
12. How to generate IQD file from framework manager?
Create a Query Subject, from the properties pane select externalise, there we have 4 options in that select IQD.

Read More