Reader small image

You're reading from  IBM Cognos 10 Framework Manager

Product typeBook
Published inMay 2013
PublisherPackt
ISBN-139781849685764
Edition1st Edition
Right arrow
Author (1)
Terence Phillip Curran
Terence Phillip Curran
author image
Terence Phillip Curran

Terry Curran gained an interest in computers while studying for his first degree in Biological Chemistry at the University of Kent. He went on to work as a computer operator for a national supermarket company. After working for several years as a computer operator, he went to Brighton Polytechnic, leaving with a Higher National Diploma in Computer Studies. Upon completion of his studies, he worked as a computer advisor at the City of London Polytechnic, assisting staff and students with their computer problems, and providing support for the various database systems in use across the Polytechnic. After taking voluntary redundancy from this post, he proceeded to the University of Stirling where he gained an MSc in Software Engineering. After graduating from the University of Stirling, Terry commenced working for a software consultancy company. While working for this company, Terry assisted with the writing of a software package for the publishing industry using Cognos PowerHouse. While working for this company, Terry gained experience in Business Intelligence Reporting tools, being asked to familiarize himself with Cognos Impromptu and PowerPlay in order to promote the use of these tools to clients. After this company ceased trading, Terry embarked on a career as a freelance computer consultant and contractor, using his experience with Cognos PowerHouse, various computer systems and databases, and Cognos Impromptu and PowerPlay, and later Cognos 8 and Cognos 10. Terry continues to work as a freelance Cognos Business Intelligence consultant and contractor, making use of his extensive knowledge and experience of IBM Cognos Business Intelligence Reporting. During the past 15 years, Terry has worked for a range of different industries including aviation, pharmaceuticals, insurance, logistics, and manufacturing to name a few. Terry is currently working for Ultra Electronics Command and Control Systems as a freelance Cognos consultant. Terry Curran was a technical reviewer for the book IBM Cognos 8 Report Studio Cookbook, Packt Publishing.
Read more about Terence Phillip Curran

Right arrow

Importing relational data


To start the import of your relational database metadata into your Framework Manager project, carry out the following steps:

  1. Start the Framework Manager, and choose Create a new project:

  2. Give your project a name, choose the location where the project model will be stored, and then click on the OK button.

    Note

    IBM Cognos now recommends that all new Framework Manager models use the Dynamic Query Mode for all data sources.

  3. At the bottom left of this dialog screen, there is a checkbox labeled Use Dynamic Query Mode. If you want to turn on the Dynamic Query Mode for your model, then check this box; otherwise leave the box unchecked.

    Tip

    It is not necessary to select Dynamic Query Mode at this stage as it may also be selected later when your package is published.

  4. Choose your language for the project, and then click on the OK button:

  5. Choose the metadata source for the project and then click on the Next > button:

  6. By default, the Framework Manager will choose Data Sources, which...

lock icon
The rest of the page is locked
Previous PageNext Page
You have been reading a chapter from
IBM Cognos 10 Framework Manager
Published in: May 2013Publisher: PacktISBN-13: 9781849685764

Author (1)

author image
Terence Phillip Curran

Terry Curran gained an interest in computers while studying for his first degree in Biological Chemistry at the University of Kent. He went on to work as a computer operator for a national supermarket company. After working for several years as a computer operator, he went to Brighton Polytechnic, leaving with a Higher National Diploma in Computer Studies. Upon completion of his studies, he worked as a computer advisor at the City of London Polytechnic, assisting staff and students with their computer problems, and providing support for the various database systems in use across the Polytechnic. After taking voluntary redundancy from this post, he proceeded to the University of Stirling where he gained an MSc in Software Engineering. After graduating from the University of Stirling, Terry commenced working for a software consultancy company. While working for this company, Terry assisted with the writing of a software package for the publishing industry using Cognos PowerHouse. While working for this company, Terry gained experience in Business Intelligence Reporting tools, being asked to familiarize himself with Cognos Impromptu and PowerPlay in order to promote the use of these tools to clients. After this company ceased trading, Terry embarked on a career as a freelance computer consultant and contractor, using his experience with Cognos PowerHouse, various computer systems and databases, and Cognos Impromptu and PowerPlay, and later Cognos 8 and Cognos 10. Terry continues to work as a freelance Cognos Business Intelligence consultant and contractor, making use of his extensive knowledge and experience of IBM Cognos Business Intelligence Reporting. During the past 15 years, Terry has worked for a range of different industries including aviation, pharmaceuticals, insurance, logistics, and manufacturing to name a few. Terry is currently working for Ultra Electronics Command and Control Systems as a freelance Cognos consultant. Terry Curran was a technical reviewer for the book IBM Cognos 8 Report Studio Cookbook, Packt Publishing.
Read more about Terence Phillip Curran