This is a continuation from Build a model with IBM Cognos Framework Manager (Part 1). As stated in Part 1, two resources for learning Cognos are the “IBM Cognos 8 Business Intelligence: Official Guide” and the “IBM Cognos Business Intelligence V10.1 Handbook“
When you create a report in Cognos 8 Report Studio or Query Studio, how does IBM Cognos 8 BI know about your data? How does it know how to connect to your databases, and how does it know what the tables and data items are and how they relate to each other?
Creating a new model
To create a basic, but thorough, Framework Manager model from a relational database source, you will need to do the following:
- Create a data source connection (or reference an existing one).
- Create data source query subjects.
- Create model query subjects to resolve modeling challenges, if necessary.
- Set query item properties.
- Relate the query subjects (define the joins).
- Create model query subjects to present a business view.
- Create a package of the items to present to the studio users.
- Publish the package.
Stay tuned for Part 3
Joshua Burkhow
Joshua is working to become a Data Scientist with focus on Analytics, Big Data, Machine Learning, and Statistics. His passion for Data and Information are second to none. He is a certified IBM Cognos Expert with more than 10 years experience in Business Intelligence & Data Warehousing, Analtyics, IT Management, Software Engineering and Supply Chain Performance Management with Fortune 500 companies. He has specializations in Analytics, Mobile Reporting, Performance Management, and Business Analysis.
Top Posts
-
