ASO performance at 32MB cache

Summary:

ASO performance at 32MB cache — structural work done

EPBCS app with BSO entry → ASO reporting via data maps. Looking for input from anyone running similar scale.

Cube context:

• Account dim: 5 sets of P&L (PLSet1–PLSet5) and 4 sets of Cash (CFSet1–CFSet4), each with Revenue, Cost, GI, GM% and NetCash
• Operating Unit: ~94K members, 17 levels deep, only level 0 stores data, parents are dynamic calc
• Period: Periodic, YTD, PTD
• ~6.7M input cells, 249 MB cube (This is still in development)
• Aggregate storage cache: 32 MB (platform default)

Reporting requirement:

• 6 years of forecast + previous forecast with quarterly variance comparison
• 1,100 tasks per typical project