EPBCS Planning Cube Refresh times excessive
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