9 Replies Latest reply on Feb 27, 2019 12:02 AM by Jan Merstrand

MDX queries, parallel execution and improved caching

Jan Merstrand Oct 8, 2018 12:24 AM

With Tableau 2018.2 there is a improved caching and parallel execution to provide better performance in MDX queries,

Is there any more documentation available that explains this a little more in detail than just a headline?

At my customers we run SSAS and have not seen any improvement, perhaps there's a setting we've missed?

1. Re: MDX queries, parallel execution and improved caching

patrick.byrne.0 Oct 13, 2018 4:04 PM (in response to Jan Merstrand)

Hello Jan,

I am going to reach out to the Tableau Development team to see if we can provide some more details on the improvements.

Thanks for posting!

Cheers,
Byrne, Patrick
Like Show 0 Likes(0)

Actions
2. Re: MDX queries, parallel execution and improved caching

Jan Merstrand Feb 7, 2019 6:17 AM (in response to patrick.byrne.0)

Patrick Byrne
Any luck? Haven't heard back...
Like Show 0 Likes(0)

Actions
3. Re: MDX queries, parallel execution and improved caching

patrick.byrne.0 Feb 7, 2019 9:12 AM (in response to Jan Merstrand)

Hello Jan!

I am re-pinging a few people to see if I can provide some more detailed information. Sorry for the long wait for this information!

Cheers,
Byrne, Patrick
Community Manager
Tableau Software
Like Show 0 Likes(0)

Actions
4. Re: MDX queries, parallel execution and improved caching

Jan Merstrand Feb 7, 2019 9:46 AM (in response to patrick.byrne.0)

Thanks! We're really in need of it to know some more since we have serious performance issues.
Can you configure it? Is it turned on by default? What does it do? Etc etc. As technical as possible would be great.
2 of 2 people found this helpful
Like Show 0 Likes(0)

Actions
5. Re: MDX queries, parallel execution and improved caching

patrick.byrne.0 Feb 7, 2019 2:12 PM (in response to Jan Merstrand)

Hello Jan,

For my limited understanding, these improvements should have improved the performance and not degrade it. I am curious, do other data sources perform as expected on the Tableau Server?

Cheers,
Byrne, Patrick
Community Manager
Tableau Software
Like Show 0 Likes(0)

Actions
6. Re: MDX queries, parallel execution and improved caching

Jan Merstrand Feb 7, 2019 10:33 PM (in response to patrick.byrne.0)

Everything else is working perfect! Its only dashboards with SSAS as a source.
Using excel or even Power BI works really good on same source, so its not the source.

We have a support case on this but no solution yet.
But technical documentation on the MDX cache would be great for our understanding.
Like Show 0 Likes(0)

Actions
7. Re: MDX queries, parallel execution and improved caching

Jan Merstrand Feb 21, 2019 3:40 AM (in response to Jan Merstrand)

Patrick Byrne No luck?
Like Show 0 Likes(0)

Actions
8. Re: MDX queries, parallel execution and improved caching

patrick.byrne.0 Feb 26, 2019 7:56 AM (in response to Jan Merstrand)

Have not been able to dig up any specifics. Was Technical Support not able to provide any additional insight?

Cheers,
Byrne, Patrick
Like Show 0 Likes(0)

Actions
9. Re: MDX queries, parallel execution and improved caching

Jan Merstrand Feb 27, 2019 12:02 AM (in response to patrick.byrne.0)

Unfortunately no, we have a case (04669415) under investigation.
Although I've found screenshots of the 2018.2 features on a site showing this feature, but now it is removed from Tableau's page?
Or am I getting blind? ;-)
Like Show 0 Likes(0)

Actions