MDX Performance Troubleshooting

Post Reply
mlorini
Posts: 18
Joined: Tue Apr 06, 2021 8:44 pm
OLAP Product: TM1
Version: 2.8
Excel Version: 365

MDX Performance Troubleshooting

Post by mlorini »

Does anyone have any idea about troubleshooting an MDX view?

Thanks
Top
Wim Gielis
MVP
Posts: 3233
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.1.5
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:
Contact Wim Gielis

Re: MDX Performance Troubleshooting

Post by Wim Gielis »

What happens if you compare it with a view where you force certain dimensions to 1 element ? Is it a lot faster ?
Best regards,

Wim Gielis

IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Top
mlorini
Posts: 18
Joined: Tue Apr 06, 2021 8:44 pm
OLAP Product: TM1
Version: 2.8
Excel Version: 365

Re: MDX Performance Troubleshooting

Post by mlorini »

Yes, forcing a dimension to 1 values is lot faster.
Top
Post Reply

Return to “IBM TM1, Planning Analytics, PAx and PAW”