Post reply

How to relate a date range to a time dimension

  • November 9, 2006 at 9:18 am

    #114179

    I have a requirement to relate a measure with a date range to a time dimension. Specifically, I need to be able to identify the records that include the date from the time dimension in the date range. As a relatively green SSAS developer, I have no idea how to do this ...

    Thanks in advance for your help.

    Simon.

    PS This is in SSAS 2005.

  • November 9, 2006 at 8:43 pm

    #670979

    Hey Simon,

    Are you looking to 'see the records' or more see the total value for all records that fall in that date range?  If it's the latter, I think you can use the colon (":") as a range operator e.g. [date].[year].[1990]:[date].[year].[2001]  .  I think 2005 let's you use null as the left or right operator too to indicate 'to the end' (you may want to check BOL or Mosha's site to confirm this.

    Another approach (seeing as you're using 2k5) you could use a subcube in the where clause to limit the query to just that section of the cube (eg the where clause could have a select statement that selects only that date range from the time dimension.

     

    Steve.

  • November 10, 2006 at 7:34 am

    #671088

    Steve,

    thanks. I'm actually looking to count the total number of people employed during a given month, so it's the "total value for all records that fall in that date range" option. I'll give your suggestion(s) a try and let you know ...

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply