January 9, 2017 at 6:18 pm
Hi All,
i have started to learn MDX these days. I am wondering what is the use of it. where we can use MDX.
What we can build with MDX.
I know MDX is used to query on cube. I started learning some queries in SSMS.
in SSAS interface if you drag drop measures/facts and adjust as you require MDX query gets prepared itself. so why to write manually if you have interface to build it.
Similary SSAS after connecting to cub we can drag -drop columns/measures/facts which will automatically create mdx queries in background.
Please suggest me some reference, so that I get some motivation that I am learning some useful thing in SSAS.
January 10, 2017 at 8:11 am
MDX is the language used to query SSAS cubes, and it is to Analysis Services what T-SQL is to the SQL Server RDBMS.
Why should you learn MDX if you could use the query designer to generate queries? The same reason why it's a bad idea to use the query designer to generate your T-SQL queries. Although useful when learning, these tools do not generate the best queries in terms of syntax and performance. There are also some things that you cannot do with the query designers, for instance calculated members.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply