IBM Cognos TM1 Developer's Certification Guide

Name: IBM Cognos TM1 Developer's Certification Guide | Preparing for your COG-310 certification is more engaging and enjoyable with this tutorial because it takes a hands-on approach and teaches through examples. There are also self-test sections for each exam topic.
Brand: Packt Publishing
Availability: OnlineOnly

Preparing for your COG-310 certification is more engaging and enjoyable with this tutorial because it takes a hands-on approach and teaches through examples. There are also self-test sections for each exam topic.

James D. Miller(Autor*in)

Packt Publishing

1. Auflage

Erschienen am 26. April 2012

240 Seiten

E-Book

ePUB mit Adobe-DRM

Systemvoraussetzungen

E-Book

PDF mit Adobe-DRM

Systemvoraussetzungen

978-1-84968-491-0 (ISBN)

ab 36,99 €

Als Download verfügbar

Merkliste: siehe Preise

Beschreibung

Alle Preise

Weitere Details

Weitere Ausgaben

Inhalt

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

Systemvoraussetzungen

Dateiformat: ePUB
Kopierschutz: Adobe-DRM (Digital Rights Management)

Systemvoraussetzungen:

Computer (Windows; MacOS X; Linux): Installieren Sie bereits vor dem Download die kostenlose Software Adobe Digital Editions (siehe E-Book Hilfe).
Tablet/Smartphone (Android; iOS): Installieren Sie bereits vor dem Download die kostenlose App Adobe Digital Editions oder die App PocketBook (siehe E-Book Hilfe).
E-Book-Reader: Bookeen, Kobo, Pocketbook, Sony, Tolino u.v.a.m. (nicht Kindle)

Das Dateiformat ePUB ist sehr gut für Romane und Sachbücher geeignet – also für „fließenden” Text ohne komplexes Layout. Bei E-Readern oder Smartphones passt sich der Zeilen- und Seitenumbruch automatisch den kleinen Displays an.
Mit Adobe-DRM wird hier ein „harter” Kopierschutz verwendet. Wenn die notwendigen Voraussetzungen nicht vorliegen, können Sie das E-Book leider nicht öffnen. Daher müssen Sie bereits vor dem Download Ihre Lese-Hardware vorbereiten.

Bitte beachten Sie: Wir empfehlen Ihnen unbedingt nach Installation der Lese-Software diese mit Ihrer persönlichen Adobe-ID zu autorisieren!

Weitere Informationen finden Sie in unserer E-Book Hilfe.

Dateiformat: PDF
Kopierschutz: Adobe-DRM (Digital Rights Management)

Systemvoraussetzungen:

Computer (Windows; MacOS X; Linux): Installieren Sie bereits vor dem Download die kostenlose Software Adobe Digital Editions (siehe E-Book Hilfe).
Tablet/Smartphone (Android; iOS): Installieren Sie bereits vor dem Download die kostenlose App Adobe Digital Editions oder die App PocketBook (siehe E-Book Hilfe).
E-Book-Reader: Bookeen, Kobo, Pocketbook, Sony, Tolino u.v.a.m. (nicht Kindle)

Das Dateiformat PDF zeigt auf jeder Hardware eine Buchseite stets identisch an. Daher ist eine PDF auch für ein komplexes Layout geeignet, wie es bei Lehr- und Fachbüchern verwendet wird (Bilder, Tabellen, Spalten, Fußnoten). Bei kleinen Displays von E-Readern oder Smartphones sind PDF leider eher nervig, weil zu viel Scrollen notwendig ist.
Mit Adobe-DRM wird hier ein „harter” Kopierschutz verwendet. Wenn die notwendigen Voraussetzungen nicht vorliegen, können Sie das E-Book leider nicht öffnen. Daher müssen Sie bereits vor dem Download Ihre Lese-Hardware vorbereiten.

Bitte beachten Sie: Wir empfehlen Ihnen unbedingt nach Installation der Lese-Software diese mit Ihrer persönlichen Adobe-ID zu autorisieren!

Weitere Informationen finden Sie in unserer E-Book Hilfe.

Als PDF speichern Als Link merken