• 0 Votes

How to avoid Leaf-Level calculations

to 1. etc..." Also Mosha goes to great lengths on his blog to explain how to avoid leaf-level aggregations, it's got to be worth ...
| 8 Replies | 8533 Views | Created by AlanKohl - Wednesday, November 1, 2006 4:16 PM | Last reply by AlanKohl - Thursday, November 2, 2006 7:34 AM
• 0 Votes

Leaf level calculations

This calculation needs to be done at the leaf level of the measure group. i.e. for each row of the fact table. With ...
| 11 Replies | 6944 Views | Created by matt01 - Wednesday, January 24, 2007 10:29 PM | Last reply by Darren Gosbell - Thursday, February 8, 2007 6:38 AM
• 0 Votes

Calculated member at leaf level

SUM(A * B)/Sum(A). The problem is when I look at the results it is on aggregated levels. In the calculation window if i gave SUM(A * B)/Sum(A) means it behaves ...
| 4 Replies | 3823 Views | Created by mrkulagam - Thursday, June 25, 2009 9:50 AM | Last reply by mrkulagam - Thursday, June 25, 2009 12:01 PM
• 0 Votes

Leaf level calculation and filtering

- is the min stock qty needed for the current product on current warehouse on current day (int) Productparam2 - is the product level of significance (for ...
| 0 Replies | 2211 Views | Created by Alex V F - Tuesday, May 8, 2012 5:24 AM
• 0 Votes

Scoping Leaf Level Calculations and Aggregation

to make more sense because isn't it just a flag to indicate whether the job is included or excluded from your analysis? Plus, generally MDX calculations at the leaf ...
| 2 Replies | 4523 Views | Created by i.unknown - Monday, March 2, 2009 6:05 PM | Last reply by i.unknown - Tuesday, March 3, 2009 5:04 AM
• 0 Votes

Leaf levels

Hi All,   I want know what are leaf levels and non leaf levels in Analysis Services 2005. How to work with them ...
| 2 Replies | 6080 Views | Created by SekharPC - Tuesday, January 16, 2007 9:08 PM | Last reply by SekharPC - Wednesday, January 17, 2007 7:24 PM
• 0 Votes

How to create a Calculated Maesure at the Leaf level of data.

].[A] *  [Measures].[B]) at the  leaf level of the data i.e each row in the fact table will have its own value and this new calculated measure ...
| 2 Replies | 2283 Views | Created by MVino - Tuesday, February 14, 2012 10:05 PM | Last reply by Elmozamil Elamir - Wednesday, February 15, 2012 5:32 AM
• 0 Votes

performance of summing calculations at descendants leaf level

Hi eb I have a complicated on the fly scenario where summeries must be broken first to leaf level members calculations -  which by ...
| 0 Replies | 855 Views | Created by reapeleg - Sunday, August 25, 2013 6:13 AM
• 0 Votes

Calculation at leaf level before aggregation

Simon, if the "except leaves" set has arbitrary shape, why does it seem to work in the original ...
| 8 Replies | 865 Views | Created by Greg1922 - Wednesday, September 21, 2016 8:34 AM | Last reply by Greg1922 - Friday, September 23, 2016 6:32 AM
• 0 Votes

Troubles with leaf level calculations and multiselect

How would that work? I need the measure to aggregate along the "customer" dimension, but stay at the leaf level for the "stock" ...
| 3 Replies | 2748 Views | Created by cameron_eldridge - Wednesday, July 18, 2012 12:32 AM | Last reply by cameron_eldridge - Thursday, July 19, 2012 11:57 PM
• 0 Votes

Calculated measure only on leaf level

The first measure is used to calculate the measure on its last level of granularity (Sales Quantity YTD 2009 - Sales Quantity YTD 2008) * Avg Price YTD 2008 ...
| 0 Replies | 5929 Views | Created by Miguel Salles - Wednesday, September 9, 2009 7:45 PM
• 0 Votes

Calculated Member auto rollup at non-leaf level?

Hi Sujeev, You have to use sum(Descendants(Product.LeafLevel(Calculation))). For example your product dimension  has Category and ...
| 2 Replies | 4261 Views | Created by Sujeev - Wednesday, July 22, 2009 7:30 AM | Last reply by Sujeev - Wednesday, July 22, 2009 1:45 PM
• 0 Votes

Aggregating at the leaf level

the values at the leaf-level and NOT include the subtotals in the grand total. Do you know how I can do ...
| 1 Replies | 4529 Views | Created by ah701 - Wednesday, January 2, 2008 10:40 AM | Last reply by Bryan C. Smith - Wednesday, January 2, 2008 4:29 PM
• 1 Votes

Leaf level member

Can anyone explain me what is leaf level member and how the unique property goes with it?
| 2 Replies | 5216 Views | Created by SSIS Geek - Tuesday, September 29, 2009 2:42 PM | Last reply by SSIS Geek - Tuesday, September 29, 2009 4:58 PM
• 0 Votes

How to restrict rollup in non-leaf level

rollup values. I will wright a calculated member for the non-leaf level, that calculated value has to sit in that non-leaf level. ...
| 2 Replies | 4378 Views | Created by Sujeev - Tuesday, October 21, 2008 9:25 AM | Last reply by Deepak Puri - Wednesday, October 22, 2008 5:00 PM
• 2 Votes

Measure calculated on "leaf level" and rolled up

Hi I have the following scenario. I want to apply some calculations on different levels and then aggregate them up. First ...
| 2 Replies | 732 Views | Created by Jam281 - Friday, June 19, 2015 12:41 PM | Last reply by Gerhard Brueckl - Saturday, June 20, 2015 11:17 AM
• 0 Votes

Cannot create MDX calculation with one variable in the calculation from a leaf level

One, a calculation, let’s call it  [Dollar Variance], that computes variance at all levels
| 1 Replies | 4850 Views | Created by KenHG - Friday, September 24, 2010 7:24 PM | Last reply by Deepak Puri - Friday, September 24, 2010 11:57 PM
• 0 Votes

drill down to leaf level in cube

Hi How to drill down to leaf level of the cube and get the data ? Is it like that we can go to only one level below and can not get second ...
| 6 Replies | 6129 Views | Created by CPP to Dot Net - Monday, February 22, 2010 3:00 PM | Last reply by maeenul - Tuesday, March 2, 2010 6:18 PM
• 0 Votes

Calculation at leaf node with a writeback value

, with the expectation a value can be written back to the Dim_Area and used for calculation. But getting stuck on this leaf level ...
| 2 Replies | 1885 Views | Created by GGoldspink - Tuesday, August 6, 2013 1:22 AM | Last reply by GGoldspink - Thursday, August 8, 2013 1:48 AM
• 0 Votes

MDX - Leaf level calculation and hierarchy filter => Incorrect aggregation

AggregateFunction property to None. Because of this, I need to use a specific leaf level calculation (see below). Actors are related to a country so I ...
| 0 Replies | 1069 Views | Created by cpassuel - Wednesday, October 30, 2013 2:57 PM
• Items 1 to 20 of 298092 Next ›