Cognos Framework Manager Vs. Data Modules - Senturus
Cognos Framework Managervs. Data ModulesComprehensive comparison plus key feature gaps2
GoToWebinar control panelClick arrow to restorefull control panelSubmit questionsin this section3
To obtain this presentationVisit the Resource Libraryon the Senturus websiteto download this presentationand explore other assets:senturus.com/resources4
Agenda Introductions Quick intro of the two tools Comparisons Discus some key FM modeler issues with DMs and demosome solutions Senturus overview Additional resources Q&A5
IntroductionsPedro IningMichael WeinhauerPrinciple BI Analytics ArchitectDirectorSenturus, Inc.Senturus, Inc.6
The Cognos modeling legacyData ModulesData Sets7
Top questionShould I replace all my existing Framework ManagerModels/packages with data modules? Existing FM production packages may be working fine and theremay be no need to port a 1 for 1 implementation to a datamodule IBM has no plans to remove product support for FM But you may want to give a serious look at new modelingtasks to start with data modules8
Cognos Framework Manager Primary modeling tool in Cognos ReportNet, Cognos 8,Cognos 10 Still used widely in Cognos Analytics 11 some customersonly use packages from FM IT centric tool used by developers and data modelers Not really meant for ‘end users’ but some have tried From an era of the ‘single source of truth DWH’ No future enhancements are planned for this product9
Cognos data modules Web based end-user focused data blending, modeling,transformation tool debuted on Cognos Analytics 11.0 IBM’s response to data democratization and other tools likeTableau and Microsoft Power BI 11.1 significantly closed some of the technical gaps betweenFM and DM All future development resources will be focused on DMenhancements10
Data modules – integrate many sourcesData server connectionDatabasesFM packages11
What are data modules still missing? DMR – dimensionally modeled relational Object based security Model branches and merges – team-based modeling Parameter maps Multi-lingual packages Complex row-level security implementations FM style namespaces (but we can somewhat simulate) FM style packages12
What data modules do thatFramework Manager can’t do Easy integration of uploaded files – Excel, CSV Simple data cleansing built-in Easy hierarchy creation – navigation paths Automatic creation of relative time filters (YTD,MTD etc.) In-memory use of datasets Data grouping Web-based interface13
Common FM modeler issues withdata modules Web UI not as precise and snappy as FM Lack of layers, namespaces, model query subjects No alias shortcuts Determinants14
Namespaces and model querysubjects The typical FM paradigm oflayers and namespaces aremissing I want a physical layer that Ican hide How can I publish a centrallycontrolled data module?15
Alias shortcuts – custom table viewsNecessary for “role playing”dimensions16
Determinants vs. column dependencies Needed for multi-grain multifact queries FM used determinants DM has simplified theconcept with columndependencies17
PollGoing forward, I plan to do Cognos metadata modeling with:(select all that apply) Framework Manager Data modules Microsoft Analysis Services Other/undecided18
Got Cognos challenges? Time consuming data preparation? Can’t drill down to detailed data? Slow performance? Poor user adoption?Get solutions:The Senturus Architectural Assessment Best practices modelingMetadata health checkPerformance tuningSelf-serviceBest tool for the job (FM vs. DM)19
The authority inbusiness intelligenceExclusively focused on BI,Senturus is unrivaled in itsexpertise across the BI stack.20
Bridging the data and decisioning gapBusiness needsDecisions and actionsAnalysis-ready data21
Full spectrum BI services Dashboards, reporting and visualizations Data preparation and modern data warehousing Hybrid BI environments (migrations, security, etc.) Software to enable bimodal BI and platform migrations BI support retainer (expertise on demand) Training and mentoring22
A long, strong history of success 19 years 1300 clients 2500 projects23
Expand yourknowledgeFind more resourceson the Senturus website:senturus.com/senturus-resources24
Upcoming events Cognos Analytics: Dashboards or Reports? Matching tools to business requirements Tuesday, Jul 28, 2020, 11am PT/2pm ET25
Complete BI trainingTailored group sessionsMentoringInstructor-led online coursesSelf-paced learning26
Additional resourcesUnbiased product reviewsTechnical tipsInsider viewpointsMore on this subjectProduct demosUpcoming events27
Q&A If your question or issueis broader than what weare able to answer today,contact us at: info@senturus.com and we will set up afree consultation.28
Thank Youwww.senturus.com888 601 6010info@senturus.com 2020 by Senturus, Inc. This presentation may not be reused or distributed without the written consent of Senturus, Inc.
Cognos Framework Manager Primary modeling tool in Cognos ReportNet, Cognos 8, Cognos 10 Still used widely in Cognos Analytics 11 some customers only use packages from FM IT centric tool used by developers and data modelers Not really meant for 'end users' but some have tried From an era of the 'single source of truth DWH'
found in the Cognos Connection User Guide, a link to which can be found on the Resources tab in the IIT Cognos portal. 2. About the Cognos Portal The IIT Cognos Portal (aka "Cognos Connection") allows users to access Cognos reports and launch the various Cognos tools for authoring reports and queries based on data stored
IBM Cognos ReportNet Model Upgrade 367 Verifying the Model in IBM Cognos ReportNet 367 Opening and Upgrading the Model 368 Verifying and Repairing the Upgraded IBM Cognos ReportNet Model 370 IBM Cognos 8.1 or 8.2 Model Upgrade 374 Verifying the Model in IBM Cognos 8.1 or 8.2 374 Opening and Upgrading the IBM Cognos 8.1 or 8.2 Model 375
2 IBM Cognos Business Intelligence Version 10.1.1: Using IBM Cognos Series 7 and IBM Cognos Business Intelligence in the Same Environment. Chapter 2. Set up Interoperability Between IBM Cognos Series 7 and IBM Cognos BI Set up interoperability before and during migration to provide continuity to your
IBM Cognos Analysis for Microsoft Excel 10.2.0 has feature enhancements in several key areas: v IBM Cognos Analysis for Microsoft Excel is now integrated with IBM Cognos TM1 data sources. Use IBM Cognos Analysis for Microsoft Excel with IBM Cognos TM1 data sources to enter and write back values to TM1 cubes. For more information, see
In this guide, the current Cognos version 10 user interface is called the Cognos 10 UI. The Cognos version 11 user interface is called Cognos 11 UI. . Query Studio, and Workspace. HINTS The green dot displayed in the Cognos 11 UI indicates a UI hint is available for that feature. Clicking the green dot opens a brief description of the feature.
used outside of Cognos. The xml can be opened, modified, or copied from one Cognos environment to another. The follow steps can be used to copy your Cognos 10 BI Reports over to Cognos 11 Analytics: 1) In Cognos 10 - In order to view a reports specification (spec), open it up to view in Reports Studio.
An Introduction to Cognos AP Dashboard Version: 2.0 Dec 2020 Page 1 of 6 Cognos AP: Dashboard, Invoice Enquiry and Supplier Enquiry Background information Cognos Cognos information is built overnight, from a snapshot of CUFS taken at midnight That means that any changes you made in CUFS, won't update to Cognos until the next day
Consider the task of buying a copy of AI: A Modern Approach from an online bookseller. Suppose there is one buying action for each 10-digit ISBN number, for a total of 10 billion actions. The search algorithm would have to examine the outcome states of all 10 billion actions to find one that satisfies the goal, which is to own a copy of ISBN 0137903952. A sensible planning agent, on the .
