![Craig Utley](/img/default-banner.jpg)
- 35
- 532 827
Craig Utley
Registrace 1. 03. 2006
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 106 Basic Deploying, Processing, and Browsing
zhlédnutí 25KPřed 9 lety
SSAS 106 Basic Deploying, Processing, and Browsing
SSAS 102 Creating Projects and Data Sources
zhlédnutí 28KPřed 9 lety
SSAS 102 Creating Projects and Data Sources
666
video de merda n vejam
These are awesome. Thank you.
Thank you very much for your video. Your explanation is very clear.
Hi Craig, do you do consulting ? I would hire you for a few hour consultation
awesome explanation
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
Can you please make a video on the system processes
can you update your ssas videos? a lot has changed since that ssas version.
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.
do you work with ssas?
@@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.
12:33 Parent-Child Relationship
recommend for IT departments starting a data warehouse project
the best tutorial in youtube
Thanks Craig!! This is so helpful.
Thank you!
Looks like this guy has ripped off your work: czcams.com/video/uC5PS16qixk/video.html
Best explanation ever!!! Thank you.
Useless !! you have to show us steps to create actions not the results of actions.
That's what videos 117, 118, and 119 show.
You'd better be grateful than being judgy. He is sharing his knowledge freely
@@craigutley862 thanks sir i didn't realise that
@@ahmadbahrami9437 I would not be grateful for wasting 10 minutes of my time.
Great stuff but how to process only the latest partitions !
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
Amazing...! Can we also perform Reporting actions to Power BI Report?
Thank YOU. Learning enough MDX for Calculated Members in Tableau
Very very helpful. Question: is using join slower than building attribution relationships first? I tried both approaches but join took a long time
I think this is more a Database work than AS work, right ??
Please upload a video how to write also calculate dax query into ssas multidimensional cube.
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.
This is still the *best* explanation I've found on Attribute Relationships. Thanks for finally enabling this make sense to me.
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?
You are a magic man, and you got magic hands!
Thank you, this really helped me a lot!
Very helpful tutorials.
Thank you sir, still relevant in 2019
Really Really Great Explanation, thank you!!!
creat job, thank you
Thank you
Hello, would love to have more tutorials on MDX thank you
Great point. There's a lot of "professionals" out there that fail to get this.
where did you get the XMLA script did you wrote it or it was generated automatically?
Thanks so much for the tutorial! It's very helpful!
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.
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.
The best! Thx!
Very helpful thank you
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.
Creating dimension using BIDS 2008 starts at 14:11.
Thanks!
@ ~9 min: "With SQL 2008 you'll be able to..." How about telling us when this was actually recorded?
Excellent Vedio
Really excellent, great delivery, thank you so much for taking the time to post these, MDX becoming clear.
Hi Craig, when do we need to have multiple fact tables? and can you explain how fact table will have aggregations with some examples?
who is the original owner of these videos please tell
Shafi, I am the owner. My name is listed as the publisher and my name is also mentioned in each video.
38:20 2008 2nd demo