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 |
|
bridge
Yak Posting Veteran
93 Posts |
 Posted - 2005-04-25 : 08:14:30
|
| Can we use Top-N in a cube if yes how?likeSELECT Top 10 * FROM users |
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2005-04-25 : 17:46:21
|
| This is easiest done in the client.Which client are You using to browse the cubes ?(You could probably also create a member set with the Top10 users, but it would it would not bedynamically relative to the current selection of the dimensions)rockmoose |
 |
|
|
bridge
Yak Posting Veteran
93 Posts |
Posted - 2005-04-26 : 00:34:55
|
| We have not yet decided about the client tool, which tool by the way you prefer to use? |
|
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2005-04-26 : 04:33:11
|
We use ProClarity, the client is very good, the ProClarity Analytics Server (Enterprise reporting) is so-so(imo). There is a new version out 6.0 (as always), which I haven't tried.You can start off with Excel, which has OLAP functionality.My recommendation is that You check out and try a few different clients.(search the web)  rockmoose |
|
|
|
|
|
|
Top-N in a cube