Hi,

I have a cube with a measurement "qtyReleased" of spills.

I would like to know the number of records with qtyReleased > 1000 (liters).

It seems impossible because it is not an attribute in a dimension.

Is there any solution to this?

Thanks,

Guangming

Unless your cubes let you drill down to an individual fact record (which
most don't) I can't think of a way you could do this without altering
the cube.

You could create a view of your fact table with a new derived column
like:

CASE WHEN qtyReleased > 1000 THEN 1 ELSE NULL END as MoreThan1kReleased

The create a measure summing this column. This would of course require
re-designing the aggregations and re-processing the cube and it does not
let you alter the '1000' figure easily. You could however set up
multiple of these if you wanted to. (eg. 1k - 10-k, 10k - 100k, 100k +)

--
Regards
Darren Gosbell [MCSD]
<dgosbell_at_yahoo_dot_com>
Blog: http://www.geekswithblogs.net/darrengosbell

In article <B71A95BD-AB2F-4332-A7FA-D47DC9BD95C2 (AT) microsoft (DOT) com>,
Word2003memoryLeakage (AT) discussio... microsoft.com says...