Session Title: Analysis Server Cube Design – Best Practice
Abstract: So you need to build some cubes. This session covers tips and tricks learnt through years of hands on experience. It won’t be a surprise to discover that there are common themes in what users desire, independent of technologies utilised eg SQL 2000 v’s 2005. We will cover the time dimension (including what new in SQL 2005), relative time calculations, common and some unusual measures. Also covered is a technique for how to cater for both power users and “normal” users.