PCMCS Custom Calculation error: Unable to allocate resources for cube PCM_CLC for 10800 seconds

Summary: Using dynamic calc member in the custom calculation to calculate stored member

Content (required):

Hi,

we have a requirement to calculate YTD value and use that in the allocation. Since, we cannot directly use MDX functions like PreviousMember, CurrentMember in the custom calc, I created a dynamic member with formula to calculate YTD value as below where I first add GL_Load data of previous month and current month and store it in GL_LoadYTD:

IIF(ISLEAF([Period].CurrentMember), ([Period].CurrentMember,[GL_Load]) + (PrevMember([Period].CurrentMember,LEVEL),[GL_Load]).Value,MISSING)

Then we have to calculate stored member using Custom calculation: [GL_Load Valid] := NONEMPTYTUPLE([GL_LoadYTD],[PCM_NoRule])([GL_LoadYTD],[PCM_NoRule]);