Forum Discussion
SSIS / SSAS
HI i created a cube in SSIS now i want to use that cubes in SSAS for analysis purpose.. so i want to know how to use it and secondly some one told me that we can not create cubes in SSIS .. is...
SO In short SSIS for transform the data . and SSAS is for analyze the data .. right ?
so i created this package on SSIS .. now how i used this package in SSAS ?
You do not use this package in SSAS. You can use SSIS to write new data back to the database and then use Visual Studio or Tabular Editor to create a cube based on the data in your tables/views.
After that you deploy the cube to SSAS, process and use it. Please have a look at the link provided above.
HTH!