Aggregate Measures... Syntax

[Bygbobbo]

Version Server 2000

Currently, my cube has 4 dimensions and growing. At this point I am measuring 6 values and would like to create a Measure that Counts Distinct occurances of a dimension Level.

for example:

total of line_id#s m1 m2 m3 m4 ect...
line_id#


some line_id#s may be in duplicate, I want to make a measure in relation to a distinct count of line_id#s.

thanks

 

[Bygbobbo]

never mind, I figured it out.

Calculated Measure =

DistinctCount([dim_rbc_line_id2].[Line_Id].members)