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 |
|
Oliver wang
Yak Posting Veteran
50 Posts |
 Posted - 2011-01-10 : 01:30:13
|
| Hi everyone,i got a problem and need your help. In SQL database Engine, we can create a query , input several "select" clause and run them. But in Analysis service, I found it's impossible to run more than one "select" MDX scripts(if I only run one script, it's working fine). The following scripts dipicts my scenario: select {[Measures].[DEVICE COUNT]} on 0, {[IRS DIM CUSTOMER].[CUSTOMER NAME].allmembers} on 1 from [IRS V5 DEVICES] select {[Measures].[DEVICE COUNT]} on 0, {[IRS DIM CUSTOMER].[CUSTOMER NAME].allmembers} on 1 from [IRS V5 DEVICES]Does anybody know how to put several "select" clauses in one query and run them? Thanks a million.regards,Oliver |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2011-01-10 : 05:21:22
|
| I have really no clue...but you might try to add a semicolon at the end of each statement.- LumbagoMy blog (yes, I have a blog now! just not that much content yet) -> www.thefirstsql.com |
 |
|
|
Oliver wang
Yak Posting Veteran
50 Posts |
Posted - 2011-01-10 : 05:59:29
|
| Hi Lumbago,Thanks for your hint. I have tried what you suggested and now the error message is "Multiple statements are not allowed." From my understanding, this feature is by design. Thank you again for sharing your experiences selflessly.regards,Oliver |
|
|
|
|
|
|
run multiple scripts in Analysis service