OK, let’s add another definition:
SQL : Structured Query Language.
I have to use MDX to query an SSAS cube.
MDX is not SQL, it’s a different tool to work with data. Different letters in their names should be the first clue.
You are coming to SQL forum and complaining it’s not MDX enough? That’s a bit funny.
I can tell you why they don’t want you to run your queries on live production database. MDX queries on SSAS, as well as other analytical tools, like Tableau, etc., treat the data as its solemnly in their possession. There is no consideration for any concurrent users querying or modifying the same data sets. They read the full data set into memory, all whatever GBs are in there and then apply filters, transformations, etc. While they are on it, it’s important that the underlying data won’t be changed, or the report would be based of fragments of data having no integrity between them. Everything your query touches must be locked from other users. And from my personal experience I can say those analytical queries touch almost every table in the database.
So, while you’re enjoying you cup of coffee waiting for your queries to complete, the database is effectively offline for the rest of the world.
Which is probably not an option for the business, that’s why the DBA’s say “no” to your requests.
If you want to get real time reports from live data you need to learn actual SQL - structured query language, - and learn how to build queries in such ways so they don’t block other users/processes from using the data at the same time. It’s not as easy as constructing filters in MDX, but this forum could be much help if you decide to go that direction. Because it’s about SQL - just as it’s name suggests.