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 -...
2 comments

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...

Discovering your MetaData

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,...

Creating a Report Model based on an Analysis Cube

Wednesday, November 21, 2007

Well I guess congratulations are in order because I finally got around to using a report builder in my project. Turns out that building a report model based on a cube is as easy as 1-2-3. Still I had a problem, as for some unknown reason the translations were showing for my dimension names and my measures, but not for the dimension's attributes... At first I thought maybe this is a problem solved by Service Pack 2 (as my tests were done on a Server with Service Pack 1). Alas, no. So, a further look in the MSDN library,...

The Parent – Child Dimension

Tuesday, October 9, 2007

A Parent - Child Dimension is a special sort of dimension, to be used in case:  You have data even for non – leaf members. For instance, you may have set – up costs allocated for the Category level (the higher level), but profit data for your Product level (the lower level). You have an unbalanced hierarchy. The classic example for this might be the Geographical Hierarchy which at times might look like: Country > State > City, and at other times like Country > City. For an international company trying to track its worldwide business, the hierarchy in the US...