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-07-13 : 02:02:57
|
| Hi All,Can we create a Fact table without measure column?i.e Fact table contains only foreign keys of all the dimension tables.If possible what is that design is called?What kind of aggregations can be applied?Please guide me in the right directionTIA. |
|
|
slimt_slimt
Aged Yak Warrior
746 Posts |
Posted - 2010-07-13 : 16:12:59
|
| hi,a fact table without one measure is useless, because you won't be able to do anything with all the dimensions in a star schema (or snowflake schema). SSAS 2005 will by default give you at least one measure (most probably count of all rows in your fact table) in order for you OLAP cube to be "browsable".Aggregations are truly the last part in cube. once cube is deployed and you have the plan how many times per day/week you will deploy your cube with fresh data, you will start creating partitions and aggregations -> but only if you have fact table bigger than 10mio rows. |
 |
|
|
learntsql
524 Posts |
Posted - 2010-07-14 : 00:14:40
|
| ThankQ. |
|
|
|
aloeyey
Starting Member
2 Posts |
Posted - 2010-09-05 : 01:25:49
|
| Hi Friend,Please help me how to use SQL Analysis services .....ie creating cube.Your help highly appreciated.Dubey,Alok |
|
|
|
slimt_slimt
Aged Yak Warrior
746 Posts |
Posted - 2010-09-05 : 10:51:11
|
| creating cube: - you must have fact table- dimension tablesyou bind all tables in SSAS creating OLAP cube. |
|
|
|
|
|
|
Fact table without measure column?