I am trying to find the average value(val) for every month(1,2,3,4,...10) for a,b,c on the given cube below.
Here is my query:
select
([Measures].[VAL1],[DIMPROPERTY TIME].[TIMEDIM].[MONTH]) on 0,
{[DIMPROPERTYLENDER].[Hierarchy].[NAME]} on 1
from [PropertyData2016]
I am pretty new to this, so any help is appreciated.