Process a SSAS Tabular Cube // Multiple Ways

Get my Modern Data Essentials training (for free) & start building more reliable data architectures

-----

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

[KahanDataSolutions]

Get my Modern Data Essentials training (for free) & start building more reliable data architectures

[xandr]

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

[navbi]

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

[pabeader]

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

[gerhardsamstag]

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

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

[TAIMIUWU]

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

[abolfazlhosseinzadeh]

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

[samuelminamioka]

Very good video, bro! Thank you very much

[chandrashekaryennedla]

Thanks a lot . As usual awesome content

[abhiveer]

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

[nagelfamily]

does “full” add in newly created columns?

[noahhadro]

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

[thomashannoveraner]

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

[HeshamNasser]

which solution is better in protective of memory ?

[danilocampana]

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

[abcthegreat]

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

[billysun]

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?

[theheritageleatherco]

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?

[marounsader]

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