Help need on COUNT() function in MDX query

hi all,

i need on count() function. need count based on 2 columns. let have data below

customername customertype

a temporary

a permanent

b permanent

i need result like

customername customertype count

a temporary 2

a permanent 1

b permanent 2

i need group both customername , customertype columns count. columns need group by from different dimensions.

how can write mdx query achieve this.

thanks in advance

avenash.m.g

hi,

is value want not equal :

  [measures].[total charge] / numberofdaysselected

also, first have 2 dimensions , in query there many more, 1 it?

how come have 3 dimensions provider (dim provider nm, dim provider type, dim provider id)?

avoid nonemptycrossjoin , put hierarchies same dimension next each other improve performance.

regards,

hrvoje piasevoli

SQL Server > SQL Server Analysis Services

Lun