link multiple date fields to time dimension

This is a discussion on link multiple date fields to time dimension within the sqlserver-datawarehouse forums in Data Warehousing category; Hi, this is probably a simple question. I want to link multiple date columns to a time dimmension. (order date,order complete date, delivery date,etc). So far I 've only worked with sales slip tables containing only one date . is it neccesarry to have the same table as different meassure group in the cube with the date linked to one of the other fields or is there a better way? Regards Michael...

Go Back   Database Forum > Data Warehousing > sqlserver-datawarehouse

Database Forums

Register FAQ Calendar Search Today's Posts Mark Forums Read
  #1  
Old 07-16-2008, 04:42 AM
Default link multiple date fields to time dimension

Hi,

this is probably a simple question. I want to link multiple date columns to
a time dimmension. (order date,order complete date, delivery date,etc). So
far I 've only worked with sales slip tables containing only one date .

is it neccesarry to have the same table as different meassure group in the
cube with the date linked to one of the other fields or is there a better
way?


Regards

Michael


Reply With Quote
Reply


Thread Tools
Display Modes



All times are GMT -4. The time now is 04:42 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Integrated by bbpixel2008 :: jvbPlugin R1013.368.1

Search Engine Friendly URLs by vBSEO 3.1.0
vB Ad Management by =RedTyger=
In an effort to better serve ads to our visitors, cookies are used on Mydatabasesupport.com. For more information, check out our Privacy Policy.