MLN
6 hours agoNew Contributor
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.