MDX Filter

[missspeedy23]

I have a dimension for year and I only want to show years that are greater than or equal to the current year value which is held in an admin cube - can someone help me with the MDX code for this please?

[madan3.14]

Hi - Not Sure if you have already found a way to this , but below solution works, create an attribute on Year dimension and call it in MDX as a filter as shown below:
Dimension = Year in your case
AttributeName = Attribute Name you have created for this purpose

{FILTER({TM1SORT( {TM1FILTERBYLEVEL( {TM1SUBSETALL( [Dimension)] )}, 0)}, ASC)},
    [}ElementAttributes_Dimension].([}ElementAttributes_Dimension].[AttributeNAme]) = "Y"
)}