I am very rusty in my MDX skills. But I am trying to create a calclulated time member in the cube so users can review in (ugh excel) in the calculation of the cube I have a named calc as [4Weeks] The mdx is [Time].[Week].lag(4) When i process and view - the calculation only appears as "[Time].[Year - Month - Week Time Calculations]" The member does not appear until i place a filter on it, and I do not have any results. I've looked in the PACKT publishing MDX Cookbook with no luck and I'll have to admit that the Calandering in SSAS is....well...not exactly the sweet spot of the product!!!