I have aproblem where my queries never seem to use the aggregations against one of my cubes. I have other cubes where the queries hit the aggregations and respond quickly but for the cube in question all queries seem to go accross the data and take forever. I have checked and double checked the aggregation id is correct for the cube partitions and that the aggregation design exsists for the measure group in question. I have also monitored the processing to see that it does in fact build the expected number of aggregations.
I have done a test by manually creating a simple aggregation against the key of a small dimension and then do a query against the cube using only this dimension, and it ignores the aggregation. I did exactly the same against one of my other cubes and it worked as I would expect.
I have tried everything I can think of including fiddling with the slice of my partitions all to no avail.
Any help would be appreciated
You measures are defined as sum aggregation or other aggregation?
Regards!
|||Thanks for your question. There was a distinct count in there. I have moved it to it's own measure group and all is working now.
Ok Arthur, check your post as answered!
regards!!
No comments:
Post a Comment