Jump to content

NON EMPTY effect on performance


allenmvt.edu

Recommended Posts

I'm very new to this and probably just missing some key concepts.  I've built some cubes and some related aggregate tables.  Performance is good and i've confirmed that i'm using the aggregrate table my monitoring database activity.  However, when I togger to NON EMPTY on the rows, the performance is terrible and i can see that i'm hitting my fact tables.  Is this behaviour expected?  Is there something i can do to improve the performacne?  thanks

Link to comment
Share on other sites

  • 1 month later...
  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...