Process a SSAS Tabular Cube // Multiple Ways

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).
►► The Starter Guide for The Modern Data Stack (Free PDF)
Simplify the “modern” data stack + better understand common tools & components → bit.ly/starter-mds
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

[@KahanDataSolutions]

►► The Starter Guide for The Modern Data Stack (Free PDF)→ bit.ly/starter-mds Simplify “modern” architectures + better understand common tools & components

[@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]

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

[@KahanDataSolutions]

Much appreciated!

[@pabeader1941]

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

[@KahanDataSolutions]

Glad it helped!

[@gerhardsamstag5032]

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

[@KahanDataSolutions]

Awesome!

[@TAIMIUWU]

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

[@KahanDataSolutions]

Glad it was helpful!

[@humanbeing3062]

Awesome content! Thanks for sharing!

[@KahanDataSolutions]

Thanks for watching!

[@DionnyPrensa]

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]

Very good video, bro! Thank you very much

[@KahanDataSolutions]

Thanks for watching!

[@chandrashekaryennedla6409]

Thanks a lot . As usual awesome content

[@mrgogate]

Thank you... it was helpful!!

[@KahanDataSolutions]

Glad it helped!

[@abolfazlhosseinzadeh2732]

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

[@arturrubets]

You are the best!

[@KahanDataSolutions]

Thank you!

[@abhiveer6353]

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

[@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 ?

[@marounsader318]

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

[@theheritageleatherco5812]

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?

[@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?

[@danilocampana]

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

[@KahanDataSolutions]

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

[@jurajcichansky2578]

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

[@KahanDataSolutions]

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]

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

[@KahanDataSolutions]

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

[@viniciusferreira6807]

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

[@gwenhumphrey1968]

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

[@KahanDataSolutions]

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.