[Mondrian] Mondrian 4 - Unsupported properties?

Luc Boudreau lucboudreau at gmail.com
Tue May 26 09:36:40 EDT 2015


I'm not sure that the solution is without consequences. According to the
javadocs of the XmlaExtra interface:

        /**

         * Returns the defined properties of a level. (Not including system

         * properties that every level has.)

         *

         * @param level Level

         * @return Defined properties

         */

        List<Property> getLevelProperties(Level level);


Have you tried similar calls on Microsoft Sql Server Analysis Services? We
shold compare their implementation with ours.

On Tue, May 26, 2015 at 9:18 AM, Ingo Klose <Ingo.Klose at incuda.com> wrote:

> Hello,
>
> Could anybody please shed a light on this issue?
>
> We would like to understand the problem better in order to contribute or
> find a viable workaround.
>
> Many thanks and best regards,
> Ingo
>
> -----Ursprüngliche Nachricht-----
> Von: Ingo Klose
> Gesendet: Donnerstag, 21. Mai 2015 21:02
> An: 'mondrian at pentaho.org'
> Betreff: AW: Mondrian 4 - Unsupported properties?
>
> Hi guys,
>
> we found the line in the source code, that breaks the XMLA call.
>
>
> https://github.com/pentaho/mondrian/blob/4.2/src/main/java/mondrian/olap4j/MondrianOlap4jLevel.java#L98
>
>   public NamedList<Property> getProperties() {
>         return getProperties(true);
>     }
>
> Apparently in Mondrian 3.x  This call was made in a different class and
> passed false instead of true as parameter.
>
>
> https://github.com/pentaho/mondrian/blob/4.3/src/main/java/mondrian/olap4j/MondrianOlap4jExtra.java#L322
>
> public List<org.olap4j.metadata.Property> getLevelProperties(Level level) {
>         MondrianOlap4jLevel olap4jLevel = (MondrianOlap4jLevel) level;
>         return olap4jLevel.getProperties(false);
>     }
>
> We tested changing the parameter to false and the XMLAConnector works like
> a charm.
>
> But now we are wondering, what could we have broken with this change and
> secondly can we either get this change back in the official code or what
> could be a different solution (Mondrian.properties?)
>
> Best regards,
> Ingo
>
> --------------------------------------
> Date: Tue, 12 May 2015 14:25:48 +0000
> From: Ingo Klose <Ingo.Klose at incuda.com>
> Subject: [Mondrian] Mondrian 4 - Unsupported properties?
> To: "mondrian at pentaho.org" <mondrian at pentaho.org>
> Message-ID:
>         <
> VI1PR06MB10232785F57FD4B88C17B6C9FEDA0 at VI1PR06MB1023.eurprd06.prod.outlook.com
> >
>
> Content-Type: text/plain; charset="us-ascii"
>
> Hello all,
>
> We are trying to get the XMLAconnect Excel plugin to work with Mondrian 4.
> Unfortunately the MDX-queries seem to be incompatible to Mondrian 4, due to
> the use of some Member attributes. For example in the foodmart sales cube,
> it creates an MDX like this:
>
> SELECT NON EMPTY
> Hierarchize(AddCalculatedMembers({DrilldownLevel({[Store].[Store Size in
> SQFT].[All Store Size in SQFTs]})})) DIMENSION PROPERTIES
> PARENT_UNIQUE_NAME,[Store].[Store Size in SQFT].[Store
> Sqft].[CATALOG_NAME],[Store].[Store Size in SQFT].[Store
> Sqft].[SCHEMA_NAME],[Store].[Store Size in SQFT].[Store
> Sqft].[CUBE_NAME],[Store].[Store Size in SQFT].[Store
> Sqft].[DIMENSION_UNIQUE_NAME],[Store].[Store Size in SQFT].[Store
> Sqft].[HIERARCHY_UNIQUE_NAME],[Store].[Store Size in SQFT].[Store
> Sqft].[LEVEL_UNIQUE_NAME],[Store].[Store Size in SQFT].[Store
> Sqft].[LEVEL_NUMBER],[Store].[Store Size in SQFT].[Store
> Sqft].[MEMBER_ORDINAL],[Store].[Store Size in SQFT].[Store
> Sqft].[MEMBER_NAME],[Store].[Store Size in SQFT].[Store
> Sqft].[MEMBER_UNIQUE_NAME],[Store].[Store Size in SQFT].[Store
> Sqft].[MEMBER_TYPE],[Store].[Store Size in SQFT].[Store
> Sqft].[MEMBER_GUID],[Store].[Store Size in SQFT].[Store
> Sqft].[MEMBER_CAPTION],[Store].[Store Size in SQFT].[Store
> Sqft].[CHILDREN_CARDINALITY],[Store].[Store Size in SQFT].[Store
> Sqft].[PARENT_LEVEL],[Store].[Store Size in SQFT].[Store
> Sqft].[PARENT_UNIQUE_NAME],[Store].[Store Size in SQFT].[Store
> Sqft].[PARENT_COUNT],[Store].[Store Size in SQFT].[Store
> Sqft].[DESCRIPTION],[Store].[Store Size in SQFT].[Store
> Sqft].[IS_PLACEHOLDERMEMBER],[Store].[Store Size in SQFT].[Store
> Sqft].[IS_DATAMEMBER],[Store].[Store Size in SQFT].[Store
> Sqft].[DISPLAY_INFO],[Store].[Store Size in SQFT].[Store
> Sqft].[VALUE],[Store].[Store Size in SQFT].[Store
> Sqft].[$member_scope],[Store].[Store Size in SQFT].[Store
> Sqft].[$scenario],[Store].[Store Size in SQFT].[Store
> Sqft].[CELL_FORMATTER],[Store].[Store Size in SQFT].[Store
> Sqft].[CELL_FORMATTER_SCRIPT],[Store].[Store Size in SQFT].[Store
> Sqft].[CELL_FORMATTER_SCRIPT_LANGUAGE],[Store].[Store Size in SQFT].[Store
> Sqft].[DISPLAY_FOLDER],[Store].[Store Size in SQFT].[Store
> Sqft].[FORMAT_EXP],[Store].[Store Size in SQFT].[Store Sqft].[KEY] ON
> COLUMNS  FROM [HR] CELL PROPERTIES VALUE, FORMAT_STRING, LANGUAGE,
> BACK_COLOR, FORE_COLOR, FONT_FLAGS
>
> These are the four properties that break the query:
>
> Store].[Store Size in SQFT].[Store Sqft].[IS_PLACEHOLDERMEMBER]
> [Store].[Store Size in SQFT].[Store Sqft].[IS_DATAMEMBER] [Store].[Store
> Size in SQFT].[Store Sqft].[$member_scope] [Store].[Store Size in
> SQFT].[Store Sqft].[$scenario]
>
> According to this commit on git (
> https://github.com/pentaho/mondrian/commit/a2e4d05cac249c397cc08770c2daf110cab4a117)
> at least the first two properties are mentioned in the source code,
> although they are in a "missing properties" list.
>
> Are those properties not supported in Mondrian 4 and is there a way to
> prevent the query from running into an error?
>
> Any hints and pointers would be welcome.
>
> Many thanks,
> Ingo
>
>
>
>
>
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL:
> http://lists.pentaho.org/pipermail/mondrian/attachments/20150512/61439213/attachment-0001.html
>
> ------------------------------
>
> _______________________________________________
> 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/20150526/0e286aad/attachment-0001.html 


More information about the Mondrian mailing list