Process a SSAS Tabular Cube // Multiple Ways

Подписаться 40 тыс.

Просмотров 19 тыс.

50% 1

►► Establish a Well-Structured Data Warehouse for Your Small Team In 90 Days (Free Guide) → www.kahandatasolutions.com/guide
If you have a Tabular Cube, you'll need to process it one way or another.
In this video, I will walk through some of the common ways to get that done in both SQL Management Studio as well as SSIS (Visual Studio).
Timestamps:
0:00 - Intro
0:15 Process Directly in SSAS
2:18 Use SSIS Components
6:11 Using SQL Server Job
9:08 Closing
Title & Tags:
Process a Tabular Cube - Multiple Ways | SQL Server Analysis Services (SSAS) Tutorial
#ssas #dataengineering

Опубликовано:

29 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 41

@KahanDataSolutions 3 года назад

►► Establish a Well-Structured Data Warehouse for Your Small Team In 90 Days (Free Guide) → www.kahandatasolutions.com/guide

@kayayunus11 Год назад

Hey do you know how to configure SSAS so I can connect to it from a powerBI in another server

@xandr4870 Месяц назад

Finally, some actually easily digestable SSAS youtube content. There is virtually nothing out there. Lifesaver!

@navbi9907 2 года назад

Man, beautiful video. Short concise and to the point and well covered with all the options.

@KahanDataSolutions 2 года назад

Much appreciated!

@pabeader1941 2 года назад

A year later and still helpful. Answered my exact question without me even having to ask. Thank you for posting this video.

@KahanDataSolutions 2 года назад

Glad it helped!

@gerhardsamstag5032 3 года назад

Great, Great and Great! This is the Solution of one of my Problems. Please more of SSAS Tabular Topics.

@KahanDataSolutions 3 года назад

Awesome!

@TAIMIUWU 2 года назад

Brilliant work. Very useful tips. Thanks for putting up this video.

@KahanDataSolutions 2 года назад

Glad it was helpful!

@humanbeing3062 3 года назад

Awesome content! Thanks for sharing!

@KahanDataSolutions 3 года назад

Thanks for watching!

@DionnyPrensa 9 месяцев назад

Thanks, Michael. It has helped me a lot. Now, I need to automate the Code Deployment instead of Data. For example: Add or remove a Measure. I need to deploy the changes, but I don't want to use my laptop to deploy the code and the new data.

@samuelminamioka5393 3 года назад

Very good video, bro! Thank you very much

@KahanDataSolutions 3 года назад

Thanks for watching!

@chandrashekaryennedla6409 Год назад

Thanks a lot . As usual awesome content

@abolfazlhosseinzadeh2732 10 месяцев назад

I'd stocked at the role part so my job couldn't be done. thanks for the details in your videos ❤

@arturrubets 2 года назад

You are the best!

@KahanDataSolutions 2 года назад

Thank you!

@mrgogate 2 года назад

Thank you... it was helpful!!

@KahanDataSolutions 2 года назад

Glad it helped!

@abhiveer6353 11 месяцев назад

@kahanDatasolutions - Can you please share the ways to process MDX cube from Azure Data Factory

@viniciusferreira6807 Год назад

minute 3:21. what to do when objects are not selectable?

@noahhadro8213 Год назад

Does process full drop all partitions and reload them or does it honor incremental refresh?

@abcthegreat1 Год назад

Can SSIS be used when model lives on power bi premium. (can you point SSIS to the the premium workspace URL)

@HeshamNasser0 Год назад

which solution is better in protective of memory ?

@danilocampana 2 года назад

thanks for the video, would it be possible to teach you how to configure auto-update in Azure SSAS

@KahanDataSolutions 2 года назад

Hi Danilo, thanks for watching! I'm planning on adding some Azure SSAS content in the future and will keep this in mind.

@rafibasha4780 Год назад

refreshing a partition in a script mode?

@billysun1059 Год назад

Hi，Guys, I have an error message "DDL is not valid" after I paste the code from SSMS to SSIS Analysis DDL task, any idea?

@marounsader318 2 года назад

hi im having the same error but when i run SSIS pckg, can you please help or refer me to a reference to fix it

@jurajcichansky2578 3 года назад

Great video. Is there a way how to process 2 cubes at once? Thanks

@KahanDataSolutions 3 года назад

Thanks! You should be able to process multiple by running two of the SSIS components in parallel or have two SQL Agent jobs triggered at the same time but pointed to different cubes.

@thomashannoveraner356 2 года назад

Hi. Whats the difference between refreshing in SSMS and deploying in Visual Studio. Create and deploy refreshes my Cube Dimensions also I think?

@KahanDataSolutions 2 года назад

Hi Thomas, yes they should operate the same in that scenario

@theheritageleatherco5812 2 года назад

How do I process a cube if I don't have access to SSIS, and I don't have access to the SQL Server Agent to create a job? Do you know of way to do this through Powershell or something else?

@gwenhumphrey1968 3 года назад

Great vid. How do I close a cube no longer needed?

@KahanDataSolutions 3 года назад

Thanks Gwen! Are you talking about dropping the entire cube from your server? If so, you should be able to just do a right-click + delete from SSMS if needed.