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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-10-07 : 07:45:18
|
| Greg writes "We are currently using Analysis Services and MDX to power a front-end web application that browses cube data. Our architecture dictates that data must be passed in XML between are various layers of components. Is there a way to represent MDX query results in XML using built in features of SQL Server 7/2000?Does the next version of SQL Server handle this any better? Are you aware of how the next-gen SQL Server will handle Analysis Services?Do you have any suggestions on how we should architect the application (All ASP vs Components)?" |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-10-08 : 00:54:00
|
| You can store the current state of the OWC as XML. So if you generate a pivot table using MDX, you can save it off as XML, then regenerate it later using the XML.XML will be more integrated into the next release of SQL server (Yukon). There are no specifics yet.-Chad |
 |
|
|
|
|
|
Using MDX in the next version of SQL Server