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.
Javier Guillén | Pervasive Business Intelligence Intelligent SQL | Delivering smarter business intelligence solutions Ryan Adams SQL Blog La BI et les outils Microsoft 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 .. SQL Rocks with Sri Sridharan | SQL Rocks – Blog of Sri Sridharan Articles - SSAS-WIKI Articles There are hundreds of free articles on the web about SSAS. Most articles are of very good quality. The goal of this page is to organize them into a single "book".  Getting Started / Tutorials  Proactive Caching  Cache Warming  Killing SSAS Sessions  Microsoft SQL Server Community Code Samples  XMLA script  PowerShell  Processing  .Net stored procedure  Partitions  Write Back  Aggregations   DMV (Dynamic Management View)  Actions  Analysis Management Objects (AMO)  Captions of calculated members  Displaying OLAP Data  Deployment  Backup and Restore  Detach and Attach Database  Connection String to SSAS  Connecting from SSAS to Oracle, Excel  Connecting from SSAS to Teradata  Sorting dimensional members  Connecting to SSAS from: SSIS, T-SQL, Java, Informatica  HTTP Access  Measure Formatting  Conditional formatting  Default Member
Some Random Thoughts: SSRS I was going through some of my old documents and found this article on map reports which I had written for a SSRS book (which didn’t go through because of some time related issues). I thought it might be useful to those who are looking to explore map reports in SSRS. So here it goes:- Map reports have been a part of SQL Server Reporting Services from SSRS 2008 R2. However, they are usually a grey box for developers and hence, not been used to their full potential in most of the organizations. This chapter will introduce you to the basic concepts involved in map reports and then take you through some of the common scenarios involved while building map reports. Basic Concepts 1) Geometry and Geography: These are the two spatial data types that are available in SQL Server 2008 and above. 2) Source for Map Reports: SSRS 2008 R2 and above allows two main map sources – ESRI Shapefiles and SQL spatial. Prerequisites 1. 2. 3. 4. Initial Setup 1. 2. 3. I) Creating Map Reports from Shapefiles 1. 2.