When working with local cubes (filename.cub) (with the aim to distribute and for enduser to work with cubes offline) I create local files through Excel 2000 PivotTable. The problem is that it is imposible to work with and include calculated measures.
An alternative way to create a local cube is to use MDX programing, however this is a skill I lack...so before going in too deep in the world of MDX I was hoping that someone can answer this question.
Is it possible to create a local cube (.cub) with calculated measures?
How do I do this and where...In Excel or is it possible to make a mdx script in analysis services. //Helene