Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
learntsql
524 Posts |
 Posted - 2010-01-28 : 04:19:36
|
| Hi..I have fact table in which i am currently storing actual datetime values under variuos columns.I have DateTime Dimension.My requirement is how to capture the fact data to relate with DateTime Dimension. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-01-28 : 06:34:52
|
| you need to be storing only date keys related to dates from datetime dimension in fact. while viewing you make use of relationship fact.datekey=datetimedim.datekey to slice or dice fact measures based on datetime values |
 |
|
|
learntsql
524 Posts |
Posted - 2010-01-28 : 07:08:45
|
| Thank you for your reply.Currently i am maintaining nearly 30 datetime columns in my fact table.Should i create foreignkey for all the columns in Fact table witg DateTime Dimension?What is the best suggested design?One more Query.After deploying cube how to view cube data from front end (VS2008) application.? |
|
|
|
|
|
|
Manage Fact Data