[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