I have a Month Dimension with a caption like this '2013 - September', but in the charts, I only want it to be displayed as '2013' - because showing the month is a little redundant and takes up room.
A google search has shown that I should be using something like this;
However, when I try and do this, I get this error:
GEN-ERR-0016 the 'substring' function is not supported int he context in which it is used
Is this because the source is a TM1 cube? Or because [CurrentPeriod] is a calculation (that returns the last member that contains data)?
Does anyone have a suggestion on how I can use the 'Month' Level for a member in the query / chart, but display its parent's name - either by showing the name of the parent (i.e. '2013'), or showing on the first 4 characters of the member caption?