Interview Questions.

Question 1. What Is Framework Manager?

Answer :

Frame Work Manager is windows primarily based metadata modeling device for Cognos studios.

Question 2. Why We Need Framework Manager?

Answer :

To create the interface called Project.
To create version the metadata derived from one or more information resources
IBM Cognos Interview Questions
Question 3. How A Project Appears In A Frame Work Manager?

Answer :

A body work manager assignment appears as a folder that incorporates a challenge report (.Cpf) and the particular XML files that define the mission.

Question 4. What Are The Building Blocks In Framework Manager?

Answer :

The Query topics are referred to as Building Blocks in Framework Manager.

IBM Cognos Tutorial
Question five. What Are Phases The Workflow Process Consists In Framework Manager?

Answer :

The workflow system consists of the subsequent levels:

Design and create task
Prepare Metadata
Prepare the Business View
Create and Manger Packages
Set Security
Publish
Manage the Project
IBM Cognos TM1 Interview Questions
Question 6. How You Set The Security Framework Manager?

Answer :

To set the security you have to set as:

Define get admission to to programs.
Create security filters
Define access to items
Define package management access
Question 7. Define Name Space?

Answer :

In security, a collection of user money owed and person corporations from an authentication provider.
A Name Space is a container, which holds the Query Subjects.
A NameSpace uniquely represents the Query Subjects.
Software Development Lifecycle (SDLC) Tutorial Cognos ReportNet (CRN) Interview Questions
Question eight. Can You Delete Cognos Namespace?

Answer :

No, we can't delete Cognos namespace

Question nine. What Is The Cognos Namespace? And What It Contains?

Answer :

The Cognos namespace is the Cognos built-in namespace

It consists of Cognos gadgets:

Groups
Roles
Sources
Distribution lists
Contacts
Software Development Lifecycle (SDLC) Interview Questions
Question 10. What Are The Groups And Roles?

Answer :

Groups and roles constitute collections of customers that perform similar responsibilities.

Unix/Linux Tutorial
Question eleven. What Is Folder?

Answer :

A Folder is used to prepare the Query Subjects.

Advanced Linux Interview Questions
Question 12. Define Relationship?

Answer :

A Relationship is a connection that explains how the facts in one Query Subject related to facts in other Query Subjects.

IBM Cognos Interview Questions
Question thirteen. What Is A Package?

Answer :

A field of model or set of fashions. Modelers create applications in Framework Manager to post models to the Cognos connection.

Adaptive software development Tutorial
Question 14. What Is Physical Layer?

Answer :

The Physical layer gives the bodily query layer and is made up more often than not of statistics supply and saved manner question topics. It acts as the muse for the presentation layer.

Question 15. What Is Presentation Layer?

Answer :

The Presentation layer makes it easier for document authors to locate and apprehend their facts. The Presentation layer is made up more often than not of version question topics that you create.

Unix/Linux Interview Questions
Question sixteen. Define Function Set?

Answer :

A function set is a group of seller unique database.

The Expression editor lists the feature sets for all to be had providers. However, you can limit the characteristic sets, so that it lists simplest the providers that you want to use for your project.

Question 17. What Is A Metadata?

Answer :

Data approximately statistics is referred to as as Metadata. The Metadata includes the definition of a facts.

Frame Relay Interview Questions
Question 18. What Is A Project?

Answer :

When we work with a framework supervisor you figure in a task.

Project is a hard and fast of metadata organized for Report Authors according to the Business regulations and Model

A Project created seems as folder, which includes following files.

Project Name .CPF (Cognos Project File)
Model .XML
Preferences .XML
Custom information .XML
archive-log.Xml
log.Xml
consultation-log.Xml
session-log-backup.Xml
IDLog.Xml
The documents within the folder are particular to that Project.

IBM Cognos TM1 Interview Questions
Question 19. Define Publish?

Answer :

To transfer all or a part of a Framework Manager version to the Cognos connection, so that document authors can use it.

Question 20. What A Project Contains?

Answer :

A Model
Namespaces
Data sources
Parameter maps
Packages
Folders
Query Subject
Query Item
Relation deliver
Cognos BI Interview Questions
Question 21. What Is A Model?

Answer :

A model in Frame paintings supervisor is a enterprise presentation of the shape of the facts from one or greater databases.

Question 22. What Are Dimensions?

Answer :

Dimensions are classes through which summarized records can be considered.

Question 23. What Are Conformed Dimensions?

Answer :

The Dimensions that are removable and stuck in nature.

Cognos Bi Report Studio Interview Questions
Question 24. What Are Fact Tables?

Answer :

A Fact Table is a table that carries summarized numerical (facts) and historical data. This Fact Table has a foreign key – number one key relation with a size table.

Cognos ReportNet (CRN) Interview Questions
Question 25. What Are The Types Of Facts?

Answer :

The varieties of Facts are:

Additive Facts: - A Fact which can be summed up for any of the dimension available in the Fact Table.

Semi-Additive Facts: - A Fact which may be summed up to a few dimensions and no longer for all dimensions and now not for all dimensions available in the Fact Table.

Non-Additive Fact: - a fact which can not be summed up for any of the scale available inside the Fact Table.

Question 26. Define Query?

Answer :

A description of the information to be retrieved from a database.

Question 27. Explain About Data Source Query Subject?

Answer :

Data Source question topics contain SQL statements the without delay reference information in a unmarried statistics supply. Frame work manager robotically creates a information supply query concern for every table and examine that you import into version.

Software Development Lifecycle (SDLC) Interview Questions
Question 28. When The Default Data Source Query Subject Is Created?

Answer :

During the preliminary metadata import operation, a default information source question concern is created for every item you pick (as an example desk) and creates the default relationships among question topics for you mechanically.

Question 29. How Can You Edit The Data Source Query Subject?

Answer :

Apply or embed a filter out
Apply or embed a calculation
Insert a Macro
Insert a records supply reference.
Change the SQL kind.
Change how SQL is generated.
These all are we are able to discover it in “Edit definition window”.

Question 30. What Are The Types Of Sql?

Answer :

SQL is the industry language for growing, updating and querying relational database control device. Types of SQL.

Cognos SQL
Native SQL
Pass-thru SQL.
Question 31. Define Cognos Sql?

Answer :

By default Cognos Frame paintings supervisor makes use of Cognos SQL to create and edit Query topics.

Advantages:

Can comprise metadata from a couple of data assets.
Have fewer database regulations
Interact greater successfully with Cognos applications.
Disadvantages:

You cannot input nonstandard SQL.

Question 32. Define Native Sql?

Answer :

Native SQL is the SQL, the information source makes use of, along with Oracle SQL, but you can not uses Native SQL in a question difficulty that references more than one information supply in the undertaking.

Advantages:

Performance is optimized across all related question subjects.
You can use SQL this is unique on your database.
Disadvantages:

You can not use SQL that the information source does now not guide for sub queries.
The question subject might not paintings on unique database type.
Question 33. Define Pass-thru Sql?

Answer :

Pass-Through SQL lets you use native SQL without any of the restrictions the information supply imposes on sub queries.

Advantages:

You can enter any SQL supported by way of the database.

Disadvantages:

There is not any possibility for Frame paintings supervisor to routinely optimize overall performance. The SQL may not work on a special information source.

Advanced Linux Interview Questions
Question 34. What Are Query Processing Types?

Answer :

There are  sorts of question processing:

Limited Local: The database server does as an awful lot of the SQL processing and Execution as viable. However, some reports or file sections use nearby SQL processing.

Database best: The database server does all the SQL processing and execution excluding tasks no longer supported by using the database. An error appears if any reviews of report sections require local SQL processing.

Question 35. What Is Query Subject?

Answer :

A Query Subject maps to the table within the database.
A Query Subject makes use of an SQL to retrieve the statistics from the records source.
A Query Subject is likewise called Business View.
Question 36. What Are The Types Of Query Subjects?

Answer :

Default records supply query topics
Model Query Subjects
Stored Query subjects
Unix/Linux Interview Questions
Question 37. What Is A Query Item?

Answer :

A question Item maps to columns to the database desk. A Query Subject contains Query Items.

Question 38. How Can You Restrict The Tables Retrieved By A Query?

Answer :

By placing governors we are able to restriction the tables.

Question 39. What Is Meant By Governors?

Answer :

To apply privileges and restrictions for a consumer magnificence. Governor settings are used to set regulations on queries with the aid of consumer elegance, along with

Sorting on non-listed columns
Outer joins
Suppress duplicates
Cross-product queries
Retrieval of massive textual content objects
Number of records
Number of tables
Query execution time
Question forty. What Is A User Class?

Answer :

A defined group of users with the equal data access desires privileges and regulations.

Frame Relay Interview Questions
Question 41. What Is Scrubbing At Project Level?

Answer :

According to the report requirements derive the new Items with the help of current Query Items. This process is called Scrubbing at Project level.

Question 42. How Can You Add The Calculated Data To A Report?

Answer :

Summarize present element values predefined precis functions (such as sum, avg)
Create new report objects the use of facts from current document gadgets.
Use version calculations provided in the package deal.
Cognos BI Interview Questions
Question 43. What Are The Sources To Create New Query Subjects?

Answer :

A new Query Subject can be created from the following assets:

Model (Query topics & Query Items)
Data Sources (Tables and Columns)
Stored Procedure.
Question 44. What Is Multi Database Access In Cognos ?

Answer :

In Cognos "Framework Manager" a Project can be constructed from a couple of databases. The databases may be both homogeneous or hetrogeneous.

Question 45. What Are Parameter Maps?

Answer :

A Parameter Map is a key value pair used in introduction of conditional Query Subjects.
A Parameter map sub situates the values at the question at runtime.
Question 46. What Is The Default Formats Of Reports?

Answer :

HTML, PDF, CSV, and XML.

Question forty seven. What Are The Different Ways To Modify Multi Lingual Metadata?

Answer :

Macro :- To adjust dynamically
Directly
Question 48. What Is A Macro?

Answer :

A Macro is a run time object, which makes use of the parameter maps and session parameters in developing the conditional query topics.

Question forty nine. What Is Usage Property? And What Are Different Settings To Set Usage Property?

Answer :

It identifies the meant use for the information represented by each query object.

It determines the aggregation regulations of question objects and calculations.

The specific usage property settings are:

 Identified
 Fact
Attribute
 Unknown
Question 50. What Are The Types Of Filters In Framework Manager?

Answer :

In framework manager we will create  varieties of filters.

Stand Alone Filters.
Embedded Filters.
Question 51. Define Model Filter?

Answer :

A clear out is a situation used to restriction the data displayed inside the Report.
Model filter out are reusable.
Question 52. Define Data Restriction?

Answer :

A filter is a situation, which restricts the quantity of facts displayed within the record.

Question fifty three. What Is Condition?

Answer :

An expression that yields a Boolean price. Conditions are utilized in query expressions, query filters, and Boolean record variables that can be used for conditional formatting, patterns, records resources, layouts and blocks.

Question fifty four. What Are The Types Of Filters In Report Studio?

Answer :

In the file studio we can discover two types of filters:

1. Tabular Filters:- These filters are two sorts

a. Summary Filters
b. Detailed Filters
2. Grouped Filter

Question fifty five. What Is A Loop?

Answer :

A Loop is a closed direction which is resulted due to joins.
A Loop reasons overall performance degradation of question execution and incorrect facts will be displayed within the report.
A Loop can be resolved by means of developing the quick cuts (Alias).
Question fifty six. What Is Alias Table?

Answer :

An opportunity call for a desk generally utilized in self joins.

Question fifty seven. What Are The Uses Of Alias Table?

Answer :

The makes use of of Alias Table are:

To resolve the Loops.
To create self-joins with in a desk.
To offer change join structure
Question fifty eight. What Is Associated Data Item?

Answer :

A Data Item connected to the institution records object. Associated records object suppress replica information values however do not generate a manipulate smash. The associated column presentations only one information values for the group with which it's miles related.

Question fifty nine. What Is Automatic Association?

Answer :

The institution association of a newly created precis. The location of the group in which you create the precis determines its computerized affiliation.

Question 60. What Is An Ambiguous Relationship?

Answer :

An ambiguous dating is where there are multiple courting paths between one or greater query topics leaving a couple of options for a way to write a query.

Question 61. What Is A Join And Types Of Joins?

Answer :

A Join identifies the columns from one desk which can be used to link to some other desk.

A Join is typically fashioned by using a overseas key definition inside the database.

Types of Joins:-

Equi-joins
Non equi-joins
Outer joins
Question sixty two. What Is A Dimension?

Answer :

A wide grouping of descriptive statistics approximately a first-rate aspect of a enterprise, such as products, dates, or markets. Each measurement includes exceptional tiers of individuals in a single or more hierarchies, and an optionally available set of calculated participants.

Question sixty three. What Is A Conformed Dimension?

Answer :

If a Dimension is hooked up to more than one fact tables then it is called as Conformed Dimension.

Question sixty four. What Is A Junk Dimension?

Answer :

A randomly used measurement is Junk Dimension

Question 65. Define Surrogate Key?

Answer :

It has system-generated synthetic number one key values, which lets in to keep ancient information inside the Data Warehouse extra efficaciously.

Question 66. What Are The User Interface Components

Answer :

Cognos Connection
Report Studio
Query Studio
Frame work manager
Cognos configuration