[Mondrian] Intrinsic Member Properties

[Diethard Steiner]

Thanks for your reply. Yes, I had a look there, but my Java knowledge is extremely limited … In any case, looking at the code, I think I’ve got all of the Mondrian intrinsic member properties listed, so question no 6 is resolved. 

I am accessing them via calculated members like this:
MEMBER [Measures].[Name] AS
    --[Date.Weekly Calendar].CurrentMember.Name
    [Date.Weekly Calendar].CurrentMember.Properties("MEMBER_NAME”)

Do you know perhaps the answers to the other questions?


> On 26 Feb 2015, at 14:24, Andy Grohe <agrohe21 at gmail.com> wrote:
> 
> Did you look here?
> https://github.com/pentaho/mondrian/blob/master/testsrc/main/mondrian/test/PropertiesTest.java <https://github.com/pentaho/mondrian/blob/master/testsrc/main/mondrian/test/PropertiesTest.java>
> 
> This should show them all.
> 
> How are you accessing them? MDX Calc Measure?
> 
> On Thu, Feb 26, 2015 at 4:10 AM, Diethard Steiner <diethard.steiner at gmail.com <mailto:diethard.steiner at gmail.com>> wrote:
> Hi,
> 
> I was just playing a bit around with intrinsic member properties and a few questions came up:
> 
> 1) In my case the MEMBER_GUID is not returning anything. What is the exact use case for this?
> 
> 2) MEMBER_ORDINAL returned -1 in my case, however, using CurrentMember.Ordinal returned 2. Why is there a difference?
> 
> 3) CUBE_NAME does not return anything. Same for CATALOG_NAME.
> 
> 4) MEMBER_TYPE does return an integer when I expected something like ‘regular’ or so. Where can I find a mapping for these integers?
> 
> 5) PARENT_COUNT: A more general question: In which case can a member have more than one parent? parent-child hierarchies?
> 
> 6) This is a list of intrinsic member properties that I've found so far. Is there anything missing?
> 
> CATALOG_NAME
> SCHEMA_NAME
> CUBE_NAME
> DIMENSION_UNIQUE_NAME
> HIERARCHY_UNIQUE_NAME
> LEVEL_UNIQUE_NAME
> LEVEL_NUMBER
> MEMBER_UNIQUE_NAME
> MEMBER_NAME
> MEMBER_TYPE
> MEMBER_GUID
> MEMBER_CAPTION
> MEMBER_ORDINAL
> CHILDREN_CARDINALITY
> PARENT_LEVEL
> PARENT_UNIQUE_NAME
> PARENT_COUNT
> DESCRIPTION
> 
> All tested on biserver-ce v5.2.
> 
> Cheers,
> Diethard
> 
> 
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org <mailto:Mondrian at pentaho.org>
> http://lists.pentaho.org/mailman/listinfo/mondrian <http://lists.pentaho.org/mailman/listinfo/mondrian>
> 
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org
> http://lists.pentaho.org/mailman/listinfo/mondrian

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20150226/06b80c8b/attachment.html