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 |
|
Royal
Starting Member
32 Posts |
 Posted - 2007-03-27 : 02:46:34
|
| I am a confused newbie, grateful for some help. I need to select 10 rows from total profit of married people. How would I do that?DRILLTHROUGH MAXROWS 10 SELECT{[Measures].[Total Profit]} on 0, [customer].[Name]ON 1 ON columns FROM from [Electronics] WHERE [Demo].[civilstatus-salary].[civilstatus].&[married]}RETURN [Measures].[Total profit](as rows) |
|
|
Royal
Starting Member
32 Posts |
Posted - 2007-03-27 : 15:08:47
|
| hm... so this actually return 14 columns of Measures. I just want one with the total profit of each customer. DRILLTHROUGH MAXROWS 10 SELECT{[Measures].[Total Profit]} on COLUMNS, {[customer].[Name].children)} ON ROWS FROM [ELEK] WHERE [Demo].[civilstatus-salary].[civilstatus].&[married] |
 |
|
|
Royal
Starting Member
32 Posts |
Posted - 2007-03-31 : 06:13:08
|
| This returns some result, but I don't think the correct sums. Checked the sums calculated in the Browser..DRILLTHROUGH MAXROWS 10 SELECT{[Measures].[Total profit]} on COLUMNS, {[Customer].[Name]} ON ROWS FROM [Elec] WHERE {[Demo].[civilstatus-salary].[civilstatus].&[married]}RETURN [$Customer].[Name], [$Measures].[Total Profit] |
|
|
|
|
|
|
Drillthrough