Developing a resource plan to handle users

  OLAP Cube building takes about 6 hours nightly.  Sometimes early bird (6:00AM) users will access

the cube.  These users will create full table scan query’s on 2.7 million rows by 500 column roll-up

table cube as the cube is being build.  When users query against the cube during build the entire

cube process slows down.  This causes all users to wait until cube building is complete.

 

One user said to just REVOKE SELECT ON the cube table.  However, this is more complex.  Users

are given a role that has access to the schema for which the cube table resides.  So you cannot just