OLAP Office Explorer has a lot of functionality and is extremely versatile. You can model any report you need and you can create packs of information for your specific application requirements. In the above slide show, the slides of which are listed below, you can see some of the potential that is available for OLAP Office Explorer. But, to see more functionality please review the rest of the web site to see what is possible.

1. 1 Query. Parent-Child Drill. + Expand. - Collapse. Blank Rows & Columns
2. 1 Query. Child-Parent Drill. + Expand. - Collapse. Blank Rows & Columns
3. 1 Query. Central Rows. Modeled Columns. Page Filters & Pick Year Members
4. 2 Queries. Different Measures. Same Filters. Same Row Members. This is useful for preparing reporting packs of information, including financial reporting packs.
5. 1 Query. Combine Excel Formula and Descriptions in Query Area (White Area). Leverage and combine your existing Excel knowledge simply into your views of information. The view is a combination of both information from Analysis Services and Excel. This can be achieved in various ways but the technique evolved by OLAP Office is the preferred and most efficient method.
6. 1 Query. Stacked Dimensions. Column 1 to 2 Relationship. 1 to 1 Relationship
7. 1 Query. KPIs in Pivot Table. KPIs Work Off Cube Data. Key performance indicators identify performance, control and problem issues relative to set organisational goals. These goals may differ from entity to entity. OLAP Office Explorer™ has hundreds of KPI's to choose from for your reports. These indicators vary depending on the nature of the message being conveyed or acted upon. The indicators can also be used for workflow.
8. Spark Lines (In-Cell Graphics) in Pivot Table. User Controls Color. OLAP Office Explorer™ provides some innovative graphics for creating dashboards and cell graphics referred to as sparklines. Histories, tolerances and performance can be placed in a cell based graphics. Text can be attached to the graphics as well. The sparklines can be used to display predictive data. These were defined by Dr. Edward Tufte .
9. 1 Query. Excel Form Control Integration & Data Entry
10. Centralize Application Settings For All Views On Different Worksheets
11. 1 Query. Profit & Loss. Model Into Existing Reports.
12. 1 Query. Balance Sheet. Model Into Existing Reports.
13. OLAP Relational (Transactional) Report. Add Rows & Columns. Can Also Input
14. Dynamic View Set Update. Select Set To Update View.
15. Dynamic View Structure Update. Month 2 Has New Child Members.
16. Heatmaps. The values in the cells are based on criteria you specify for the relevant areas in the cube. You can get more shades of colours this way.
17. Themes Provide Users With Full View Color Control
18. Excel Graphics Combined With View
19. Drillthrough To Transactional Data. Automatically Formatted.
20. Drill MDX Calculated Member

Too see all of this in action be sure to watch the videos.

The user has over 200 different formatting options to choose from but you have the full control over every field when creating an OLAP Office Explorer™ report. This includes, formatting for the number, alignment, font, border, patterns and protection.There is also more than one formatting method for the dimensions in a view.

... and more.