Alberto Ferrari In my last post about Parent/Child hierarchies, there is a question, in the comments, that I found interesting. Nevertheless, the formula is a complex one and cannot be written in a simple comment. Thus, I am making a follow-up to that post. I am not repeating all the stuff of the previous post so, please, read that before reading this one, to have the necessary background. The question looks a simple one: “If you needed a measure (SumOfLeafAmount) that only shows childrens values, what would it be like?” I was about to answer that “I have a formula that is too large to fit in the margin” but… Fermat did it some years ago and caused a real mess. There two interesting points in this simple question: There are two interpretation of the formula: one is “sum only the leaves”, the other ones is “sum only the children”. Let us start with the set of data we are going to work on. Now, what are the desired results? Let us start with SumOfLeaves, which is pretty easy. Now, the solution.
Kasper de Jonge PowerPivot Blog | Bringing BI to the masses Jen Stirrup's Business Intelligence Blog Javier Guillén | Pervasive Business Intelligence Intelligent SQL | Delivering smarter business intelligence solutions La BI et les outils Microsoft DAX Statistical Functions Following on from his first four articles on using Data Analysis Expressions (DAX) with tabular databases, Robert Sheldon dives into some of the DAX statistical functions available, demonstrating which are the most useful and examples of how they work. The Data Analysis Expressions (DAX) language includes a wide range of functions that help you refine your queries when retrieving data from a SQL Server Analysis Services (SSAS) tabular database. You’ve seen numerous examples of DAX functions throughout this series on the tabular model. One set of functions that are particularly useful when working with tabular data are the statistical functions, which support various ways to aggregate and analyze data. Statistical functions include not only the typical standbys, such as Min and Max, but also those that help structure that data into tables, such as AddColumns and Summarize. To follow along in this article, you should have a basic understanding of how to write a DAX query. The Row Function
untitled In this post, I will go into why there is a “big graph anti-pattern”, the fundamentally different kinds of graph processing, how to match the technology to the problem, and what are some successful patterns for scalable graph processing. The big graph anti-pattern is “Throw everything into a big graph and then using the same tools that gave us horizontal scaling for other problems: map/reduce and key-value stores.” There are several fallacies here. There are some fundamental architectural differences in systems for high performance graph traversal and graph analytics, systems for high performance graph pattern matching, map/reduce platforms and key-value stores. The only way to get scaling and high throughput for graph traversal and graph mining is to get the architecture, the software, and the hardware right. Kinds of graph processing. Gathered reads for property and link set retrieval. Graph traversal. There are a few problems. Graph query. When should you scale-out a graph database?
ExcelVbaIsFun Learn how to wield Excel to the fullest of it's abilities! With my FREE channel, you'll obtain the skills to manipulate data, sheets, userforms, even other programs. New Contest! Enter to win $20 and my new eBook! is my link to my workbooks, past present and future. In order to easily and automatically get the latest files, get a free Dropbox account, click here: For access to my workbooks whether or not you're a Dropbox account user, use this: Grab an ExcelVbaIsFun T-Shirt, Hoodie, Mug or other nerd apparel here: 'Royalty Free Music by
(B)usiness (I)ntelligence Mentalist | Magic of Business Intelligence Architecturing ..