Dynamic Members using MDX

By - Updated August 12, 2015

You can use MDX to determine the current day dynamically by using VB functions. MDX supports VB functions and you can use it directly in MDXScript (when defined on models/cubes) or within your variables when used as part of your form definition.

By using a combination of VB functions, you can dynamically resolve a member in MDX:

Run the examples below to see the results: