This discussion is archived
1 Reply Latest reply: Dec 27, 2012 6:37 AM by Nasar RSS

Cube Refresh Performance Benchmark

892844 Newbie
Currently Being Moderated
We are facing some performance issue is cube refresh for which we trying to see whether the hard configuration is optimal for the given load.

Do we have any reference system config / performance benchmark for the same. Pls advise
  • 1. Re: Cube Refresh Performance Benchmark
    Nasar Journeyer
    Currently Being Moderated
    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?


  • Correct Answers - 10 points
  • Helpful Answers - 5 points