question

siera_gld avatar image
siera_gld asked

MDX Calculated Time

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!!!
ssasmdxtimecalculations
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

· Write an Answer

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.