This content has been marked as final. Show 1 reply
Can you explain what kind of performance issue are you facing? How long is it taking and what is your expectation?
(1). Dimensionality of cube. How many members in each one?
(2). How many hierarchies in each dimension and is it level-based or value-based?
(3). Number of stored measures.
(4). Is it SUM aggregation over all dimensions?
(5). Is the cube partitioned? If yes, then at what level?
(6). Is it compressed cube? How much are you pre-aggregating (top and bottom) partitions?
(7). How many records are you loading?