Pre request installing & Roles in cognos BI
Roles on cognos side:
1. Cognos architect role:
- Meta data modeling as per the report requirement
- Creating projects, creating models, creating packages
2. Cognos administration roles:
- Installations and configurations, creating users, assigning permissions and privileges to users and taking the backups, tuning the servers, providing security to the objects.
3. Cognos report developer:
- Developing the report by going through RRT (report requirement template)
RRT: (report requirement template)
It is a document which contains all the required information to develop a report application
- Cognos is a reporting tool (or) BI tool (or) OLAP tool
- It is a product of IBH
- It is a client server technology
- It is a GUI based tool (graphical user interface)
- IBM cognos BI is a completely web based dynamic business intelligence reporting solution from IBM
Pre request installing cognos:
- Operating system – windows xp professional
- Database – oracle, windows SQL server
- Web server - IIS
- Cognos software
- Where we install cognos the following two types of components
- Windows based component
- Web based component
Windows based component:
- Frame work manager
- Map manager
Web based manager:
- Cognos connection
- Report connection
- Query studio
- Analysis studio
- Event studio
Query subject:
- In cognos terminally a table is called as query subject
- By default every query subject is associated with a query with feature the actual data from database at the time of execution
- Query subjects are two types
- Dimensional query subject
- Fact query subject
Dimensional query subject:
A query subject which contains any identifiers and attributes without any measures is called a dimensional it is symbolically
Fact query subject:
A query subject which contains measures along with dimensions is called a fact query subject.
It is symbolically represented with
Query items:
Columns are called as query items in cognos query items are called categorized in to 3 types
- Identifiers
- Attributes
- Measures
Identifiers:
Key, columns, data columns
These core tutorials will help you to learn the fundamentals of Cognos.For an in-depth understanding and practical experience, explore Cognos Online Training
Attributes:
Descriptive columns
Measures:
Key performance indicators
Note: The default aggregation for measure is “sum”
Eg: at database level; customer (table)
At frame work manager level: customer is called as query subject
Customer:
Custno, cutname, cust_age, cust_add, mail_id, Qty, rename
(Query items)
Identifier: cust no
Attributes: cust names, cust_age, cust_address, mail_id
Measures: Qty rename.
Package:
A package is created by copying all the objects required from the project
- Provide the security to the project before publishing in to content store( database)
For in depth understanding Cognos Training click on