Craig Utley
Craig Utley
  • 35
  • 532 827
QuickHit #4 - Cube Sparsity and Query Performance
This video is a QuickHit covering the concept of cube sparsity and how it can affect calculations in a query. You'll see examples of a simple query change and the dramatic impact it can have on performance, and how to monitor the cells being calculated.
zhlédnutí: 2 581

Video

QuickHit #3 - Incremental Fact Processing
zhlédnutí 6KPřed 9 lety
How do you perform incremental measure group/partition processing without duplicating data? See how to use the ProcessAdd XMLA command and modify the query to accurately load facts incrementally. (11 minutes)
QuickHit #2 - Attributes, Keys, and Hierarchies
zhlédnutí 4KPřed 9 lety
Adding an attribute to a natural hierarchy sometimes involves setting up a compound key in the KeyColumns property. What if you also want that attribute available without the effects of the compound key? (6.5 minutes)
QuickHit #1 - Ignore Unrelated Dims and Calculated Measures
zhlédnutí 3,6KPřed 9 lety
This video discusses how IgnoreUnrelatedDimensions works with calculated measures. (5 minutes)
MDX 101 MDX Basics and Structure
zhlédnutí 42KPřed 9 lety
This video is the first in an introductory series about MDX. This video discusses the basics of MDX including usage, tuples, sets, and the basic structure of an MDX query. (27.5 minutes)
MDX 102 Hierarchy Navigation
zhlédnutí 18KPřed 9 lety
This video describes how to navigate attribute and user hierarchies. Set and Member Functions are discussed, and all code is shown running in SSMS. (19.5 minutes)
PPS 101 Introduction to PerformancePoint Server
zhlédnutí 831Před 9 lety
This video discusses PerformancePoint Server and its three modules: Monitoring, Analytics, and Planning. You'll learn what the three modules do and how they fit together to form a comprehensive solution. (21 minutes)
SSAS 122 Translations
zhlédnutí 5KPřed 9 lety
This video covers translations in Analysis Services. After a quick overview of translations, you will learn how to create them for both the cube and dimensions. You'll see how to change captions as well as dimension data. (14.5 minutes)
SSAS 123 Perspectives
zhlédnutí 6KPřed 9 lety
This video covers perspectives in Analysis Services. You'll learn what perspectives are, see how to create them, and then use them in a client tool. The video also compares perspectives to views in a relational database. (10.5 minutes)
SSAS 121 Partitions
zhlédnutí 21KPřed 9 lety
Learn what partitions are, how to create partitions using table or query binding, and how to merge partitions. (22 minutes)
SSAS 120 Storage Modes
zhlédnutí 14KPřed 9 lety
This video covers storage modes in Analysis Services. You'll learn about MOLAP, ROLAP, and HOLAP and see how to change the settings for dimensions and cube partitions. (16.5 minutes)
SSAS 118 Standard Actions
zhlédnutí 5KPřed 9 lety
This video is about standard actions in Analysis Services. It shows the creation and use of a URL action. (12.5 minutes)
SSAS 119 Reporting Actions
zhlédnutí 7KPřed 9 lety
This video covers reporting actions in Analysis Services. It shows how to call a report in SSRS and pass parameters. (16.5 minutes)
SSAS 117 Drillthrough Actions
zhlédnutí 12KPřed 9 lety
This video covers drillthrough actions in Analysis Services. It shows how to set them up and describes fact dimensions and their use in drillthrough. (19 minutes)
SSAS 115 KPIs
zhlédnutí 11KPřed 9 lety
This video covers Key Performance Indicators (KPIs). Learn how to create KPIs, including the value, goal, status, and trend. (27 minutes)
SSAS 111 Aggregation Basics 2005
zhlédnutí 6KPřed 9 lety
SSAS 111 Aggregation Basics 2005
SSAS 116 Actions Introduction
zhlédnutí 9KPřed 9 lety
SSAS 116 Actions Introduction
SSAS 110 Dimension Usage
zhlédnutí 17KPřed 9 lety
SSAS 110 Dimension Usage
SSAS 114 Calculations
zhlédnutí 37KPřed 9 lety
SSAS 114 Calculations
SSAS 113 Working with SCD
zhlédnutí 11KPřed 9 lety
SSAS 113 Working with SCD
SSAS 109 Attribute Relationships
zhlédnutí 28KPřed 9 lety
SSAS 109 Attribute Relationships
SSAS 112 Aggregation Basics 2008
zhlédnutí 14KPřed 9 lety
SSAS 112 Aggregation Basics 2008
SSAS 107 Creating Dimensions
zhlédnutí 29KPřed 9 lety
SSAS 107 Creating Dimensions
SSAS 108 Creating Hierarchies
zhlédnutí 27KPřed 9 lety
SSAS 108 Creating Hierarchies
SSAS 106 Basic Deploying, Processing, and Browsing
zhlédnutí 25KPřed 9 lety
SSAS 106 Basic Deploying, Processing, and Browsing
SSAS 104 The Cube Wizard SSAS 2005
zhlédnutí 14KPřed 9 lety
SSAS 104 The Cube Wizard SSAS 2005
SSAS 105 The Cube Wizard SSAS 2008
zhlédnutí 14KPřed 9 lety
SSAS 105 The Cube Wizard SSAS 2008
SSAS 103 Data Source Views
zhlédnutí 22KPřed 9 lety
SSAS 103 Data Source Views
SSAS 102 Creating Projects and Data Sources
zhlédnutí 28KPřed 9 lety
SSAS 102 Creating Projects and Data Sources
Basics 104 Why BI Projects Fail
zhlédnutí 3,1KPřed 9 lety
Basics 104 Why BI Projects Fail

Komentáře

  • @alfaalfa9255
    @alfaalfa9255 Před 8 měsíci

    666

  • @alfaalfa9255
    @alfaalfa9255 Před 8 měsíci

    video de merda n vejam

  • @mouazalem
    @mouazalem Před rokem

    These are awesome. Thank you.

  • @Victor-yn6lv
    @Victor-yn6lv Před rokem

    Thank you very much for your video. Your explanation is very clear.

  • @mtrudel
    @mtrudel Před 2 lety

    Hi Craig, do you do consulting ? I would hire you for a few hour consultation

  • @ramakrishnapaduchuri9439

    awesome explanation

  • @chris8534
    @chris8534 Před 2 lety

    Ahhh the good old days - when software could just have a drop down for male and female. Now that field is a network stress tester

  • @alihtech3876
    @alihtech3876 Před 2 lety

    Can you please make a video on the system processes

  • @rafael6693
    @rafael6693 Před 2 lety

    can you update your ssas videos? a lot has changed since that ssas version.

  • @doornbloem
    @doornbloem Před 2 lety

    this was actually quite entertaining, unexpectedly! The saying goes that people are suckers for anecdotes and, well, that's what I got here :) nearing the year 2022, some of the information is a bit dated, but I reckon that most is still valuable and relevant today. I would love to see an updated version of this.

    • @rafael6693
      @rafael6693 Před 2 lety

      do you work with ssas?

    • @doornbloem
      @doornbloem Před 2 lety

      @@rafael6693 no, and I probably don't even want to! :) In fact, I started this series with the aim of understanding MDX a bit better, for possible use in Excel. I don't even use databases other than oracle, and then only through the front-end.... What I liked about this video was the field experience part, which I reckon mr. Utley may have gotten more of since the last 7 years.

  • @54tutu8
    @54tutu8 Před 3 lety

    12:33 Parent-Child Relationship

  • @sands7779
    @sands7779 Před 3 lety

    recommend for IT departments starting a data warehouse project

  • @SSM_33
    @SSM_33 Před 3 lety

    the best tutorial in youtube

  • @FoodieMing
    @FoodieMing Před 3 lety

    Thanks Craig!! This is so helpful.

  • @FoodieMing
    @FoodieMing Před 3 lety

    Thank you!

  • @Harry-qh5rt
    @Harry-qh5rt Před 3 lety

    Looks like this guy has ripped off your work: czcams.com/video/uC5PS16qixk/video.html

  • @patrickmba
    @patrickmba Před 4 lety

    Best explanation ever!!! Thank you.

  • @sohaibelbokhari8319
    @sohaibelbokhari8319 Před 4 lety

    Useless !! you have to show us steps to create actions not the results of actions.

    • @craigutley862
      @craigutley862 Před 4 lety

      That's what videos 117, 118, and 119 show.

    • @ahmadbahrami9437
      @ahmadbahrami9437 Před 4 lety

      You'd better be grateful than being judgy. He is sharing his knowledge freely

    • @sohaibelbokhari8319
      @sohaibelbokhari8319 Před 4 lety

      @@craigutley862 thanks sir i didn't realise that

    • @sohaibelbokhari8319
      @sohaibelbokhari8319 Před 4 lety

      @@ahmadbahrami9437 I would not be grateful for wasting 10 minutes of my time.

  • @helloranjan89
    @helloranjan89 Před 4 lety

    Great stuff but how to process only the latest partitions !

  • @shanmukhayarabham4995

    is ti also works for SSAS Tabular model?? what happens when we don't have the measureGroups, since in Tabular we don't have it right... Please help me in getting the script for Tabular model incremental refresh

  • @drypainting
    @drypainting Před 4 lety

    Amazing...! Can we also perform Reporting actions to Power BI Report?

  • @mmastar93
    @mmastar93 Před 4 lety

    Thank YOU. Learning enough MDX for Calculated Members in Tableau

  • @Jenny-wk7jq
    @Jenny-wk7jq Před 4 lety

    Very very helpful. Question: is using join slower than building attribution relationships first? I tried both approaches but join took a long time

  • @lukasyu1204
    @lukasyu1204 Před 4 lety

    I think this is more a Database work than AS work, right ??

  • @curiousmind9825
    @curiousmind9825 Před 4 lety

    Please upload a video how to write also calculate dax query into ssas multidimensional cube.

  • @curiousmind9825
    @curiousmind9825 Před 4 lety

    I need to calculasales amount which filter data by monthname and salespont also show into cube browser per month which salespoint sales high. Please help me.

  • @latui7350
    @latui7350 Před 5 lety

    This is still the *best* explanation I've found on Attribute Relationships. Thanks for finally enabling this make sense to me.

  • @MehrdadAlemi
    @MehrdadAlemi Před 5 lety

    Hi Craig, Thank you for providing the SSAS Tutorial, I started educating myself around this interesting topic and I learned a lot... However, I couldn't find the related SSAS Administrative clips in security and maintenance...So, could you navigate me, please?

  • @rakkhnaka
    @rakkhnaka Před 5 lety

    You are a magic man, and you got magic hands!

  • @rickgs8
    @rickgs8 Před 5 lety

    Thank you, this really helped me a lot!

  • @Bari77yt
    @Bari77yt Před 5 lety

    Very helpful tutorials.

  • @kreliss2245
    @kreliss2245 Před 5 lety

    Thank you sir, still relevant in 2019

  • @RC-nn1ld
    @RC-nn1ld Před 5 lety

    Really Really Great Explanation, thank you!!!

  • @bogdangirdea8929
    @bogdangirdea8929 Před 5 lety

    creat job, thank you

  • @wuup1278
    @wuup1278 Před 5 lety

    Thank you

  • @sygu2491
    @sygu2491 Před 5 lety

    Hello, would love to have more tutorials on MDX thank you

  • @Stelios.Posantzis
    @Stelios.Posantzis Před 5 lety

    Great point. There's a lot of "professionals" out there that fail to get this.

  • @kushalgunoo157
    @kushalgunoo157 Před 5 lety

    where did you get the XMLA script did you wrote it or it was generated automatically?

  • @jliou9428
    @jliou9428 Před 5 lety

    Thanks so much for the tutorial! It's very helpful!

  • @rymndmln7416
    @rymndmln7416 Před 5 lety

    I downloaded these vids from your website years ago (still have them), and even gave you a donation (likely one of the few). I really wish you were still making these types of vids, Craig. So much better than most others.

    • @craigutley862
      @craigutley862 Před 5 lety

      Thanks, Rymn. I appreciate the support you showed years ago. My career took a turn into management, so I don't get into the technology as much as it used to. I enjoyed doing these videos and am happy to see they are still helping people.

  • @vvs369
    @vvs369 Před 5 lety

    The best! Thx!

  • @MtSaEt
    @MtSaEt Před 5 lety

    Very helpful thank you

  • @deepkaur4219
    @deepkaur4219 Před 6 lety

    How do you get the drill through actions work on the grand total cells. I just noticed my cube shows drill through action menu on individual cells, but not on the grand total cells.

  • @xuzhang2748
    @xuzhang2748 Před 6 lety

    Creating dimension using BIDS 2008 starts at 14:11.

  • @thomasanderson4381
    @thomasanderson4381 Před 6 lety

    @ ~9 min: "With SQL 2008 you'll be able to..." How about telling us when this was actually recorded?

  • @hebagenady797
    @hebagenady797 Před 6 lety

    Excellent Vedio

  • @fionamehta7381
    @fionamehta7381 Před 6 lety

    Really excellent, great delivery, thank you so much for taking the time to post these, MDX becoming clear.

  • @rajk5032
    @rajk5032 Před 6 lety

    Hi Craig, when do we need to have multiple fact tables? and can you explain how fact table will have aggregations with some examples?

  • @SHAFIEEE9359
    @SHAFIEEE9359 Před 6 lety

    who is the original owner of these videos please tell

    • @crunge
      @crunge Před 6 lety

      Shafi, I am the owner. My name is listed as the publisher and my name is also mentioned in each video.

  • @DoctorDatah
    @DoctorDatah Před 6 lety

    38:20 2008 2nd demo