I am creating a cube for one of our fact tables. (ORDER)
If one of the date columns (DeliveryDate) is Non-Null I need to count the
record.
(Basically, I need to count the number of ORDER table records that have non
null in the DeliveryDate column).

I know how to create some standard Measures and Dimensions in a Cube.
Howver, could someone give me the broad steps involved in creating the above
Measure of counting the nonnull DeliveryDate values.

Thanks,
S.Kumar

Create a view on the relational side with the right logic for your measure
and build the cube on the view. Assuming that you're using SQL Server,
CASE
WHEN ShippedDate IS NULL Then 0
ELSE 1
END AS DeliveryCount

Add the DeliveryCount column as a measure to your cube and set the aggregate
function for the DeliveryCount measure to Sum.

"Suresh Kumar" <skumat@pcdiDOTcom> wrote