Forum Discussion
Obtaining the sql query
Not really. Neither OLAP cubes nor SSAS Tabular run on SQL. It's either MDX or DAX.
Have a look at DAX Studio. It allows you to see which SQL-like queries are run under the hood, but those are informational only and cannot be used in any of the client tools.
Sorry for the delayed response. I am not sure I fully understand how I can get a full sql before its ran on the semantic model from DMV queries. Within other semantic solutions like atscale, lookml and cube.dev, you can submit a list of dimensions from the semantic model to select on and filter by and and a sql query will be returned. Then you can choose to execute it. Does that make sense?
Super UserNot really. Neither OLAP cubes nor SSAS Tabular run on SQL. It's either MDX or DAX.
Have a look at DAX Studio. It allows you to see which SQL-like queries are run under the hood, but those are informational only and cannot be used in any of the client tools.