BPC data manager performance. Abnormal query time
I am executing a script on a large data set 2 million records but with the following conditions that should reduce the scope to just 4000 records.
*XDIM_MEMBERSET TIME = %TIME_SET%
The system however is taking about an hour of query time. What could be the potential reason ?