Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
Member formula in Stat account impacts performance — Cloud Customer Connect
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

Member formula in Stat account impacts performance

Accepted answer
11
Views
2
Comments
edited Aug 23, 2022 10:53AM in Financial Consolidation and Close 2 comments

Summary:

I have a member formula for calculating DSI and the performance is bad when this account is retrieved in SmartView.


Content (required):

This formula takes around 10 min to retrieve in SmartView when Top IC member is used in POV. It works fine when retrieved at No Intercompany. I tried to use substitution variable to get the prior year instead of MDSHIFT, but it creates a problem when I retrieve values from historic years. I also tried using @PRIOR with including Year dimension, but that too didn't work.

Could you please suggest a better way to achieve this?


Thanks in advance,

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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