I used the BIDS wizard to create a time Dimension and to populate it
with data.

Then the Cube Wizard rightly detected heirarchies etc and I have two of
them (Year,Qtr, Month, Week,Date) and YWD(Year,Week,Date). So far so
good.

However, all my attempts to use PeriodToDate have failed. I have used
all Combinations like Time.Date, Time.Date.Date, Time.YWD.Date, Date,
Time.Levels(Index) and so on for the Level Function (arg1) and
..CurrentMember for Member(arg2). I always get errors that the Function
expects a Level Expression but found a Dimension, or a Heirarchy
expression, or a Member expression.

I find that I have a Dimension Attribute, a Heirarchy level, and a
Level within the Dimension Attribute (as displayed in the Calculation
Tools Metadata in Cube Design - Calculations tab), all three of these
are named Date.

What am I doing wrong?Am I having probs because of name collision? Do I
need to rename stuff?

thanks for your help.