Public Scheduled Training

Our CFMS Public courses for 2013, will be held at

LMG Training Centre
202 Blackfriars Road
Southwark
SE1 8NJ

Lunch will be provided on each course.

Course	Duration	Dates
		April	July	October
Office Plus Basics Read more info >	2 days	17th & 18th	17th & 18th	15th & 16th
Olap Server Rules Read more info >	1 Day	19th	19th	18th
Application Studio Basics Read more info >	2 days	23rd & 24th	23rd & 24th	23rd & 24th
Jedox for Excel Read more info >	1 Day	16th	16th	17th
Import Master Basics Read more info >	1 Day	26th	26th	26th
Infor Administration Read more info >	1 Day	22nd	22nd	22nd

Office Plus Basics

This course is aimed at all Office Plus users who will use the product to analyse data in an ad hoc manner. On completion of this course delegates will have a basic knowledge required for day to day use.

Prerequisites - Basic understanding of Excel

Course Contents

• User Interface
• Formula Reports
• Displaying data
• Attributes
• List Designer
• Importing Data
• Writeback
• Subsets & Data Areas
• Dimensions & Cubes

Olap Server Rules

The OLAP Server rules course is for OLAP Administrators with working knowledge of OLAP and wants to learn about Rules.

Prerequisites - A good understanding of OLAP

Course Contents

• Rules Engine
• Best practices
• Accelerators
• Debugging

Application Studio Basis

Users who would like to learn how to design reports in Application Studio, on completion of this course the delegates will be able to create fixed and dynamic reports that include hyperblocks and list objects

Prerequisites - Basic Excel

Course Contents

• User Interface
• Sorting & Flitering
• Fixed Reports
• Standardising reports
• Hyperblocks
• Rights
• Lists
• Relational Reporting
• Objects

Jedox for Excel

This course is aimed at Jedox users (formerly known as Palo) who would use the product to create reports within Jedox for Excel. Delegates completing this course will be use Jedox for Excel to create reports, Dimensions & Cubes, Databases and import data.

Prerequisites - Basic Excel

Course Contents

• Create Database
• Attribute & Subsets
• Dimensions & Cubes
• Import Data
• Paste View & Elements

Import Master Basics

Users who would like to learn how to use Import Master to create a fill OLAP Databases, on completion of this course delegates will be able to create Import Master jobs from scratch.

Prerequisites - Basic OLAP

Course Contents

• User Interface
• Mapping
• Integrating a Data Source
• Basic Scripting
• Creating Dimensions & Cubes
• Import Definition Variables

Infor Administration

This course is aimed at users who want to be able to administer Infor, users will be shown how to set up database, manage users, permissions and security.

Prerequisites - None

Course Content

• User Management
• Back Ups
• Creating & Repository Management
• Installation of Software
• Creating OLAP Databases
• Basic Troubleshooting