Hi,
I'm running rep. agent to pre-cal. my template having 6 queries from different data providers. It works fine but the time to run my rep. agent is almost 2hrs. I'm using a control query to filter out the pre-cal. but still it takes 1.5hr. created more aggregates on the cubes but not sure how this is going to effect rep. agent.
can anyone suggest ways to reduce the time taken to pre-cal....
thanks....