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 |
|
varalakshmi
Yak Posting Veteran
98 Posts |
 Posted - 2013-08-12 : 04:29:24
|
| Hi,I'm using the TOPCOUNT function to get the top measure for one of my dimension table.The dimension table has a default value 0. The dimension table has more records for the default value 0. How to eliminate this default value from my top records?Thanks in Advance.- Varalakshmi |
|
|
varalakshmi
Yak Posting Veteran
98 Posts |
Posted - 2013-08-12 : 05:22:16
|
| This issue is fixed now. I created a set with EXCEPT function to eliminate unwanted values and then passed on the set to the TOPCOUNT function.- Varalakshmi |
 |
|
|
|
|
|
TOPCOUNT function in mdx