Time Dimension Default member ( ssas 2012)

19/10/2013

SSAS allow you to define a default member for each attribute in each dimension:The most poplar dimension is the TIME dimension...To define the default last non empty date, Click on the dimension, double click on the attribute in which you want to defint the defaulte value:look for the Default value property, click on Custom MDX, Type the following into the MDX expression box, using the MDX Builder features as you find them helpful:Tail(Filter(..Members, NOT IsEmpty(Time.CurrentMember)),1).Item(0) An explanation of the components of the above expression appears in the following table:ExpressionMeaning..Members,Selecting all months ...Filter(..Members,NOT IsEmptyFilter out those months that are "not unpopulated", and ...Filter(..Members,NOT IsEmpty(Time.CurrentMember))Out of...
אין תגובות