Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Villanuev
Constraint Violating Yak Guru
478 Posts |
 Posted - 2013-08-07 : 04:25:17
|
| Hi Guys,I would like to get your inputs about my query.Right now, I can connect to the reporting Server using a read access permission in SSMS to do adhoc query and others. Right now they have plan to remove my read access permission in SSMS. They wanted to Use the Cubes as our datasource. My question. Its possible to use the cubes as data source in my query in SSMS? THanks. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-08-07 : 06:34:45
|
| yep...those queries are called MDX (Multi Dimensional eXpression) queries. You need to click onto MDX query icon on top to open MDX editor. normal query editor wont recognize MDX queries------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
Villanuev
Constraint Violating Yak Guru
478 Posts |
Posted - 2013-08-07 : 20:54:47
|
| Hi Visakh,You mean the Analysis Services MDX Query icon on top the menu editor? Btw, what is the difference between the SQL Query and MDX Query? Is there a big difference between this two? thanks. |
|
|
|
MuMu88
Aged Yak Warrior
549 Posts |
Posted - 2013-08-07 : 21:29:54
|
| You can Right mouse click on your server in object browser and choose new query and then MDX.Comparison of SQL and MDX: http://technet.microsoft.com/en-us/library/aa216779(v=sql.80).aspxTutorial - Introduction to Multidimensional Expressions (MDX): http://www.fing.edu.uy/inco/grupos/csi/esp/Cursos/cursos_act/2005/DAP_SistDW/Material/2-SDW-Laboratorio1-2005.pdf |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-08-08 : 01:18:15
|
quote:
Originally posted by Villanuev
Hi Visakh,You mean the Analysis Services MDX Query icon on top the menu editor? Btw, what is the difference between the SQL Query and MDX Query? Is there a big difference between this two? thanks.
yes. they're completely differentSQL works on tables which is two dimensional (ie rows columns concept)MDX works on multiple dimensions in cube ie concept of axes, slicers and dicersso they're completely different.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|
|
CUBES as Data Source