TM1 is a technology based on On-Line Analytical Processing or OLAP. With TM1, you can quickly view and understand large sets of Complex business data. Analysts and Managers can use TM1 Perspectives and Microsoft Excel, and Server Explorer to analyze their business performance.
Overview: Attendees will learn to create static and dynamic subsets for spreadsheets and views in order to analyze data. In order to create dynamic subsets, you will also learn how to record and create MDX statements. You will review the benefits and purposes for a snapshot, slice, and active form and create more advanced TM1 Excel reports for distribution for your organization.
Upon successful completion of this course, attendees will be able to:
- create static and dynamic subsets
- export and modify a slice and active form
- design complex reports for distribution
- understand best practices and tips