IBM Cognos TM1 Developer's Certification guide. Preparing for your COG-310 certification is more engaging and enjoyable with this tutorial be

IBM Cognos TM1 Developer's Certification guide. Preparing for your COG-310 certification is more engaging and enjoyable with this tutorial be - Opis

IBM Cognos TM1 is enterprise planning software that provides a complete, dynamic environment for developing timely, reliable and personalized forecasts and budgets. It is a real time, in memory tool that helps any sized business perform planning, budgeting and forecasting as well as other financial exercises. This book prepares you to master COG-310 certification using an example-driven method that is easy to understand.The IBM Cognos TM1 Developer's Certification guide provides key technical details and background to clear the current IBM Cognos TM1 Developer (test COG-310) certification exam.This certification book covers all the modules of the certification clearly and in depth.The initial chapters cover in detail the components that make up Cognos TM1 and designing and creating dimensions and cubes. The book then dives deep into basic and advanced scripting using TurboIntegrator and then we learn to understand and write basic Rules. We then learn about the drill-through functionality of TM1, virtual and lookup cubes and lastly Time, and presenting and reporting data Spis treści:
IBM Cognos TM1 Developers Certification Guide
Table of Contents
IBM Cognos TM1 Developer's Certification Guide
Credits
About the Author
About the Reviewer
www.PacktPub.com
Support files, eBooks, discount offers and more
Why Subscribe?
Free Access for Packt account holders
Instant Updates on New Packt Books
Preface
Certification
Benefits of certification
Self assessment of skills
Know what you know
Identify your areas of (...) więcej weakness
Resume builder
The certification exam
Exam specifics
Length
Format
Maximum time allowed
Topics
Minimal score required to pass
Test languages
Location of exam
What this book covers
What you need for this book
Who this book is for
Conventions
Reader feedback
Customer support
Errata
Piracy
Questions
1. The Components of TM1
The components of TM1
Client components
TM1 Client
TM1 Perspectives
Features of TM1P
TM1 Architect
TM1 API
Server components
TM1 Admin Server
TM1 CFG
TM1 Server
TM1 Web
Setting up a worksheet reference
TM1 Top
TM1 Contributor
Summary
Two minute drill
Self test
2. Dimensions and Cubes
Introduction to cubes and dimensions
Dimensions
Elements
Editing element properties
Aggregations
Consolidating using dimension hierarchies
Element attributes
Descriptive attributes
Alias attributes
Display format attributes
Creating dimensions using the Dimension Editor window
Ordering elements in a dimension
Cubes
Loading cubes
Viewing cube characteristics
Lookup cubes
Control cubes
Security
Client and group administration
Object attribute and properties control
Performance monitoring
Hold tracking by username
Cube replication
Replicating your cubes between your servers
Replication must knows
Summary
Two minute drill
Self test
3. TurboIntegrator (TI)
Introduction
Data sources available with TurboIntegrator
The Data Source tab
The Variables tab
Defining your own variables!
More on the Variables tab
Local variables
Some very special local variables
The Maps tab
Cube tab
Dimensions tab
The Advanced tab
Order of operations within a TurboIntegrator process
The Schedule tab
Key notes on TurboIntegrator processes
String lengths limit in TurboIntegrator
Reserved words
Functions
Cube logging
Summary
Two-minute drill
Self Test
4. Rules
Rules
Rules how do they really work?
Sparsity
Combinatorial explosion
Wikipedia
Dissection of Cognos TM1 Rules
Rules calculation statements
Area definition
Area definition syntax
Special characters and non-unique element names
The CONTINUE function and area definitions
Numeric, consolidation, or string (oh my!)
Formulas
Numeric constants
Arithmetic operators
Using conditional logic
Cube references
External cube references
Drill assignment rule
More important Rules facts
Rules performance
Key notes on Rules behaviors
Rule feeders
Persistent feeders
The special feeders
Modifying rules and feeders
Guidelines for simple feeders
Troubleshooting
Rules Tracer
Summary
Two minute drill
Self test
5. Advanced Techniques for TI Scripting
ETL
TM1 TurboIntergrator review
The Data Source tab
Using TurboIntegrator Variables
Dynamic Definitions
Important TurboIntegrator functions
ExecuteProcess
ItemSkip
ProcessBreak, ProcessError, and ProcessQuit
View handling
ViewZeroOut
PublishView
CubeClearData
CellIsUpdateable
SaveDataAll
SubsetGetSize
Security functions
Rules and feeders Management functions
CubeProcessFeeders
DeleteAllPersistentFeeders
ForceSkipCheck
RuleLoadFromFile
SubsetCreateByMDX
Order of operations within a TurboIntegrator process
Aliases in TurboIntegrator functions
More on data sources
CubeSetLogChanges
Revisiting variable types
TurboIntegrator sections
Summary
Two minute drill
Self-Test
6. Drill-through
What is drill-through?
Components of TM1 drill-through
Where to drill from?
Drill-through (source) types
TM1 cube views
MaximumViewSize
ODBC
Other
Drill process
Creating a drill process
Drill process parameters
Editing drill processes
Drill rules
Feeders
Area definition
Creating a drill assignment rule
Drill-through area examples
Assigning drill processes
Conditional drill rules
Drilling from an Excel Slice
Drilling from an Active Form
Drill-through performance
Summary
Two minute drill
Self-test
7. Virtual and Lookup Cubes
TM1 cube types
Virtual cubes
Virtual cube creation
Feeders
Intercube feeders
Submitting a forecast to a virtual cube
Unmatched dimensionality
Conditional rules
Using conditional rules within a virtual cube
Consolidating data with a virtual cube
Reporting with virtual cubes
Other advantages of virtual cubes
Additional reporting options
Lookup cubes
Translation of data
Lookup cube exampleusing rules
Loading data with lookup cubes
Spreading data with lookup cubes
Summary
Two minute drill
Self test
8. Time Considerations
The importance of time
Granularitythe lowest level of time detail required
Monthtwo time dimensions
Monthone time dimension
Weeks
Days
Lower than day detail
Date format flexibility
Time dimension maintenance
Date and time Rules functions
DATE
DATES
DAY
DAYNO
MONTH
NOW
TIME
TIMST
TIMVL
TODAY
YEAR
Summary
Two minute drill
Self-test
09. Data Presentation and Reporting
Basic data browsing in TM1
Cube Viewer
In-Spreadsheet Browser
Modifying your view of data
Stacking a title dimension as a row dimension
Saving the view
Formatting view cells
Zero suppression
Worksheets
Slicing a view
Snapshots
Active Forms
Refreshing and recalculating
Deleting an Active Form
Active Forms and special formatting
Formatting Active Forms
Active Form default formatting
Modifying default formatting
Applying formatting
TM1 reports
TM1 Print Report Wizard
Selecting the sheets
Selecting the title dimensions
Selecting workbook print options
TM1 Web
TM1 Websheets
TM1 Web Cube Viewer
Creating a new TM1 Web cube view
Custom display formats
Summary
Two minute drill
Self-Test
Index O autorze: James D. Miller is an IBM certified expert, Master Consultant, Application/System Architect with +35 years of applications & system design/development experience across multiple platforms, technologies and data formats, including Big Data. His experience includes IBM Planning Analytics, BI, Web architecture & design, systems analysis, GUI design & testing, Data modeling, design, and development of OLAP, Client/Server, Web & Mainframe applications and systems utilizing: Planning Analytics Workspace (PAW), IBM Watson Analytics, Cognos BI & TM1, Framework Manager, dynaSight/ArcPlan, ASP, DHTML, XML, MS Visual Basic, VBA, PERL, R, SPLUNK, MS SQL Server, ORACLE, etc.He has authored numerous books, including Implementing Splunk - Second Edition; Mastering Splunk; Hands-On Machine Learning with IBM Watson; IBM Watson Projects; Statistics for Data Science; Mastering Predictive Analytics with R - Second Edition and others.Project areas include those with Data Analytics, Planning Analytics, and FOPM projects, holding various roles from architect, developer, technical and project leader. mniej