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 |
|
delpiero
Yak Posting Veteran
98 Posts |
 Posted - 2005-06-19 : 08:32:49
|
| Hi all, I am new to cubes and Analysis Services. I know there is a product which comes with Analysis Services (seems something like MDX sample application) which allows us to build MDX queries to query an Analysis Services cube. Is it possible to query a cube through a T-SQL stored procedure? Any simple way to allow our front-end application to query the cube and display the results to them, other than using Pivot Table Service and Excel?Thanks a lot,delpiero |
|
|
SQLboom
Yak Posting Veteran
63 Posts |
Posted - 2005-07-04 : 02:39:02
|
| mdx retrieves records across multiple dimensions whereas sql across 2 dimensions only ... so this should not be possible through sql to retrieve data from cubes ... |
 |
|
|
|
|
|
Querying a cube