MDX to filter dimension by their name

  • Hi,

    I have an account dimension with 500k accounts. I want to filter all accout's with an number (dimension name) between 300000 and 400000. Is that possible or must I generate a measure that contains the account number to filter it.

    Regards

    Ralf

  • Use the ":" function

    http://msdn.microsoft.com/en-us/library/ms146001.aspx

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • Henrico!

    super, thanks for ":".

    Regards

    Ralf

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply