Easy to use

§  Intuitive layout and structure

§  Direct access to main tables from journals

§  Advanced sorting and filter options

§  Application can be run in different languages

General

§  Multidimensional analysis

§  Embedded and context adaptable viewing of cubes

§  Easy access to manipulation of views in Microsoft Excel

§  Full control within Microsoft Axapta

Microsoft Analysis Server

§  Create, maintain and control OLAP databases and cubes

§  Cubes stored as MOLAP cubes with no querying drag on legacy database after update (should perhaps be rephrased to be more bullet-like)

Embedded Pivot Table

§  Fully integrated with Microsoft Excel 2000 (Microsoft Query)

§  Viewing of cube data

§  Easy access to manipulation of view in Excel

Cube Definition Manager

§  Full use of Microsoft Axapta data model

§  Microsoft Axapta forms for easy set-up

Generation of Cubes

§  Create cubes in multiple currencies and languages

§  Periodic batch update possible for all cubes

Viewing of Cubes

§  General overview of available views

§  Automatic filtering from Microsoft Axapta base data on Pivot Table

Security and Configuration

§  Configuration key control of which cubes to generate

§  Security key control of access to cubes and views

Third Party Products

§  Any third party product add-on which supports Microsoft Analysis Services can be used for viewing cubes but is not necessary