After running the Local Cube Task install program you will find the Local Cube task icon with the other icons on the task palette in the DTS Designer. This task allows you to design and schedule the automatic creation of one or more local cube files. You can include a subset of the server's cube data in the local cube, so the cube file can be kept to a manageable size. By using local cubes, you can also precisely control the cube data that can be seen by each user.
Local cubes can be e-mailed to users or made available to users across the internet.
The data in a local cube can be viewed in Microsoft Excel 2000 and by most other OLAP client browsers. You can create local cubes one at a time by using Microsoft Excel 2000. The advantage of the Local Cube task is that it allows you to automate cube creation, so that you can create fresh local cubes whenever your data is changed. DTS provides the ideal environment for creating local cubes. You can use DTS tasks to add new information into your data mart.