## The Parent Child Dimension – Presentation at the BI User Group

### Monday, June 29, 2009

Here is the presentation I gave on the topic of the Parent Child Dimension at the BI User Group meeting. I tried to summarize most of what I could find on the subject and I hope it helped you learn something new about how this sort of design can aid you in your work.You can download the presentation here: The Parent Child Dimension PDF For more details on future meetings and presentations that were already given, please check Ronen Chenn's blog, Yossi Elkayam and Eran Sagi's blog or the Israeli SQL Server site.It was a pleasure seeing you all and I...
one comment

## The Parent – Child Dimension in the BI User Group #5 Meeting

### Sunday, June 21, 2009

I'm lecturing at the coming BI User Group meeting on Wednesday, June 24th 2009. My lecture will be on the Parent - Child Dimension: the flexibility in design and the cost in cube performance. I'll be going over the basic Parent- Child Dimension and show how we can gradually enhance it. Mostly, I hope you can learn from the lecture how the Parent - Child Dimension may be relevant to your work. The program for the evening is:17:30 - 17:45  Gathering17:45 - 18:45  Ella maschiach - Analysis services ,The Parent - Child Dimension - best practices.18:45 - 19:15  Q&A19:15 -...

## Recursive Sum for a Group in a Matrix in SSRS

### Wednesday, April 22, 2009

Recursive Sum for a Group in a Matrix in SSRSI wrote a post not too long ago about creating Sum for a Group with Recursion in SSRS. A reader of that post dropped me a line as she was having trouble recreating the same behavior in a matrix (the post itself had demonstrations in it only for a table). So I decided to look into how a recursive sum acts in a matrix, and boy what a learning experience that turned out to be...I created a report with a matrix which connected to Adventure Works DW. I defined the...

## A Parent Child Dimension for an Unbalanced Hierarchy

### Monday, August 4, 2008

I found myself revisiting the Parent Child dimension quite unexpectedly. I'm working on a project which involves the division of the city to different statistical areas. The division of the city into these different statistical areas happens once every 10 years or so, according to the changes in population tracked by the municipality itself and the government in the Census of Population and Housing. Up till now, my cube had in it just the statistical areas distribution from one Census onwards and so had just one sort of distribution I needed to connect to in my cube. However, now...

## Updating your Report Model

### Saturday, February 9, 2008

I know I had written of the simplicity and ease of creating a report model based on a cube, but I too would have to admit that even a good thing can be made better. Just in case you hadn't noticed, when you enter the report site you can manage your models. If you can't see the "Models" folder, simply click the "Show details" and you'll see it. Select the folder and click on the name of your model or on the "edit" icon next to it. You now have a chance to "Edit" or "Update" your...

## Visual Totals in MDX and Role Security

### Wednesday, February 6, 2008

Well I thought today we'd go over visual totals in MDX and also see how they may have an impact on how you assign role based security in you SSAS project. Visual Totals in MDX are there to give you just what they describe – a sum on the children in a certain set. Child members which are not in the specified set will be ignored during the calculation. For instance, if I have a set that consists of: USA, New York, Washington and California, when I look at the total for USA, I will only see it's sum...

### Saturday, December 29, 2007

I have recently discovered a brand tool to help me better understand my work. It's a free tool from the Microsoft SDK. Specifically, I'm talking about the Rowset Viewer. The Rowset Viewer was intended for you to "view and manipulate OLE DB rowsets, with the added ability to call and manipulate other OLE DB methods from the data source, session, command, rowset, transaction, and notification objects supported by any OLE DB provider." I found myself using the tool so as to understand what was problematic in my cube. Basically,...