Hi friends,
I have one date with name Allocationdate i am getting that as a dimension from universe .
Allocationdate is Dimension
I have measure withname date1 where date1 =max(Allocationdate)
where date1 is appearing as measrure.
For my report requirement i need the rank between these two
ie rank(date1;Allocationdate) but i am getting as context error where the same is coming fine in Deski
Please help me how can i resolve this context error
raju_souju1 (BOB member since 2008-09-23)
I don’t understand what you are trying to get.
what is the rank between two dates?
besides that…the formula you used will give you the rank of date1 WITHIN each allocation date…for example…the max.date for 6/1/2010.
I don’t think that is what you are trying to accomplish.
maybe something like rank(date1;customer) so it will rank the max.date of each customer…in other words…the rank the customers in order of the last time a transaction was allocated for them.
esiegel (BOB member since 2009-11-09)