Radical Technologies
  • Starting Data Science and Analytics with Spark, Scala ,R and Python…Devops with- Chef Puppet Docker Ansible Salt Stack Jenkins Git Nagios Jira….VMWARE VCP 5.5 + 6.0 and 6.5 On Cisco UCS Server ….AWS | Salesforce | Openstack | Azure – Implementation,Migration  and  certification oriented Training …Windows SCCM And Server Deployment training with real time examples……Starting Training on Netapp Data Ontap Cluster Mode + 7.0 Mode…Appear for any RedHat Practical Exams at Any Time through KOALA-Redhat Systems…Discounted Oracle , Microsoft Exam Vouchers available….Exam Centres at Aundh & Kharadi in Pune, HSR Layout in Bangalore

  • COMBO COURSES

    RedHat Linux, Vitualization, Cloud, Hadoop,Datawarehousing Combo Courses with Discounted Price.....

    Readmore..

  • ONLINE TRAINING

    Radical Technologies provides best Online Training with Real-time Projects by Industry Experts....

    Online Schedule

  • BATCH SCHEDULE

    Best Classroom Training from Industry Consultants on High end Real-time Enterprise servers...

    Classroom Schedule

  • CERTIFICATIONS

    Authorized Exam Center for RedHat, Oracle, IBM, Microsoft, Cisco, Salesforce, AWS etc...

    Readmore..

COGNOS TM1

IBM Cognos TM1: Designing and Developing Applications

Target Audience: Application Developers

Qualification: Any Degree

Prerequisites:
SQL
Data warehousing basic concepts
Business Knowledge

Duration of Training :6 weekends

 

SYLLABUS 

1. Introduction to IBM Cognos TM1
1.1. Financial Performance Management
1.2. What is OLAP?
1.3. OLAP Vs OLTP
1.4. Dimensional Analysis Example
1.5. Examine OLAP Data Structures
1.6. TM1 OLAP Solution
1.7. Use different TM1 user interfaces
1.8. Examine TM1 users
1.9. Examine TM1 Technology
1.10. Important files in TM1
1.11. Demo 1:Connection to an existing TM1 server
1.12. Create a new TM1 server
1.13. The three core design principles
1.14. Create an application in TM1
2. Create dimensions
2.1. What is a dimension?
2.2. What is an element?
2.3. Using weights with elements
2.4. Using attributes
2.5. Create dimensions
2.6. Demo 2:Create dimensions manually
2.7. Demo 3:Modify existing dimensions
2.8. What is turbo integrator?
2.9. Demo 4:Create a dimension using turbo integrator
2.10. Workshop 1:Create a dimension using turbo integrator
3. Build cubes and Views
3.1. Store data in cubes
3.2. Build a cube
3.3. Consider dimension order
3.4. Name the cube
3.5. Create a view
3.6. Demo 5: Build a cube
3.7. Workshop 2:Build the sales plan cube
4. Load and Maintain Data
4.1. Determine the data source
4.2. Review the data structure
4.3. Load data with turbo integrator
4.4. Import data from an ASCII file
4.5. Using formulas in variables
4.6. Demo 6: Import data from an ODBC source
4.7. Use turbo integrator to maintain the model
4.8. Demo 7:Clear data from a cube using a process
4.9. Demo 8: Accumulate data
4.10. Demo 9: Save data
4.11. Workshop 3:Create the franchise revenue cube
5. Add Business rules
5.1. Add business logic
5.2. Create a rule
5.3. Demo 10: Create a simple rules
5.4. Demo 11:Create a rule to suppress a consolidation
5.5. Use a function in rule
5.6. Demo 12: Create a rule to share data between cubes
5.7. Optimize your rules
5.8. Using feeder statements
5.9. Demo 13: Add skip check and feeders
5.10. Using rule worksheets
5.11. Demo 14: Review a rule worksheet
5.12. Determine location of logic
5.13. Demo 15: Calculate gross margin
5.14. Workshop 4: Calculate average unit cost
5.15. Workshop 5: Complete calculations for sales plan measures
6. Automate common processes using scripts
6.1. Review scripting with turbo integrator
6.2. Benefits of custom scripts
6.3. Demo 16: load data from multiple columns to a single column
6.4. Demo 17: Create a dimension including a subset with turbo integrator
6.5. Demo 18: Create a dimension with uneven Hierarchy
6.6. Use TM1 as a data source
6.7. Demo 19: Export data to ASCII text using turbo integrator
6.8. Demo 20: Move data between versions
6.9. Use chores with turbo integrator
6.10. Demo 21: Create and schedule a chore
6.11. Workshop 6:Create subsets within a turbo integrator process
7. Customize drill paths
7.1. View related data
7.2. Create a drill path
7.3. Demo 22: Create a drill through path to a view in another cube
7.4. Demo 23: Create a drill path to an ODBC Source
7.5. Workshop 7:Create drill paths for commissions
8. Convert currencies
8.1. Convert currency
8.2. Review control cubes
8.3. Use rules tracker
8.4. Demo 24: Include reporting currencies in a cube
8.5. Workshop 8: Build the income statement cube with reporting currencies
9. Model for different fiscal requirements
9.1. Understanding Time
9.2. Discrete Time Dimensions
9.3. Demo 25: Add a year dimension
9.4. Continuous time dimensions
9.5. Develop continuous Time Model
9.6. Workshop 9:Add Last year calculations to franchise revenue3
10. Present data and Reports
10.1. Organize content in a TM1 application
10.2. Using application folders: Example
10.3. Demo 26: Add TM1 objects and external files to an application
10.4. Build worksheets with action buttons
10.5. Add an action button to a worksheet
10.6. Demo 27: Add an action button to a worksheet
10.7. Use worksheet controls to present data
10.8. Use controls for data validation
10.9. Use Toolbars to add controls
10.10. Demo 28: Add a data validation control to a Microsoft excel spreadsheet
10.11. Format reports
10.12. Demo 29: Change the formatting on a report and create a crosstab menu
11. Define workflow
11.1. Configure TM1 for workflow
11.2. Review TM1 security
11.3. Demo 30: Add users and groups to TM1 security
11.4. Install workflow
11.5. Demo 31: Install TM1 workflow
11.6. Create a workflow process
11.7. Demo 32: Add a new process and tasks
11.8. Use the toolbar
11.9. Demo 33: Submit budget for GO Americas expenses
12. Introduction to Executive viewer
12.1. Explore executive viewer
12.2. Self service analysis
12.3. Explore the executive viewer client interface
12.4. Demo 34: Create a view and connect to a data source
12.5. Examine a cube
12.6. Examine views
12.7. Identify components of a view
12.8. Focus on a specific data
12.9. Demo 35: Select and arrange members
12.10. Demo 36: Drag and Drop, stack, and hide dimensions
12.11. Workshop 10: Create a view