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.
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.
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
Posted - 06/13/2012 : 11:53:28
