Hi

I would like to provide a cube to e.g. Excel users where I create calculated members that contain the previous year's sales and the year before that. So the Time dimension may logically contain a calculated member called "Previous Year" and "The year before the previous year". Is there a mechansim by which the name of the member (or at least it's display name) can be calculated at run time so that the display name will change as the year roll over

Cheer

Ken

Not without custom programming, vast in the case of Excel.

public @ the domain below
www.tomchester.net

"Ken Eng" <anonymous (AT) discussions (DOT) microsoft.com> wrote

before that. So the Time dimension may logically contain a calculated
member called "Previous Year" and "The year before the previous year". Is
there a mechansim by which the name of the member (or at least it's display
name) can be calculated at run time so that the display name will change as
the year roll over.

Groan

Thanks anyway Tom

Ken