Groups | Blog | Home
all groups > sql server data warehouse > september 2005 >

sql server data warehouse : How to create such a member on dimension?


Word 2003 memory Leakage
9/30/2005 3:03:01 PM
I have a measure type dimension with 1 - 5 types.

I want to calculate sum of measures with type of 3 and 4. So I will have 6
types. And I want to show sum of measures on column, and 6 types on rows.

how can do this?

Thanks,

Darren Gosbell
10/2/2005 12:00:00 AM
I am not entirely sure I understand your question, but could you create
a parent child or a two level ragged dimension that would look as
follows

type 1
type 2
type 6
- type 3
- type 4
type 5

As you can see, I have set up type 3 & 4 as children of "type 6", by
default this would give type 6 the value of the sum of types 3 & 4.


--
Regards
Darren Gosbell [MCSD]
<dgosbell_at_yahoo_dot_com>
Blog: http://www.geekswithblogs.net/darrengosbell

In article <6D63CF56-F740-4BEC-89DE-AA9DE438A8D2@microsoft.com>,
Word2003memoryLeakage@discussions.microsoft.com says...
[quoted text, click to view]
Word 2003 memory Leakage
10/3/2005 2:59:06 PM
Yeah, my question may not be clear.

But I found the solution:

Just create a member for this two types.

member [Dim_MeasureType].[Hierarchy-Measure-Type].[TotalCO2] as
'sum(
(union([Dim_MeasureType].[Hierarchy-Measure-Type].[MeasureType].&[6],
[Dim_MeasureType].[Hierarchy-Measure-Type].[MeasureType].&[7])
,[Measures].[MeasureValue])
)'


[quoted text, click to view]
AddThis Social Bookmark Button