Cognos interview questions on framework manager relationship

Kishore's Cognos Class Room: Cognos FM Interview Questions and Answers

cognos interview questions on framework manager relationship

Frequently asked cognos Interview Questions with detailed answers and examples. are the characteristics of Cognos, types of reports, framework manager, hierarchies, . It has a foreign key – primary key relation with a dimension table. Session parameter is a variable that framework manager associates with the session properties like the user name and the run locale (machine. Framework Manager Questions. 1. What is Loop in Loop: loop is a closed path (relation) that exists among 3 (or) more tables. For example, if.

If you start with an embedded filter, you can later convert it into a standalone expression that you can apply to other dimensions or query subjects. What is a usage Property in Framework Manager? Usage property identifies the intended use for the data represented by each query item and it determines the aggregation rules of query items and calculations.

The different usage property settings are Identifier, Fact, Attribute, and Unknown. What is the difference between Model and a Package? A model is a logical view of the enterprise, where in a package is a subset of the model.

cognos interview questions on framework manager relationship

This helps in reducing redundant copies of the database objects in several places. For example, you can create one single model for the entire warehouse and choose to create multiple packages for each subject area which specific focus. In security, a collection of user accounts and user groups from an authentication provider. 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. 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.

  • Latest Cognos Framework Manager Interview Questions.
  • Cognos Interview Questions & Answers
  • Cognos Interview Questions And Answers

What is meant by Governors? To apply privileges and restrictions for a user class.

Cognos Framework Manager Interview Questions & Answers

All query subjects in the Logical layer should reference back to the database layer. Assign standardized and business-defined terms to the database columns, giving them business context. Add calculations, and filters including stand-alone filters, embedded filters and security-based filters.

Arrange query subject items in a user-friendly manner. You can create folfer and make use of folders to group similar items 3.

The presentation layer is used only as an organization structure in order to make it easier for report writers to more easily find their needed information.

This layer includes only shortcuts to existing items in the logical layer, plus organization items such as folders and namespaces. What are model filters available in cognos FM?

IBM Cognos 10 Framework Manager Determinants

The model filters are reusable which can be used for multiple reports. There are two types of model filters: Standalone Filter Q What is the difference between standalone and embedded filter? It is created at name space level and it is available as a separate object in the model.

It can be applied for any query subject in the model. It can be reused as per the requirement. The embedded filter is created at query subject level. The scope of this filter is for the particular query subject. What are the sources to create Query Subjects? The following are the sources to create a new query subject: What are the usage properties of Query Item with Example?

A query item is defined with the following usage properties: A query item with string data type and which provides a descriptive information are used as attributes.

cognos interview questions on framework manager relationship

Product Name, Product Desc, Address etc. A query item with the numeric data type and Key performance indicator is used as a Fact. Quantity, Revenue, Profit etc. Facts are contains numeric data that can be grouped or summarized. It always Key performance indicator, such as Product Cost. Identifiers are could be an indexed column or the date or time type.

Sometimes, it may be numeric data but not Key performance indicator, such as Employee Id. Basically Date filed treat as Identifiers such as shipment date.

But if the table contains more date fields then we can assign some date fields as attributes as per the business requirement. Explain in details about Project Governors each Setting. Please go through to our Blog. A Macro is a dynamic object which returns a value at query run time.

Macro uses parameter maps and session parameter modify the metadata at query run time. A macro is delimited by a number sign at the beginning and at the end.

Everything between the number signs is treated as a macro expression and is executed at run time. This model supports to create regular dimensions and measure dimensions to perform multidimensional analysis such as drill up, drill down, drill across. A dimension is a broad group of descriptive data about the major aspects of a business.

Determinants are imported based on the unique key and index information available in the database.

Cognos Framework Manager Interview Question and Answers

It provide control over granularity for query subjects. Determinants are generally used to avoid double-counting in de-normalized data. Sometimes, while joining tables, data present in the joining column may not be present at the lowest level of granularity. This causes the data of higher granularity to repeat in multiple rows, causing data to be over-counted. It is used in Dimension Table.

In a Time dimension, Day Key is a unique determinant that contains data at lowest level of granularity however, Month Key is an non-unique determinant. When you join Time dimension with Product fact using Month Key, you may see same records repeated for Month those many days present in that month.

Stored procedure query subjects do not have determinants. You cannot use determinants with user-entered SQL that was specified in a query defined in Report Studio. Difference between shortcut and alias shortcut in Framework Manager? Regular shortcuts, which are a simple reference to the target object.

So if you modify the the base object then automatically your shortcuts object like Query Subjects will be modified. Alias shortcuts, which behave as completely independent behavior. Alias shortcuts are available only for query subjects and dimensions. Explain Stitch Query with example?

A query that uses multiple facts from different underlying tables is split into separate queries for each underlying fact table. Each single fact query refers to its respective fact table as well as the dimensional tables related to that fact table. Another query is used to merge these individual queries into one result set. This later operation is generally referred to as a stitched query.

Cognos Interview Questions & Answers – Techno Tutorial Hub

Can we create two hierarchies in one regular dimension? What are the different types of security in Framework Manager? In Framework Manager, security is a way of restricting access to metadata and data in reports.

There are different types of security in Framework Manager: You create a security filter and apply it to a specific query subject. The filter controls the data that is shown to your users when they set up their reports. You secure an object directly by allowing users access to the object, denying users access to the object, or keeping it hidden from all users.

You apply security to a package and identify who has access to that package. Each type of security uses users, groups, and roles to define access. A session parameter is a variable in Framework Manager associates with a session. For example, user ID and preferred language are both session parameters. Because session parameters are key and value pairs, you can think of each session parameter as an entry in a parameter map named Session Parameters.

There are two types of session parameters: These parameters are predefined and stored in Content Manager. By default, the following session parameters display in Framework Manager: If you log on anonymously, you will see Anonymous.

These parameters must have their values set within the scope of objects in the Framework Manager model. The scope can include the use of existing environment session parameters, as well as static values. They are set in the project and can be published with a package. What is cardinality and how to define cardinality in FM? The cardinality of a relationship is the number of related rows for each of the two query subjects.