Local Cube SSAS 2005 - Introduction

For a customer, local cubes (also called offline cube, cube file) needed to be created. The challenge was to create on a daily basis a set of local cubes with different structures. Lots of research have been done before being able to realise the solution. I would like to share with you all the activities that we executed in a set of articles. All these articles will be available at the end in a white paper over local cube SSAS 2005.

During our quest, our knowledge grow and to discuss local cube, I will follow our path:
1. MDX-script: CREATE GLOBAL CUBE
2. Local Cube task, Cube slice
3. ASSL (Analysis Services Scripting Language) batch
4. Qlickview

Enjoy the story!