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 |
|
rubble
Starting Member
24 Posts |
 Posted - 2007-09-11 : 13:04:59
|
| New to SSAS so, have some not so intelligent ???We have created Dimensional Model within SQL 2005 and created SSIS packages to load. We have Pk's on Dimensions and FK's on one Fact table. We are thinking about adding clustered index to Fact that consists of the FK's and order by the Hierarchy within the Fact by Dimension. IS THIS A GOOD IDEA IF WE DRILL DOWN AND DRILL THROUGH = QUESTION #1We build a CUBE from the dimenionsal model and we do not know how to build indexes on the cube. SO DOES SSAS AUTOMATICALLY BUILD INDEXES IT THINKS IT NEEDS ON THE CUBE AND DO YOU KNOW WHAT THEY ARE?? ALSO IF WE HAVE INDEXES ON DIMENSIONAL MODEL DO THOSE GET USED BY SSAS CUBE THAT WE CREATED WITH AUTO BUILD??? = QUESTION #2..THank you |
|
|
rubble
Starting Member
24 Posts |
Posted - 2007-09-11 : 14:12:13
|
| Asking stupid ??? how do you manage or create indexes within the SSAS cubes you create???? HELP |
 |
|
|
rubble
Starting Member
24 Posts |
Posted - 2007-09-12 : 12:02:29
|
| STILL NOT HELP FROM ANYONE ON THIS.... Is this a stupid question that no one wants to answer or No ONE KNOWS????????????????/ |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-12 : 23:10:11
|
| Not as I know of. |
|
|
|
rubble
Starting Member
24 Posts |
Posted - 2007-09-13 : 09:31:18
|
| What does that mean.. You do not know the answer to my questions above? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-13 : 23:25:55
|
| I don't if there is anyway to create index in cube manually. |
|
|
|
|
|
|
Indexes within SSAS cubes