Re: Sum on leaf level condition
- From: "Ohjoo Kwon" <ojkwon@xxxxxxxxxx>
- Date: Fri, 19 Jan 2007 15:22:27 +0900
First, derived measure can be considered.
For this, Source Column in AS 2000 or Named Calculation in AS 2005 can be
used.
For example,
Case When "Pack Quantity" = 10 Then "Sales Quantity" Else NULL End
Second, I think Calculated Cells in AS 2000 or your logic expression using
Scope inside MDX Script will be helpful.
For example of Calculated Cells,
Calculation Subcube: {[Sales Quantity]}, Dim1.LeafLevel.Members,
Dim2.LeafLevel.Members,...
Calculation Condition: [Pack Quantity] <> 10
Calculation Value: NULL
Then, each aggregates for non-leaf levels will be rolluped from leaf level
automatically.
For performance, I recommend the first case.
Ohoo
"davids@xxxxxxxxxxxxxxxx" <davidsthorntonsinccom@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote in message news:BEAD8E34-4B4B-4721-B9DD-069F117E74C9@xxxxxxxxxxxxxxxx
I'm looking for a way to sum [Measures].[Sales Quantity] when the leaf
level
of [Measures].[Pack Quantity] is equal to 10 thanks.
.
- Prev by Date: Re: Adding Hints to the SQL for processing cubes?
- Next by Date: Re: AS 2000 repository on MS SQL 2005 - is it supported?
- Previous by thread: Re: Time Dimension Hiearchy Issue
- Next by thread: Aggregation from lower levels in MDX
- Index(es):
Relevant Pages
|
