Topcount and bottomcount


hello friends,

the query wrote below, shouldn't giving me list of plaintiff members top based on record count 2010 bottom based on record count 2011? if use topcount function on both set makes sense(e.g top on 2010 not on 2011) but when use both (topcount , bottomcount) it's not making sense. cause see members returned not bottomcounts 2011. can please me understand cube space generating?

with

set [plaintiffwith>1000] as

filter

(

{[plaintiff].[adjplaintiff].[adjusted plaintiff].

members},

([measures].[recordcount])>10000)

select

{[measures].[recordcount]}on 0,

except

(

topcount

(

existing

{[plaintiffwith>1000]},

10,

([measures].[recordcount],[judgmentdate].[judgment date].[year].&[2010])

),

bottomcount

(

existing

{[plaintiffwith>1000]},

10,

([measures].[recordcount],[judgmentdate].[judgment date].[year].&[2011])

))

on 1

from

[plaintiff]

hi gedagudi,

depending on distribution, selection easely filled irrellevant members when number of overall [plaintiffwith>1000] rises great numbers.  your starting set [plaintiffwith>1000]  may populated @ 2010 top , 2011 bottom members didin't show drop.

i don't understand why strip away 10 bottom 2011. ones should keep. should rather except the 10 top 2010, x top 2011 or exept 10 bottom 2011, x bottom 20010 or norman suggested intersect 10 top 2010 10 bottom 2011.

shouldn't  more straightforward define set of plaintiff high record count 2010 , narrowing set showing  a drop in 2011 threshold percentage fine tuned?

philip,








SQL Server  >  SQL Server Analysis Services



Comments

Post a Comment

Popular posts from this blog

Reindexing

hi     using sql server 2005 ee sp4. our database size 150 gb. weekly once schedule reindex job. ran 4 5 hours maximum. but recent days getting more 13 hours. the possibilities there? ragu thangavel how perform reindex? maint plan? or check fragmentation first , reorganize fragmented? if later, quite more data nowadays fragmented before. if not, consider doing "smart" defrag (ola.hallengren.com). tibor karaszi, sql server mvp | web | blog SQL Server  >  SQL Server Database Engine
Read more

Users List

hello everyone, i"m builing tool tfs , want user list form tfs "assigned to" field. if 1 can post code review i"ll gled.   thanks hello, to imports users tfs, can try this: using microsoft.teamfoundation.server; using microsoft.teamfoundation.client; using microsoft.teamfoundation.workitemtracking.client; icredentialsprovider provider = new uicredentialsprovider (); teamfoundationserver tfs = teamfoundationserverfactory .getserver(“your_server_name”, provider); tfs.authenticate(); igroupsecurityservice gss = ( igroupsecurityservice )tfs.getservice( typeof ( igroupsecurityservice )); identity idsid = gss.readidentity( searchfactor .accountname, "team foundation valid users" , querymembership .expanded); identity [] idusername = gss.readidentities( searchfactor .sid, idsid.members, querymembership .none); foreach ( identity id in idusername) {       if (id != null && id.type == identitytype .windowsuser) ...
Read more

List of charts

Image
i'm trying build report show activity for reservations placed and satisfied month branch. the report has parameter the item category and dataset has fields month category branch reservations placed reservations satisfied on front sheet i've created system wide figures 2 columns per month and a matrix broken down category (e.g. child fiction, child non fiction, adult fiction, adult non fiction) has row , column totals. i want have page each branch in system. what's best way of approaching this?  add parent group based on branch field in row groups  and add page breaks repeat matrix report every branch. please mark answer if post solved problem. milan das SQL Server  >  SQL Server Reporting Services, Power View ...
Read more