Training:
Advanced Developer

Course Duration: 1 day

Overview

This course is designed to give users an understanding of how to rapidly create complex reports and dashboards using CXAIR’s advanced calculation, charting and filtering capabilities.

Who Should Attend?

IT Professionals, Analysts and Business Users who have prior experience in developing reports and dashboards in CXAIR who wish to extend their knowledge by learning advanced techniques and features.

Course Benefits

Upon completion of this course, attendees will be able to:

  • Understand the advanced features within CXAIR
  • Understand how to use saved queries to format P&L style reports
  • Use conditional statements for advanced calculations
  • Use advanced CXAIR functions
  • Define dynamic, rolling calendar and form based filters
  • Understand how to use Pages Text/ HTML Editor to enhance Page reports
  • Define advanced row and column based calculations
  • Understand best practices for successful report creation

Course Content

The following topics will be covered during this course:

Advanced Features Essentials

  • Core Concepts
  • Crosstab Refresher
  • Calculation Syntax
  • Row and Column Totals
  • Saved Queries
  • Advanced Charting
  • Multi-Index Page Reports

Advanced Reporting

  • Row and Column Totals
  • Cell Calculations
  • When to Use These Totals
  • Linking Totals
  • DrillThru Calculation
  • Placeholder Queries

Report Formatting

  • Dynamic Labelling
  • Hiding Report Levels
  • Using Hidden Measures

Advanced Calculations

  • CASE and IF Statements
  • Date Calculation Syntaxes
  • Conditional Statements
  • Formfields

Hints and Tips

  • Best Practices
  • Naming Conventions
  • Example Crosstabs
  • Example VENN Diagrams
  • Example Flow Reports
  • Example Dashboards
  • Mobile Design Considerations

Advanced Pages

  • Break Fields
  • Layers
  • Text / HTML Editor
  • Multi-Index Reports

More information

Get in touch to discuss your requirements further