topic Re: SSIS / SSAS in Report Server

SSIS / SSAS

capricon — Tue, 19 Mar 2024 04:50:17 GMT

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

Re: SSIS / SSAS

ChrisMuthmann — Tue, 19 Mar 2024 13:43:21 GMT

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?

Re: SSIS / SSAS

capricon — Wed, 20 Mar 2024 05:46:23 GMT

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

Re: SSIS / SSAS

ChrisMuthmann — Wed, 20 Mar 2024 06:24:36 GMT

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!

Re: SSIS / SSAS

capricon — Thu, 21 Mar 2024 09:19:22 GMT

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

Re: SSIS / SSAS

ChrisMuthmann — Thu, 21 Mar 2024 14:06:35 GMT

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.