Franklin

IBM Cognos TM1 Developer's Certification guide.

Author/Creator:
Miller, James D.
Publication:
Olton : Packt Publishing, Limited, 2012.
Format/Description:
Book
1 online resource (266 pages)
Edition:
1st ed.
Status/Location:
Loading...

Options
Location Notes Your Loan Policy

Details

Other records:
Subjects:
Microeconomics.
Economics.
Form/Genre:
Electronic books.
Summary:
This book is packed with real word examples. Each major certification topic is covered in a separate chapter, which helps to make understanding of concepts easier. At the end of each chapter, you will find a variety of practice questions to strengthen and test your learning. If you are a beginner to intermediate level Cognos TM1 developer looking to add an important IBM certification to your resume but don't know where to start, this book is for you!.
Contents:
Intro
IBM Cognos TM1 Developer's 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 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 example-using rules
Loading data with lookup cubes
Spreading data with lookup cubes
Summary
Two minute drill
Self test
8. Time Considerations
The importance of time
Granularity-the lowest level of time detail required
Month-two time dimensions
Month-one 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.
Notes:
Description based on publisher supplied metadata and other sources.
Local notes:
Electronic reproduction. Ann Arbor, Michigan : ProQuest Ebook Central, 2021. Available via World Wide Web. Access may be limited to ProQuest Ebook Central affiliated libraries.
Other format:
Print version: Miller, James D. IBM Cognos TM1 Developer's Certification guide
ISBN:
9781849684910
9781849684903
OCLC:
794492405