Results 1 to 1 of 1

Thread: Rolling year in cube

  1. 09-08-2003, 04:44 PM #1
    Charles1700
    Charles1700 is offline Registered User
    Join Date
    Sep 2003
    Posts
    1

    Rolling year in cube

    Hi,

    I create a cube based on Date_of_visit table. I am using MS SQL server 2000, analysis manager.
    how can I create a dimention which can provide data by rolling year. which means, I need a whole year data such as from 1/1/2000 to 12/31/2000, and 2/1/2000 to 1/31/2001, 3/1/2000 to 2/28/2000 and so on.
    many thanks.

    Charles
    Last edited by Charles1700; 09-08-2003 at 04:46 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules