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 - 2003-01-24 : 09:05:53
|
| Nagul writes "I want to know whether it is possible to execute mdx query with insert into clause to fill my temporary table in relational database. or is there any other way to fill my temporary table with cubes data ???" |
|
|
JamesH
Posting Yak Master
149 Posts |
Posted - 2003-02-04 : 08:12:11
|
| If you're executing the MDX through ADOMD then you should be able to insert the results from the resultset. If you're doing it through an MDX statement in an analyzer tool or God Forbid, the MDX Sample then you're not attached to a database, just the Cube. ROLAP is the only storage model that will physically store the Fact and Dimensions as well as aggregations within the relational database but you're really asking for a storage and performance nightmare using ROLAP except for current data in a sliced cube.JamesH. |
 |
|
|
|
|
|
OLAP