I have a fact table FactSales & it joins to a dimension table DimCustomer.
The fact table has a date column besides other columns. This will go as a fact dimension
My Query is like this
SELECT Measures.[Sales Count] ON columns,
non empty
{(
[DimCustomer].[Customer Name].[Customer Name].ALLMEMBERS *
............
............
.........Other members.........
............
)} ON ROWS
FROM [DATA MART]
WHERE <<Where Clause>>
I need a value which is the maximum date in the factdimension for each particular set of row that is returned.
Any ideas?
View Complete Post