• USA : +1 973 910 5725
  • INDIA: +91 905 291 3388
  • info@tekslate.com
  • Login

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:

  1. Operating system – windows xp professional
  2. Database – oracle, windows SQL server
  3. Web server – IIS
  4. Cognos software

 

  • Where we install cognos the following two types of components
  1. Windows based component
  2. Web based component

Windows based component: 

  1. Frame work manager
  2. Map manager

Web based manager:

  1. Cognos connection
  2. Report connection
  3. Query studio
  4. Analysis studio
  5. 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

 

  1. Dimensional query subject
  2. Fact query subject

 

Dimensional query subject:

A query subject which contains any identifiers and attributes without any measures is called a dimensional it is symbolicallyScreenshot_3

Fact query subject:

A query subject which contains measures along with dimensions is called a fact query subject.

It is symbolically represented withScreenshot_1

 

Query items:

Columns are called as query items in cognos query items are called categorized in to 3 types

  1. Identifiers
  2. Attributes
  3. 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 indepth understanding Cognos Training click on

Summary
Review Date
Reviewed Item
Pre request installing & Roles in cognos BI
Author Rating
5

“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at info@tekslate.com, we will update the article in 24 hours.”

0 Responses on Pre request installing & Roles in cognos BI"

    Leave a Message

    Your email address will not be published. Required fields are marked *

    Site Disclaimer, Copyright © 2016 - All Rights Reserved.

    Support


    Please leave a message and we'll get back to you soon.

    I agree to be contacted via e-mail.