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?
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"
)}