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 |
|
learntsql
524 Posts |
 Posted - 2011-10-10 : 08:01:01
|
| Hi All,I am new to MDX queries.Please tell me how to load an MDX query output into another ralational database table.Is it possible with SELECT * INTO of SQL concept or any other ways to do it?Please guide me.TIA. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-10-10 : 08:03:35
|
| MDX query is not working on relational tables. its working on cubes.The only way to load MDX output to table is by loading an excel with results and using export/import or bulkinsert to insert it to table.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
learntsql
524 Posts |
Posted - 2011-10-10 : 08:07:27
|
| ThanQ very much Visakh for quick reply.Please guide me how to load MDX output into Excel sheet. |
|
|
|
learntsql
524 Posts |
Posted - 2011-10-10 : 08:44:01
|
| Any ideas please...! |
|
|
|
|
|
|
Load MDX query output in Relational DB table