Help required in writing MDX

hi - need in solving below secnario calculated measure:

consider following case have 4 claim suffixes following revisions in fact table:  

claim-suffix		dq	compveh
12345-01	orig	1	0
	r1	0	1
	r1	0	0
23456-02	orig	0	0
	r1	1	0
34567-03	orig	0	0
	r1	0	0
45678-04	orig	0	0
	r1	0	0
	r2	1	0
	r3	0	0

as shown above, have 12 rows in fact table and  each claim_suffix contain multiple reviousin in fact table.

            in above example when roll revisions claim level, get

claim-suffix	dq report	comp veh report
12345-01	1	1
23456-02	1	0
34567-03	0	0
45678-04	1	0

in example, # claim suffixes dq report=0 , comp veh report=0 1

total # of claim suffixes = 4

% resolved vehs w/o wctl , dq rpt = ¼ * 100 = 25.00%

as shown above, need claucated "% resolved vehs w/o wctl , dq rpt " calculated measure.  please me how can achieve using mdx in calculated measure , explain me in detail how can achieve it.  thanks

hi,

i have consdered table given fact table , assumed have claim dimension. mdx have provided consists of , conditions filter unwanted records, i'd suggest proper testing.

regards,
santosh

 

---

it feels if give points helpful post. :)

SQL Server  >  SQL Server Analysis Services