tags:

views:

62

answers:

0
+1  Q: 

MDX Filter

I have a cube in Analysis Services 2005 with sell quotes we make for our customers.

Each quote can have many revisions.

Each revisions has a date when it was made.

[Quotes Data] is my Fact table

I need to filter (see "true" in the query below) to get only the latest revision per quote (in bold).

Quote        Revision Date                 Total 
12245               1 2/25/2003  9:24  $6,867.09  
12245               2 2/25/2003  9:24  $7,715.00  
12245               3 3/3/2003  13:25  $9,275.00  
12245               4 3/24/2003 16:53  $8,440.25  <----

select filter({
               (
                ([Quotes Data].[Quoteid].children,
                 [Quotes Data].[Revision].children
                )
               ,[Quotes Data].[Date].children)
              },true) on rows,
[Measures].[Total] on columns 
from [QuoteBuilder]

Is there a way I can do that?

Thanks