I’m looking for a complete MDX solution for a filtered subset based on an attribute, with the kicker that the attribute is of an element represented by a string value in a cube. I have a time dimension, called Periods-Months, and in that dimension I have an attribute called “TM1 Last Day Serial Date”, which holds a numeric value. I also have a control cube, called “Global Variables”, that holds a string value of the last month where Actuals have been loaded. Let’s say this value is “Oct-2019”. I know I can create an MDX subset containing all the months in the future that looks like this:
Code: Select all
FILTER({TM1FILTERBYLEVEL({TM1SUBSETALL([Periods-Months])}, 0)}, [Periods-Months].[TM1 Last Day Serial Date] >= 21853)
What I am looking for is to replace the 21853 with the name of the element which holds the 21853 as an attribute. That element can be found in the Global Variables cube. I know I can get that element by:
Code: Select all
{StrToMember("[Periods-Months].[" + [Global Variables].([Global Values].[Value],[Global Variables].[LACT]) + "]" )}
What I can’t figure out is how to marry these two MDX’s together.