dbTalk Databases Forums  

2 date dimensions

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss 2 date dimensions in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
aaron kempf
 
Posts: n/a

Default 2 date dimensions - 11-22-2004 , 09:03 PM






I have a table with 2 date fields.

I would like to be able to sort/filter on each of these fields
independently. Basically, one is for project start date, and one is for
project completion date. I can't do age, or anything easy.. Since a lot of
the projects have wierd completion dates (this data comes from an as400 and
it looks like they dont have very good validation in their programs).

In the 2nd date field, there are a lot of values that aren't within
acceptable values--

Should i just make a named set that has like the ranges that I want; and
then give people the ability to query a group at a time?

I can't figure out what I need to do in order to do this-- previously I have
made a view with a seperate copy of this data, and then joined to that.. it
just seems so inefficient.




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.