Process a SSAS Tabular Cube // Multiple Ways

Поделиться
HTML-код
  • Опубликовано: 1 фев 2025

Комментарии • 43

  • @KahanDataSolutions
    @KahanDataSolutions  4 года назад

    Want to build a reliable, modern data architecture without the mess?
    Here’s a free checklist to help you → bit.ly/kds-checklist

    • @kelek22
      @kelek22 2 года назад

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

  • @xandr4870
    @xandr4870 7 месяцев назад

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

  • @navbi9907
    @navbi9907 3 года назад +4

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

  • @pabeader1941
    @pabeader1941 3 года назад +1

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

  • @gerhardsamstag5032
    @gerhardsamstag5032 4 года назад

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

  • @TAIMIUWU
    @TAIMIUWU 3 года назад +1

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

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

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

    You are the best!

  • @humanbeing3062
    @humanbeing3062 3 года назад +1

    Awesome content! Thanks for sharing!

  • @abolfazlhosseinzadeh2732
    @abolfazlhosseinzadeh2732 Год назад

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

  • @chandrashekaryennedla6409
    @chandrashekaryennedla6409 Год назад

    Thanks a lot . As usual awesome content

  • @samuelminamioka5393
    @samuelminamioka5393 3 года назад +1

    Very good video, bro! Thank you very much

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

    Thank you... it was helpful!!

  • @СашаЛысаков-л5ж
    @СашаЛысаков-л5ж 3 дня назад

    Hello. And how to do the first method, what did you do in Visual Studio, to select which tables need to be updated, which not? Only all this in SQL Management Studio?

  • @danilocampana
    @danilocampana 3 года назад +1

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

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

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

  • @viniciusferreira6807
    @viniciusferreira6807 2 года назад

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

  • @abhiveer6353
    @abhiveer6353 Год назад

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

  • @thomashannoveraner356
    @thomashannoveraner356 3 года назад +1

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

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

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

  • @nagelfamily
    @nagelfamily 4 месяца назад

    does “full” add in newly created columns?

  • @HeshamNasser0
    @HeshamNasser0 Год назад

    which solution is better in protective of memory ?

  • @abcthegreat1
    @abcthegreat1 2 года назад

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

  • @noahhadro8213
    @noahhadro8213 2 года назад

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

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

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

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

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

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

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

  • @rafibasha4780
    @rafibasha4780 Год назад

    refreshing a partition in a script mode?

  • @billysun1059
    @billysun1059 2 года назад

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

  • @theheritageleatherco5812
    @theheritageleatherco5812 3 года назад

    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?