• What are these things that are opened or closed? Sales orders? Estimates? Claims? (I guess it really doesn't matter, but it helps me wrap my head around the probem if it's more concrete)

    In what dimension is your Status stored? Wouldn't it just be a matter of putting that in your slicer? (WHERE clause)

    Something like:

    WHERE

    (

    [WhateverItIs].[Status].@[Closed]

    )

    Of course this depends on how your dimension and hirearchies are setup. I hope this isn't so general as to not be of help.

    HTH,

    Rob