Data & Intelligence

Flexible Meta Models and IBM Cognos Framework Manager

A metadata model is “a gathering of Meta information that includes both physical information and business information for one or more datasources and is the foundation for both future modelling and report development within an organization”.

Meta-model flexibility can be defined as the ability of a (Meta) model to:

  • Easily expand and grow (to support other reporting needs) and
  • Be extremely easy to use (when generating query or report requests).

In a business reporting environment, IBM Cognos Framework Manager is “the” metadata modeling tool that solves for this. Framework manager enables performance management on normalized and de-normalized relational data sources and a variety of OLAP data sources.

With only a little foresight and planning, a “framework manager model developer” can deliver large gains by creating models that grow with users and are easy to use, support and maintain.

So let’s “kick the tires”.

In Framework Manager, you work in the context of a “project”, which holds all of the “objects” that you organize for your users to use. To create a project:

From the Welcome page, click Create a new project.











In the New Project page, specify a name and location for you project (mine is the “Stingray” project), and click OK.










Hint – if this is your first project with Framework Manager, clear the Use Dynamic Query Mode checkbox! – You’ll then be asked to select the design language for the project and click OK. The Metadata Wizard displays next where you can select an existing datasource, create a new one or skip this step entirely. A data source connection supplies the information that IBM Cognos BI needs to connect to a database. You can customize data source connections to meet the needs of users.

Let’s setup a new datasource, so, select “Data Sources” and click Next, then select New… You’ll see the “Welcome – New Data Source wizard” (again, click Next) and then specify a name and description for your datasource.















Click Next, then you specify your connection information (mine is a 2012 SQL database, so I selected “SQL 2012 Native Client”), then clicked Next:












You’ll then provide the server name, database name (mine is named “Surfer”) and a user name and password that will be used to access the database:







Data Intelligence - The Future of Big Data
The Future of Big Data

With some guidance, you can craft a data platform that is right for your organization’s needs and gets the most return from your data capital.

Get the Guide






















Before proceeding, always test your connection! After you’ve verified a “successful connection”, you can set the DB commands you want to allow and click Finish!











Success! We’ve got a datasource for our project:








Next, select the database objects you want to include in your project:



















Click Next. The Generate Relationships dialog will be presented, for my project; I left the default selections (you can check the product documentation for specifics on each setting). Click Import:




















Framework Manager will tell you when it completes the import processing and you can then click Finish.

We now have a new project (Stingray) which includes a relational datasource. All projects are displayed in the project page, where you design, package, and publish project metadata:













If you’d like, you can add additional datasources to yourproject or just begin your modeling. Before starting though, you should understand proven practices around naming and namespaces and be familiar with the new Framework Manager feature, object validation — but you’ll have to wait for the next post for that (I’ll walk through the basic framework operational features as well and tell you all about my latest project involving IBM Cognos Framework Manager!).

Thanks for reading.

About the Author

Mr. Miller is an IBM certified and accomplished Senior Project Leader and Application/System Architect-Developer with over 30 years of extensive applications and system design and development experience. His current role is National FPM Practice Leader. His experience includes BI, Web architecture & design, systems analysis, GUI design and testing, Database modeling and systems analysis, design, and development of Client/Server, Web and Mainframe applications and systems utilizing: Applix TM1 (including TM1 rules, TI, TM1Web and Planning Manager), dynaSight - ArcPlan, ASP, DHTML, XML, IIS, MS Visual Basic and VBA, Visual Studio, PERL, Websuite, MS SQL Server, ORACLE, SYBASE SQL Server, etc. His Responsibilities have included all aspects of Windows and SQL solution development and design including: analysis; GUI (and Web site) design; data modeling; table, screen/form and script development; SQL (and remote stored procedures and triggers) development and testing; test preparation and management and training of programming staff. Other experience includes development of ETL infrastructure such as data transfer automation between mainframe (DB2, Lawson, Great Plains, etc.) systems and client/server SQL server and Web based applications and integration of enterprise applications and data sources. In addition, Mr. Miller has acted as Internet Applications Development Manager responsible for the design, development, QA and delivery of multiple Web Sites including online trading applications, warehouse process control and scheduling systems and administrative and control applications. Mr. Miller also was responsible for the design, development and administration of a Web based financial reporting system for a 450 million dollar organization, reporting directly to the CFO and his executive team. Mr. Miller has also been responsible for managing and directing multiple resources in various management roles including project and team leader, lead developer and applications development director. Specialties Include: Cognos/TM1 Design and Development, Cognos Planning, IBM SPSS and Modeler, OLAP, Visual Basic, SQL Server, Forecasting and Planning; International Application Development, Business Intelligence, Project Development. IBM Certified Developer - Cognos TM1 (perfect score 100% on exam) IBM Certified Business Analyst - Cognos TM1

More from this Author

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Subscribe to the Weekly Blog Digest:

Sign Up