none
Get String from Dimension Time RRS feed

  • Question

  • Hi,

    I want to get Latest date in time dimension like example:

    I have a [Date] Dimension in [Adventure Works]. In date Dimension there are: CY 2005, CY 2007,…,CY 2010.

    I Want to get latest year “CY 2010” to create some custom calculation member like: current year, current year complete.

    Like current year:

    sum([Measures].[Internet Sales Amount],[Date].[Calendar].[Calendar Year].&[2010])

    or current year complete:

    sum([Measures].[Internet Sales Amount],[Date].[Calendar].[Calendar Year].&[2009])

    How can I get String from Date dimension or some way else to solve my problem? Many thanks.

    Monday, May 9, 2011 11:54 AM