IBM Planning Analytics Training

• Getting Started with TM1 
• TM1 Architecture 
• Building Blocks of TM1 
  • Dimensions 
  • Hierarchies 
  • Levels 
  • Measures 
  • Cubes 
  • Member 
  • Attribute 
• TM1 Components 
• Installing TM1 
• Creating a New TM1 Data Server 
• Connecting to an Existing TM1 Data Server     

• Creating dimensions manually 
• Creating a Month dimension 
• Adding additional levels in Month dimension 
• Adding "Next" and "Previous" attributes to the "Month" dimension 
• Creating dimensions using turbo integrator 
• Execution of scripts for a TM1 process 

• Creating subsets using TI process 
• Creating dynamic subsets 
• Creating dynamic subsets using MDX 

• Creating a multi-dimensional Cube 
• Creating a static pick list 
• Creating a subset pick list 
• Re-ordering dimensions in a cube 
• Creating views 

• Loading data using Turbo integrator processes 
• Using formulas in variables 
• Clearing data from a cube using a process 
• Accumulating data using a process. 
• Saving data using a process 

• Creating simple rules 
• Using a rule to override aggregation. 
• Creating a rule to share data between cubes. 
• Creating a pick list using a rule 
• Reviewing a rules worksheet 
• Doing custom calculations in dimensional hierarchies 

• Adding SKIPCHECK and FEEDERS 
• Troubleshooting rules and feeders 

• Loading data from multiple columns into a single column 
• Creating a dimension and a subset in Turbo Integrator 
• Creating a dimension with uneven/unbalanced hierarchy 
• Exporting data to ASCII Text using Turbo Integrator 
• Moving data between versions 
• Moving data using scripts and parameters 
• Creating and Scheduling a Chore 

• Creating a drill-through path to a view in another cube 
• Creating a drill path to an ODBC source 

• Creating currency dimensions and attributes 
• Creating a currency cube 
• Populating currency attributes using control cubes. 
• Creating rules to apply exchange rates and calculate equivalent amount in target currency. 

• Creating a dashboard 
• Creating a button 
• Synchronize 
• Collections 
• Lifecycle management 
• Report bursting 
• Table styles 

• Creating a connection to TM1 database 
• Exploration 
• Worksheet functions 
• Action button 
• Quick, custom, and Dynamic reports 
• Formatting reports 
• Publish reports. 

• TI Scripts for 
  • porfile batch script 
  • Zip the files 
  • Moving the files from one folder to another folder 
  • Load cube from file 
  • Lookup Cube 
  • while loop 
  • Process log cube 
  • Cube clear data 
  • Export Data 
  • Wildcardsearch file 
  • Extract useful text from filename. 
  • Display error messages 
  • Cubesetlogchanges 
  • Process executes duration 
  • Format selection 
  • Adding comments 
• PAX 
  • Creating connection 
  • Exploration 
  • Quick Report 
  • Dynamic Report 
  • Custom Report 
  • Action Button 
  • Action button options 
  • Report Formatting 
  • Publish report. 
• PAW 
  • Creating Dashboard 
  • Synchronization 
  • Process Button 
  • Inserting images 
  • Report bursting 
  • Upload file process 
  • User access control 
  • Lifecycle management 
  • Data spread 
  • Collections 
  • Table Styles 
• Subsets 
  • Creating subsets by MDX 
  • Filter dimension elements using the values from another cube. 
• REST API 
  • Cubewise 
  • TM1PY

Mindmajix offers advanced Cognos TM1 interview questions and answers along with Cognos TM1 resume samples. Take a free sample practice test before appearing in the certification to improve your chances of scoring high.