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 |
|
thinkingeye
Starting Member
7 Posts |
 Posted - 2012-06-13 : 11:53:28
|
| Hi All, I'm new to sql server and SSAS. I have a requirement where in i need to add a new cube to already existing set of 6 cubes. On the SSIS side i have loaded data from external sources and created 3 new tables. I'm planning to use the existing DIMENSIONS as there is no need for new ones. Using the three tables how can i create a new FACT table? I tried by right clicking on the DIMENSIONS "Create new dimesnion is the only option that i see", also i have a query that is based of these 3 tables. Can i used that instead to buold a FACT able? If YES where and how can i use it, as i didnt come across any options. Please need help. Thanks |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2012-06-13 : 12:12:55
|
| I would put your query into a view and use that as the fact table. You will probably want to materialise it at some point.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
thinkingeye
Starting Member
7 Posts |
Posted - 2012-06-13 : 12:23:08
|
| Thanks , but i already created a new table based off the 3 tables. My question is when i right clicked on the DIMENSIONS and clicked on CREATE A NEW DIMENSION, i do not see the new table that i created in the list of the tables, all it shows is the list of the DIMENSIONS that already exist. |
|
|
|
|
|
|
please need help with FA