dbTalk Databases Forums  

MDX for TopCount

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss MDX for TopCount in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Stuart Scott
 
Posts: n/a

Default MDX for TopCount - 11-09-2004 , 09:43 AM






Hi,

I am trying to create a set of top 10 countries that updates when the Send
Year is changed. I have scanned the net and found various example that I
attempted to tailor to my requirements but none seem to work. Can anyone
help please?

I have attached an example piece of code that I found and used...

with set Top 10 Countries as

'Topcount ( { [RCV_Country].[RCV_Country].members }, 10,
([SND_Year].currentmember, [SND_Value ?])'



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.