Hi, we have an error in Arc, where randomly MDX statement does not query or takes over two minutes to query. It’s not about the actual data, just the statement does not load.
When clicking on show MDX it always then shows:
SELECT
NON EMPTY
ON COLUMNS
FROM [(Cube name)]
And None of the dims are showing up in columns, rows, filters.
It is not related to one specific view and not even to one cube, PULSE sessions shows nothing going on on server. I’ve also tested that with only one user being log in, but still had the same. If You change a view to different one and MDX shows, then come back to the one that did not, now it instantly get’s it.
It happens in about 5% cases, so it is a bit annoying. This is on the newest version of ARC, but we had it in previous ones too.
Did anyone else came across this and knows how to fix it?
Adding screen for reference:
Kind regards,
Mateusz.