YTD member creating slow retrievals from ASO Cube
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.
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)