Browse all our courses

User Group

Training Course

End User

Select a User Group

Excel

Key Facts and Figures about the course
Learn to explore data to be a proficient analyser and get to know all the reporting possibilities in Excel.

8 hours

Intermediate level

No prerequisites

  • 1. How to use the interface
  • 2. How to analyse Cube data
  • 3. How to use the Dimension
  • 4. How to use the Subset
  • 5. How to use each report types
  • 6. How to export data to Excel
  • 7. How to use an Action Button
  • 8. How to publish a report
  • 9. An introduction to TM1 Web
  • 10. An introduction to Data Spreading

Paw

Key Facts and Figures about the course
Explore how to analyse data, utilise hierarchies and create dashboards for the web, using PLanning Analytics workspace (PAW)

8 hours

Intermediate level

No prerequisites

  • 1. An overview on the interface
  • 2. How to analyse data
  • 3. How to use hierarchies
  • 4. How to trace the data’s logic
  • 5. How to use each report types
  • 6. How to use data spreading
  • 7. How to use the sandbox for planning
  • 8. How to create a dashboard from scratch
  • 9. How to set up visualisation
  • 10. How to importing data

Advanced Reporting

Key Facts and Figures about the course
Learn the intricacies required to create dynamic reports in Excel.

8 hours

Intermediate level

End User (Excel)

  • 1. How to build a report from scratch
  • 2. How to manupilate the Dynamic Report
  • 3. How to set up filters
  • 4. How to add charts
  • 5. How to use Action Buttons
  • 6. How to set up dynamic columns
  • 7. Key Excel functions you shoulf know
  • 8. Best practice principles for report building

Developer

Developer Fundamentals

Key Facts and Figures about the course
Learn the fundamentals of dimension building, cube design, data loading, writing Rules and TurboIntegrator processes.

8 hours

Intermediate level

End User (Excel) and Advanced Reporting (Excel)

  • 1. Best practice foundations
  • 2. How to develop Dimensions
  • 3. How to maintain Dimensions
  • 4. How to create Cubes
  • 5. An introduction on how to write Rules
  • 6. An introduction loading data via TI
  • 7. How to setup user and groups security

Advanced TurboIntegrator

Key Facts and Figures about the course
Learn how experts user TurboIntegrator (TI) to write code beyond the restrictions provided by the wizard

8 hours

Expert level

Developer Fundamentals

  • 1. TI programming principles
  • 2. How to understand Data Sources
  • 3. How to use Variables
  • 4. How to create and destroy objects
  • 5. How to use Prolog tab
  • 6. How to use Parameters
  • 7. How to build Views and Subsets
  • 8. How to use the Metadata tab
  • 9. How to use the Data tab
  • 10. How to use load data
  • 11. How to use Bedrock processes

Advanced Rules

Key Facts and Figures about the course
Learn how to write multi-cube logic and clearly understand how feeders work to ensure an efficient model.

8 hours

Expert level

Developer Fundamentals

  • 1. The fundamentals for writing Rules
  • 2. How to use Feeders
  • 3. How to use operators
  • 4. Key Rule functions you should know
  • 5. How to use strings in a Rule
  • 6. How to feed to and and from consolidations
  • 7. How to write advanced Feeders
  • 8. How to reference data in another Cube
  • 9. How to write a currency translation rule
  • 10. How to write a moving balance rule

Advanced MDX

Key Facts and Figures about the course
Learn how to write advanced MDX within TM1 and client applications such as PAW and PLanning analytics for Excel to control the data received.

8 hours

Expert level

Developer Fundamentals

  • 1. MDX syntax explained
  • 2. How to use MDX in the Subset Editor
  • 3. How to use MDX in TurboIntegrator
  • 4. How to use MDX in Excel
  • 5. How to use MDX in Exploration View
  • 6. How to use MDX in Arc
  • 7. How to use MDX in logging
  • 8. Key supported expressions
  • 9. How to use MDX to filter Cube data
  • 10. How to use the “generate” function
  • 11. Do’s and don’ts in MDX

TM1py Fundamentals

Key Facts and Figures about the course
The ideal foundation to get you started with developing your own Python and TM1py scripts.

8 hours

Intermediate level

Developer Fundamentals and basic Python knowledge

  • 1. Getting to know the TM1py package: interface and documents
  • 2. How to read TM1 data with Python
  • 3. How to update metadata and synchronize dimensions and hierarchies
  • 4. How to write data to TM1
  • 5. Dot the i’s and cross the t’s: Make your TM1psy script production ready

Pulse Fundamentals

Key Facts and Figures about the course
Learn the functionalities that comes with Pulse such as live monitoring, user analytics, Excel analysis, documentation, migration and proactive alerts.

8 hours

Beginner level

End User (Excel) and Developer Fundamentals

  • 1. How to use Pulse’s interface
  • 2. Business cases that you should know
  • 3. How to audit applications
  • 4. How to manage the development process
  • 5. How to report on the server’s status
  • 6. How to document the TM1 Server
  • 7. How to administer the TM1 Server

Apliqo UX Fundamentals

Key Facts and Figures about the course
Learn to explore data to be a proficient analyser and get to know all the reporting possibilities in Excel.

8 hours

Intermediate level

End User (Excel) and Developer Fundamentals

  • 1. How to understand the architecture
  • 2. How to create a dashboard
  • 3. How to utilise widgets
  • 4. How to set up the display settings
  • 5. How to implement a chart
  • 6. How to use interactivity between widgets
  • 7. How to pop-ups
  • 8. How to change dashboard settings
  • 9. How to implement views
  • 10. How to utilise advanced table options
  • 11. How to apply formatting to the application
  • 12. How to utilise advanced chart options
  • 13. How to add a wizard
  • 14. How to add a process to the application

What people are saying about our courses

“Thank you to Cubewise for the Advanced Rules Course. I found it short and sweet as well […]”

“Another great course by Cubewise EDU team. To me the course was an opportunity […]”

“It was a very good training with a lot of knowledge that I’ve acquired and excellent […]”

Next events

Explore our Knoledge Hub

Loading posts for you, tons of them