Hello,

In my AS cube I've created a calculated member which returns YTD.
The calc member is part of a dimension 'Time Base' which contains the
members 'In Period' and 'YTD'. It is created by adding a column to the
fact table containing only the value 1. Then I've created the dimension
'Time Base' with a table containing 2 columns and 1 row:
key, which is 1 and name, which is 'In Period'.

The calculated member YTD has the formula:
Sum(YTD(), ([Measures].CurrentMember,[Time Base].&[1]))

So now an end user can switch between 'In period' values or YTD values
for each measure.

My problem is that when you choose YTD it shows ytd-numbers for all
months, including months in the future.

How can I adapt the YTD calculated member in a way that it only shows
YTD values up until the current day?

Kind regards.
Carlos