Cube View Time Out issue
Hello Team,
I'm experiencing performance challenges with a CubeView that contains:
- 4 row dimensions (all using .base members)
- Multiple time period columns
- Dynamic calculations that are causing significant retrieval delays
Current Challenge: The CubeView needs to be executed and its data exported externally, but the dynamic calculations are making the retrieval process extremely time-consuming.
Attempted Solution: I've already tried converting the dynamic calculations to stored values using finance rules, but this approach has proven ineffective - it's still taking excessive time and not producing the desired results.
Request: Could you suggest any alternative approaches or optimization strategies to improve the performance of this data retrieval and export process?
Thank you for your assistance.
That link didn't work for me (not authorised) but this one did which I think should be the same thing: https://onestreamsoftware.service-now.com/support?sys_kb_id=2a249b132ba8a250eef0ffd16e91bf5f&id=kb_article_view&sysparm_rank=1&sysparm_tsqueryId=cb9975dd2bc87a50dc0dfbb9ce91bfd1
