none
Get String from Dimension Time RRS feed

  • السؤال

  • 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.

    06/جمادى الثانية/1432 11:54 ص