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

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

Received Response

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

Content (required):


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]);

Howdy, Stranger!

Log In

To view full details, sign in.


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