PowerPivot and Parent/Child hierarchies

Posted by AlbertoFerrari on SQL Blog See other posts from SQL Blog or by AlbertoFerrari
Published on Tue, 15 Feb 2011 07:00:00 GMT Indexed on 2011/02/15 7:30 UTC
Read the original article Hit count: 547

Filed under:

cte

|

Dimensional Model

|

Parent/Child

|

PowerPivot

Does PowerPivot handle Parent/Child hierarchies? The common answer is “no”, since it does not handle them natively. During last PowerPivot course in London, I have been asked the same question once more and had an interesting discussion about this severe limitation of the PowerPivot data modeling and visualization capabilities. On my way back in Italy, I started thinking at a possible solution and, after some work, I managed to make PowerPivot handle Parent/Child hierarchies in a very nice way, which...(read more)

© SQL Blog or respective owner

Related posts about cte

SQL SERVER – CTE can be Updated

as seen on SQL Authority - Search for 'SQL Authority'
Today I have received a fantastic email from Matthew Spieth. SQL Server expert from Ohio. He recently had a great conversation with his colleagues in the office and wanted to make sure that everybody who reads this blog knows about this little feature which is commonly confused. Here is his statement… >>> More
Prevent recursive CTE visiting nodes multiple times

as seen on Stack Overflow - Search for 'Stack Overflow'
Consider the following simple DAG: 1->2->3->4 And a table, #bar, describing this (I'm using SQL Server 2005): parent_id child_id 1 2 2 3 3 4 //... other edges, not connected to the subgraph above Now imagine that I have some other arbitrary criteria… >>> More
SQL Azure and support for CTE syntax?

as seen on Stack Overflow - Search for 'Stack Overflow'
Does anyone know if SQL Azure supports CTE syntax? Specifically; WITH, OVER, ROW_NUMBER(), PARTITION BY >>> More
Recursive CTE Problem

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I am trying to use a recursive CTE in SQL Server to build up a predicate formula from a table containing the underlying tree structure. For example, my table looks like: -------------------------- Id Operator/Val ParentId -------------------------- 1. 'OR' NULL 2. 'AND' 1 3. 'AND' 1 4. ''… >>> More
SQL Server 2008 ContainsTable, CTE, and Paging

as seen on Stack Overflow - Search for 'Stack Overflow'
I'd like to perform efficient paging using containstable. The following query selects the top 10 ranked results from my database using containstable when searching for a name (first or last) that begins with "Joh". DECLARE @Limit int; SET @Limit = 10; SELECT TOP @Limit c.ChildID, c.PersonID… >>> More

Related posts about Dimensional Model

Design Book–Dimensional or No Dimensional, that is..the question

as seen on SQL Blog - Search for 'SQL Blog'
So, it is right there in the title of the book “Relational Database Design” etc (the title is kinda long :) But as I consider what to cover and, conversely, what not to cover, dimensional design inevitably pops up. So I am considering including it in the book. One thing I try to do is to cover… >>> More
Why model => model.Reason_ID turns to model =>Convert(model.Reason_ID)

as seen on Stack Overflow - Search for 'Stack Overflow'
I have my own html helper extension, wich I use this way <%=Html.LocalizableLabelFor(model => model.Reason_ID, Register.PurchaseReason) %> which declared like this. public static MvcHtmlString LocalizableLabelFor<T>(this HtmlHelper<T> helper, Expression<Func<T, object>>… >>> More
AngularJS on top of ASP.NET: Moving the MVC framework out to the browser

as seen on Simple Talk - Search for 'Simple Talk'
Heavily drawing inspiration from Ruby on Rails, MVC4’s convention over configuration model of development soon became the Holy Grail of .NET web development. The MVC model brought with it the goodness of proper separation of concerns between business logic, data, and the presentation logic. However… >>> More
strange data annotations issue in MVC 2

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, I came across something strange when creating an edit form with MVC 2. i realised that my error messages come up on form sumission even when i have filled ut valid data! i am using a buddy class which i have configured correctly ( i know that cos i can see my custom errors). Here is the code… >>> More
Rails model belongs to model that belongs to model but i want to use another name

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello. This may be a stupid question but im just starting to learn Rail thats why i am asking thsi question. I have one model called "User" which handles all the users in my community. Now i want to add a guestbook to every user. So i created a model called "user_guestbook" and inserted this into… >>> More