SSIS / SSAS

[capricon]

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

[ChrisMuthmann]

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:

1. 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.

2. SQL Server Analysis Services (SSAS): An OLAP and data modeling tool that enables the creation of multidimensional and tabular data models.

3. 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.

4. 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?

[capricon]

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 ? 

@ChrisMuthmann 

[ChrisMuthmann]

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!

[capricon]

@ChrisMuthmann 

I created this package (above) which i send is in visual studio .. so after creating the package in SSIS  .. what is the next step ? to create a cube or what ?

the links you provided i did not understand so i am asking the questions .. 

[ChrisMuthmann]

You can write data in a datawarehouse with the SSIS package. 

Then you have to decide which kind of analysis service you want to use in the future: tabular or multidimensional?

Then you can use Visual Studio with an SSAS project to create a cube. The connection in this projects is the datawarehouse you have created before. 
For more information you can search in youtube e.g. for ssas tutorials.