Hi, Is there a way to control the number of records in a cube set.
for example my cube set holds 12 months (1..12). would like to use it for YTD so i want to use only the first 6 items in the set (as the reference for the cube value).
the only way i think to do it is to create a calculated column that only present YTD month and make cubeset on it.
is there a better way
thanks
for example my cube set holds 12 months (1..12). would like to use it for YTD so i want to use only the first 6 items in the set (as the reference for the cube value).
the only way i think to do it is to create a calculated column that only present YTD month and make cubeset on it.
is there a better way
thanks