What is the correct way to get MDX into a CUBE function? I would like to display for my users on their worksheet when the last update of various tables in the data model occurred. We could do this with a macro or another query (probably run by a macro) but it seems there should be a way for a CUBE function to get the information.
This site shows an MDX function GetCubeLastProcessedDate(). Can I get this into a CUBE function on my worksheet so it would automatically update when the relevant table was updated?
This site shows an MDX function GetCubeLastProcessedDate(). Can I get this into a CUBE function on my worksheet so it would automatically update when the relevant table was updated?