[Mondrian] Attribute hierarchies
Julian Hyde
jhyde at pentaho.com
Mon Sep 8 13:13:50 EDT 2008
Not as such. We intend to implement some SSAS features including attribute
hierarchies and auto exists in mondrian 3.1. Date TBD, probably November.
However, I think you can achieve a similar effect today by creating a
single-level hierarchy with the same definition as your attribute. The main
difference is that you'd type [My Day of Week].CurrentMember rather than
[Date].[Day of Week].CurrentMember.
Julian
_____
From: mondrian-bounces at pentaho.org [mailto:mondrian-bounces at pentaho.org] On
Behalf Of Peter Tran
Sent: Monday, September 08, 2008 5:11 AM
To: Mondrian developer mailing list
Subject: [Mondrian] Attribute hierarchies
Hi,
Does Mondrian support attribute hierarchies like Analysis Services?
We have reviewed the Dimension schema configuration and it doesn't appear
that this is possible. We suspect that we'll have to rely on using member
properties to achieve this exact requirement of adjusting some measure by
the number of working days under the given date member.
The MDX that we'd like to be able to use is as follows (where "Day of Week"
is an attribute hierarchy):
WITH
MEMBER
Measures.SalesPerWorkingDay AS
'
IIF(
Count(
Filter(
Descendants(
[Date].[Calendar].CurrentMember
,[Date].[Calendar].[Date]
,SELF)
, [Date].[Day of Week].CurrentMember.Name <> "1"
)
) = 0
,NULL
,[Measures].[Internet Sales Amount]
/
Count(
Filter(
Descendants(
[Date].[Calendar].CurrentMember
,[Date].[Calendar].[Date]
,SELF)
, [Date].[Day of Week].CurrentMember.Name <> "1"
)
)
)
'
SELECT [Measures].[SalesPerWorkingDay] ON 0
, [Date].[Calendar].[Month].MEMBERS ON 1
FROM [Adventure Works]
Thanks,
-Peter
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20080908/42694531/attachment.html
More information about the Mondrian
mailing list