background preloader

Chris Webb's BI Blog

Related:  Blog BI

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". [edit] Getting Started / Tutorials [edit] Proactive Caching [edit] Cache Warming [edit] Killing SSAS Sessions [edit] Microsoft SQL Server Community Code Samples [edit] XMLA script [edit] PowerShell [edit] Processing [edit] .Net stored procedure [edit] Partitions [edit] Write Back [edit] Aggregations [edit] [edit] DMV (Dynamic Management View) [edit] Actions [edit] Analysis Management Objects (AMO) [edit] Captions of calculated members [edit] Displaying OLAP Data [edit] Deployment [edit] Backup and Restore [edit] Detach and Attach Database [edit] Connection String to SSAS [edit] Connecting from SSAS to Oracle, Excel [edit] Connecting from SSAS to Teradata [edit] Sorting dimensional members [edit] Connecting to SSAS from: SSIS, T-SQL, Java, Informatica [edit] HTTP Access [edit] Measure Formatting [edit] Conditional formatting [edit] 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.