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