Skip to main content

FM workflow diagram



FM workflow process diagram:

A windows based tool used to design metadata

Models 

                    import

Datasource------àFM design and create the project

Prepare

the metadata project(Presentation layer)--Prepare 

the project

business view--Create & manage package---setup 

security—

Publish package---Content store(Metadata)---Reporting

interface

 

Metadata source-Cognos Application

•       Cognos impromptu

•       Cognos 10.1 model

•       Cognos Architect

•       Decision stream

•       Data Manager

•       IBM Data Source

 

Third party metadata source:

•       ERWIN

•       Informatica

•       BO Designer

Metadata source-Data source-By using this

option we can connect to the database by

providing database type, server name, user

name and password

 

  Cognos can detect relationships based on:

•       Primary & foreign key

•       Matching indexed columns

•       Matching column names

 

             

                    

Labels:

Comments

Post a Comment

Popular posts from this blog

Data modeling

Data Modeling: Model: Model is business representation of information in one or more data sources OLTP                                    DWH   Model          Model                 Model E-R Model    (modify wih ETL)       Dimensional model (Design based on              (Design based on facts and Measures) Entities&Relationships)   Dimensional Modeling: Is a design methodology for designing a DWH It consists of following 3phases to design the Database 1)Conceptual Modeling: •          Understanding the requirements •     ...
Post a Comment
Read more

Book on IBM Cognos 10 written by me-

Here is a book written by me on IBM Business Intelligence Tool COGNOS which is published at the following link- http://www.amazon.com/dp/B00KKSVGPA/ref=rdr_kindle_ext_tmb Anyone who is having prior knowledge in database like oracle can easily learn to develop the business reports by following the screenshot assisted examples. This book will be a good resource for the students who wish to self learn IBM Cognos software.
Post a Comment
Read more