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 this right
help me out
5 Replies
The Microsoft BI Stack (Business Intelligence) is a suite of tools and technologies that assist businesses in data collection, processing, and analysis. Here are some key components of the Microsoft BI Stack:
Power BI: A powerful self-service BI platform that allows users to visualize, analyze, and share data. Power BI provides interactive dashboards, reports, and datasets.
SQL Server Analysis Services (SSAS): An OLAP and data modeling tool that enables the creation of multidimensional and tabular data models.
SQL Server Integration Services (SSIS): An ETL (Extract, Transform, Load) tool that extracts data from various sources, transforms it, and loads it into a data warehouse or database.
SQL Server Reporting Services (SSRS): A tool for creating, managing, and delivering reports. SSRS allows the creation of both static and interactive reports.
Creating Cubes is described in this article: Analysis Services Tutorials | Microsoft Learn
Therefore you need Visual Studio or Tabular Editor.
Could you please describe the cube you have created in SSIS?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!
