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!.
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.
Description based on publisher supplied metadata and other sources.
Electronic reproduction. Ann Arbor, Michigan : ProQuest Ebook Central, 2021. Available via World Wide Web. Access may be limited to ProQuest Ebook Central affiliated libraries.
Print version: Miller, James D. IBM Cognos TM1 Developer's Certification guide