A model is a collection of metadata that includes physical information and business information for one or more data sources. (Have a quick glance at Define The Model In The Project)
There are 2 types of models defined in cognos10.1 BI
2)DMR model (Dimensionally modeled relational source)
|Learn how to use Cognos, from beginner basics to advanced techniques, with online video tutorials taught by industry experts. Enroll in Free Cognos Training Demo!|
A multi dimensional analysis is a technique to modify the data so that users can view the data at different levels of details
The following are the multidimensional techniques
a)Drill down: It is a process of navigating the data from highest level to lowest level details. A user can view the detailed information.
b)Drill up: It is a process of browsing the data from lowest level to highest level. A user can view the summary data.
A regular dimension contains descriptive and business key information and organizes the information in a hierarchy from the highest level of granularity to the lowest
Each path in the balance hierarchy descends to the same depth.
Ex: The highest level is productline
2nd level is the productype
3rd level is the product
The branches in the unbalanced hierarchy descend to different levels.
Ex: The highest level in the organization is the CEO.
Level 2 is the vice president and CEO’s Executive Assistant.
The Vice Presidents have subordinates but Executive Assistants don’t have any subordinates.
|Related Article: Cognos Interview Questions|
At least one path in the hierarchy skips at least one level.
Ex: Highest level could be continent
Level 2 is County
Level 3 is a city
Level 4 is street
A country such as Vatican city contains only streets no cities
A member of the hierarchy has more than one parent
Regular dimension— Hierarchy— Levels—- Attributes— Roles(Key,Caption)
It is defined as a collection of facts.
You can create a measure dimension for one or more query subjects that have a valid relationship between them.
Model measure dimensions should be composed of only quantitative items.
Ex: Key performance indicators like Sales, Net profit
A scope defines a relationship between the regular dimension and the measure dimension.
Ravindra Savaram is a Content Lead at Mindmajix.com. His passion lies in writing articles on the most popular IT platforms including Machine learning, DevOps, Data Science, Artificial Intelligence, RPA, Deep Learning, and so on. You can stay up to date on all these technologies by following him on LinkedIn and Twitter.