Thanks Thom. Yes, the original question was incompletely stated. He neglected to state that this error message appears in SSRS Visual Studio 2017 Community Edition onto SSAS 2014, and it...
Thanks Thom. perhaps the problem is not being stated correctly. We do not have Tabular models, only 'traditional' Multi-dimensional models. In SSRS we are trying to access the 'traditional' models...
Thanks Lowell, but the problem is not with SSMS but with Visual Studio 2017 SSDT trying to access multi-dimensional cubes with MDX. The Visual Studio software seems to assume that...
Hi Koustav, you could indeed have the solution you suggest, but I am not sure what the relative benefits would be. In this sort of unique situation, I would honestly...
The current method we use is of course using a # temp table with an Identity column added with an ORDER BY clause. (The only(?) time one should use an...