This documentation is not using the current rendering mechanism and is probably outdated. The extension maintainer should switch to the new system. Details on how to use the rendering mechanism can be found here.

EXT: Office Web Control Extension

Author:Kasper Skårhøj
Author:Albrecht Haug
Info 3:
Info 4:

EXT: Office Web Control Extension

Extension Key: aha_owc

Copyright 2000-2002, Albrecht Haug, <>

This document is published under the Open Content License

available from

The content of this document is related to TYPO3

- a GNU/GPL CMS/Framework available from

Table of Contents

EXT: Office Web Control Extension 1

Introduction 1

What does it do? 1

Screenshots 1

Users manual 2

Adminstration 2

Configuration 3

Tutorial 3

Known problems 3

To-Do list 3

Changelog 3


What does it do?

  • First and important: This extension makes only sense, if you are in a Microsoft Internet Explorer environment. There has to be Microsoft Office installed on your and the clients ... yes, PC in that case... or at least the so called Office Web Control Pivot Table (OWC).
  • Additionally you need access to a Microsoft Analysis Server. This setup will probably not be met by the typical internet user but it is not so uncommon for many companies that use one or the other kind of OLAP system.


Initial setup of the plugin in the Backend:


This is how it looks in the frontend. There is a “Filter”-row where users can search through the data. This row can be hidden in the configuration-tab of the backend configuration.

A backend user can configure the plugin in the frontend. This configuration can be saved by clicking on button “update”. Number formats of the Analysis server are normally ignored by the control. In order to respect the number format you can trigger by clicking on “Format Numbers” a script that copies them into the OWC-setting. This has to be done once for each control (and again if the cube-format changes on the server). Frontend user have no “update” button and can not overwrite the preconfigured setting.


Users manual

Insert the plugin as you do it with any other frontend plugin: with installed extension you insert it into a page by creating a content element of type “general plugin”.

Select “Office Web Control” under “Plugin:”:


Then you have some Plugin options. It is mandatory to specify the three configuraion values for “connection”. Insert the name or IP- address of your OLAP server (e.g. The name of a Microsoft Analysis Server), the name of a database on this server and a Cube name. Cube roles on your server will be respected for the client access.

Save your content element. Then navigate to the page in the frontend. The OWC-control shoud be allready visible (in Internet Explorer only) and can now be configured.

While you are logged in as backend user, you can save the configuration (dimensions in row/column/filter-area, measures in the content-area, colors, title and so on) by clicking on “update”.


See section “Users Manual”.


The extension uses a template file that can be modified. The name of the template file is the only option that can be configured via Typoscript. See files ext_typoscript_*.txt for examples.


- A full point-a-to-b-to-c walk-through of an application of the extension. Include screendumps.

- Language: As tutorials are...

- Target group: Whatever fits.

Known problems

It's really a “Microsoft Only” extension. If you know browser compatible alternatives to the OWC, please let me know.

To-Do list

The “find box” feature is the only working option in the “configuration” tab of the backend “Plugin Options:”

Improve documentation.

Allow FE-Users to save their settings.


Initial relase.

img-4 EXT: Office Web Control Extension - 3