You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

EPBCS Planning Cube Refresh times excessive

in Planning 11 comments

Summary:


Content (required):

Every morning around 4am we run an automated process to import metadata from EDMCS into planning and then refresh our cube. Recently the timings having been sporadic. Normally the cube refresh times in the past have taken about a minute but now we're seeing refresh times of nearly 3 hours. I ran one again today manually which took 2hrs14min.

In one of our ASO cubes, our account dimension is very dense (accounts get added almost every day). There's around 12,000 accounts in one of our planning cubes which I think might be a potential root cause.

We have the following cubes and number of members in the account dimension as follows

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!