Forum Discussion
Bakhtawar A.
Mar 13, 2024Copper Contributor
where should i start ssis or ssas
Hi i want to ask after installing and all .. first from where should i start.. like first i have SSIS package or SSAS paakcage? if SSIS first will be create then how i integrate that package in ...
Bakhtawar A.
Mar 18, 2024Copper Contributor
yes after ETL process and load all the data then how to use that same data for analytical purpose? like in SSAS?
olafhelper
Mar 18, 2024Bronze Contributor
Yes, creating a cube in SSAS is a good way for reporting in client apps like MS Excel, see the tutorial link I posted before.
- Bakhtawar A.Mar 18, 2024Copper Contributorcreate cube in SSAS? if we create cube in SSAS then what we do in SSIS ? we can also create cube in SSIS right ?
- Bakhtawar A.Mar 18, 2024Copper Contributorolafhelper please respond
- olafhelperMar 18, 2024Bronze ContributorSee my first post.
You can't create cubes in SSIS, but in SSAS.