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

Look Back
Smart View Retrieval Time on LTM Members in FCCS — 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

Smart View Retrieval Time on LTM Members in FCCS

Received Response
16
Views
4
Comments
edited Feb 5, 2021 3:49PM in Financial Consolidation and Close 4 comments

Content

Hi folks,

Hoping someone may be able to assist with what I feel should be a simple calculation (I'm very new to coding member formulas in FCCS).

I have created LTM members (Jan_LTM-Dec_LTM) in our Period dimension for reporting and I find it takes me over a minute to refresh the values in Smart View for the whole year and some users are experiencing even longer times or timing out entirely but the members are yielding the correct results. I've attached my code for the Jan_LTM member (same for other members with periods shifting).

I hard-coded values per a tip from an online article for performance.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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