I am currently browsing a cube with MDX using this query
select [Measures].[LOAN] on columns,[Dim Period].[PERIOD].[PERIOD KEY].& on rows from skyebank_financial_cube
The above query hardcode the year and the month from the Period dimension, however is there a way I can modify the query to dynamically find the current year month and year in the cube.
View Complete Post