SSAS cube - Finding count of days overdue per order

0
votes

I'm trying to add a new measure to my OLAP cube, in SSAS.

The fact table is at the order detail level, so each row in the fact table represents an order and a product, like:

Order details
I'd like to add a measure that indicates the maximum number of days overdue per order number. So that measure should say:

OrderNo 1 -> 5 days overdue

OrderNo 2 -> 1 day overdue

OrderNo 3 -> 0 days overdue

I have tried using the MAX operator, with no success.

By the way, this is a multidimensional SSAS schema. I'm using SQL Server 2008.

Thanks in advance!

1
ssasmdxolap
Are we to assume this is SSAS multidimensional and you are trying to create a calculated measure? Or are you trying to make this happen in the DSV before it gets to the cube? What version of SQL Server you are using might also be helpful. – mmarie
It's a multidimensional database on SSAS 2008. Thanks !! – Alvaro VS
How did you try to "use the MAX operator"? Is OrderNo available in the cube as an attribute? – FrankPl
Yes, OrderNo is an attribute of the Fact table (it's a degenerate dimension). – Alvaro VS

1 Answers

1
votes

Just define a measure "max days overdue" or how ever you want to call it in the cube designer, tab "cube structure". In the properties of the measure, use "Max" as the aggregate function. That's it.