DE.PREV
Returns the element in the dimension sequence prior to the element specified.
Syntax
DE.PREV(Dimension, Element)
Example
The order of the elements in the REGION dimension are Angola, Botsuana and Egypt, so this example returns Angola:
DE.PREV('REGION', 'Botsuana')
If the element has no predecessor (that is, if it is the first element in a dimension) then an empty string is returned.