Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

YTD member creating slow retrievals from ASO Cube

edited Aug 29, 2021 2:25AM in Planning 10 comments

Content

Hi All,

In EPM Cloud (PBCS), We have a View dimension member that has two members

1) Base Member - where all data is loaded. 

2)  "RV_YTD" member that has a member formula as below. 

IIF(IsLeaf([Period].CurrentMember), AGGREGATE(PeriodstoDate([Period].Generations(2),[Period].CurrentMember,[RV].[RV_BaseData]),MISSING)

If via SV, we pull Basedata members, it fetches in 1 minute time, but if fetched RV_YTD member, then it takes 3-4 minutes and sometimes times out - i.e. performance issue 

already tried below things but of no improvement
1) Merging Incremental Slices (and removing zeros)
2) Compacting ASO outline
3) Query Tracking + Aggregate Views (based on Query tracking)

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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