3 Replies Latest reply on Oct 1, 2013 11:39 AM by Shawn Wallwork

    Which MDX function to create a time series based on Weeks, not days?

    Jason Caulk

      I'm currently using the "ToDateEx" MDX function to create a calculated time series in our EssbaseCube, via the following syntax.

       

      Todateex("yyyy-mm-dd",[Company Calendar].currentmember.member_name)


      I'd like to use the same methodology to create a weekly view of that same time series.

      The challenge is that the generation level that represents weeks is formatted as "Week XX YYYY".


      Is there a way to leverage the ToDateEx formula to create this time series in weeks?


      If ToDateEx is not the right function to use, I'm open to suggestions.


      Thanks

      Jason