Hitachi Vantara Pentaho Community Forums
Results 1 to 9 of 9

Thread: [Mondrian] How to identify selected Dimensions and how to definedifferent aggregation function for different Dimensions ?

  1. #1
    El Mehdi LAHLOU Guest

    Default [Mondrian] How to identify selected Dimensions and how to definedifferent aggregation function for different Dimensions ?

    hi,
    to identify selected Dimensions i tried this :

    WITH MEMBER [MEASURES].[AXISDEMO] AS

    SETTOSTR(AXIS(1))

    SELECT [MEASURES].[AXISDEMO] ON COLUMN,

    [STORE].[ALL STOREs] ON ROWS

    FROM [SALES]



    but i got this error message:

    Syntax error at[3:15,3:17], token 'AXIS'

    can someone help me and suggest me a good way to identify the selected
    Dimensions .


    An other question :I would to declare a measure which use a different
    aggregation function for some dimensions.

    I try to better explain my situation.

    I have a measure stock_level and dimensions (product, customer and time)
    the aggregation functions according to each Dimension , are:

    product = PK
    customer= sum(PK)
    time = avg(sum(PK))

    what is the right way to declare in a Mondrian scheme a situation as this?

    thanks

    Mehdinux

    _______________________________________________
    Mondrian mailing list
    Mondrian (AT) pentaho (DOT) org
    http://lists.pentaho.org/mailman/listinfo/mondrian

  2. #2
    VanIngen, Erik (FIPS) Guest

    Default [Mondrian] ClassCastException RolapMemberBase cannot be cast toRolapCubeMember

    Dear Mondrian,

    This mdx
    SELECT NON EMPTY [Time].[Month].Members ON COLUMNS, NON EMPTY [Store].[Store Name].Members ON ROWS FROM [Sales]
    over Olap4j Xmla gives this error
    Caused by: java.lang.ClassCastException: mondrian.rolap.RolapMemberBase cannot be cast to mondrian.rolap.RolapCubeMember

    Configuration is Olap4j version: 1.0.0.445, Mondrian: mondrian-3.2.1.13885-embedded, Db: Postgres.

    What could be the solution for this error?

    Regards,
    Erik

    _______________________________________________
    Mondrian mailing list
    Mondrian (AT) pentaho (DOT) org
    http://lists.pentaho.org/mailman/listinfo/mondrian

  3. #3
    Paul Stoellberger Guest

    Default Re: [Mondrian] ClassCastException RolapMemberBase cannot be cast toRolapCubeMember

    I think that there are some problems when the Members of a Level are selected. So its probably related.

    Occasionally I see something like this as well (olap4j trunk + mondrian trunk):

    Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [select NON EMPTY {Hierarchize({[Department].[(All)].Members})} ON COLUMNS,
    NON EMPTY Crossjoin([Employees].[(All)].Members, {[Measures].[Employee Salary]}) ON ROWS
    from [HR]
    ......
    Caused by: java.lang.ClassCastException: mondrian.mdx.ResolvedFunCall cannot be cast to mondrian.mdx.MemberExpr
    at mondrian.rolap.sql.CrossJoinArgFactory.addConstrainingMembersToMap(CrossJoinArgFactory.java:222)
    at mondrian.rolap.sql.CrossJoinArgFactory.checkConstrainedMeasures(CrossJoinArgFactory.java:157)





    On May 12, 2011, at 9:17 , VanIngen, Erik (FIPS) wrote:

    > Dear Mondrian,
    >
    > This mdx
    > SELECT NON EMPTY [Time].[Month].Members ON COLUMNS, NON EMPTY [Store].[Store Name].Members ON ROWS FROM [Sales]
    > over Olap4j Xmla gives this error
    > Caused by: java.lang.ClassCastException: mondrian.rolap.RolapMemberBase cannot be cast to mondrian.rolap.RolapCubeMember
    >
    > Configuration is Olap4j version: 1.0.0.445, Mondrian: mondrian-3.2.1.13885-embedded, Db: Postgres.
    >
    > What could be the solution for this error?
    >
    > Regards,
    > Erik
    > _______________________________________________
    > Mondrian mailing list
    > Mondrian (AT) pentaho (DOT) org
    > http://lists.pentaho.org/mailman/listinfo/mondrian



    _______________________________________________
    Mondrian mailing list
    Mondrian (AT) pentaho (DOT) org
    http://lists.pentaho.org/mailman/listinfo/mondrian

  4. #4
    VanIngen, Erik (FIPS) Guest

    Default RE: [Mondrian] ClassCastException RolapMemberBase cannot be cast toRolapCubeMember

    Thanks for thinking along with me. My guess is that is a bug in the Mondrian XML/A Servlet and that is it related to the use of Members. However with other clients I am not able to reproduce the problem. This could suggest that the problem relies in the Olap4j driver for XML/A.

    The problem remains. What could be the solution for this error?






    From: mondrian-bounces (AT) pentaho (DOT) org [mailto:mondrian-bounces (AT) pentaho (DOT) org] On Behalf Of Paul Stoellberger
    Sent: 12 May 2011 10:35
    To: Mondrian developer mailing list
    Subject: Re: [Mondrian] ClassCastException RolapMemberBase cannot be cast to RolapCubeMember

    I think that there are some problems when the Members of a Level are selected. So its probably related.

    Occasionally I see something like this as well (olap4j trunk + mondrian trunk):

    Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [select NON EMPTY {Hierarchize({[Department].[(All)].Members})} ON COLUMNS,
    NON EMPTY Crossjoin([Employees].[(All)].Members, {[Measures].[Employee Salary]}) ON ROWS
    from [HR]
    ......
    Caused by: java.lang.ClassCastException: mondrian.mdx.ResolvedFunCall cannot be cast to mondrian.mdx.MemberExpr
    at mondrian.rolap.sql.CrossJoinArgFactory.addConstrainingMembersToMap(CrossJoinArgFactory.java:222)
    at mondrian.rolap.sql.CrossJoinArgFactory.checkConstrainedMeasures(CrossJoinArgFactory.java:157)





    On May 12, 2011, at 9:17 , VanIngen, Erik (FIPS) wrote:


    Dear Mondrian,

    This mdx
    SELECT NON EMPTY [Time].[Month].Members ON COLUMNS, NON EMPTY [Store].[Store Name].Members ON ROWS FROM [Sales]
    over Olap4j Xmla gives this error
    Caused by: java.lang.ClassCastException: mondrian.rolap.RolapMemberBase cannot be cast to mondrian.rolap.RolapCubeMember

    Configuration is Olap4j version: 1.0.0.445, Mondrian: mondrian-3.2.1.13885-embedded, Db: Postgres.

    What could be the solution for this error?

    Regards,
    Erik
    _______________________________________________
    Mondrian mailing list
    Mondrian (AT) pentaho (DOT) org<mail...taho (DOT) org>
    http://lists.pentaho.org/mailman/listinfo/mondrian


    _______________________________________________
    Mondrian mailing list
    Mondrian (AT) pentaho (DOT) org
    http://lists.pentaho.org/mailman/listinfo/mondrian

  5. #5
    Paul Stoellberger Guest

    Default Re: [Mondrian] ClassCastException RolapMemberBase cannot be cast toRolapCubeMember

    ah, i forgot to mention that i am using olap4j on mondrian directly. i got a feeling this is a combination of hierarchize and possibly the (all) level

    -paul



    Am 12.05.2011 um 12:37 schrieb "VanIngen, Erik (FIPS)" <Erik.VanIngen (AT) fao (DOT) org>:

    > Thanks for thinking along with me. My guess is that is a bug in the Mondrian XML/A Servlet and that is it related to the use of Members. However with other clients I am not able to reproduce the problem. This could suggest that the problem relies in the Olap4j driver for XML/A.
    >
    >
    >
    > The problem remains. What could be the solution for this error?
    >
    >
    >
    >
    >
    >
    >
    >
    >
    >
    >
    >
    >
    > From: mondrian-bounces (AT) pentaho (DOT) org [mailto:mondrian-bounces (AT) pentaho (DOT) org] On Behalf Of Paul Stoellberger
    > Sent: 12 May 2011 10:35
    > To: Mondrian developer mailing list
    > Subject: Re: [Mondrian] ClassCastException RolapMemberBase cannot be cast to RolapCubeMember
    >
    >
    >
    > I think that there are some problems when the Members of a Level are selected. So its probably related.
    >
    >
    >
    > Occasionally I see something like this as well (olap4j trunk + mondrian trunk):
    >
    >
    >
    > Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [select NON EMPTY {Hierarchize({[Department].[(All)].Members})} ON COLUMNS,
    >
    > NON EMPTY Crossjoin([Employees].[(All)].Members, {[Measures].[Employee Salary]}) ON ROWS
    >
    > from [HR]
    >
    > .....
    >
    > Caused by: java.lang.ClassCastException: mondrian.mdx.ResolvedFunCall cannot be cast to mondrian.mdx.MemberExpr
    >
    > at mondrian.rolap.sql.CrossJoinArgFactory.addConstrainingMembersToMap(CrossJoinArgFactory.java:222)
    >
    > at mondrian.rolap.sql.CrossJoinArgFactory.checkConstrainedMeasures(CrossJoinArgFactory.java:157)
    >
    >
    >
    >
    >
    >
    >
    >
    >
    >
    >
    > On May 12, 2011, at 9:17 , VanIngen, Erik (FIPS) wrote:
    >
    >
    >
    >
    > Dear Mondrian,
    >
    >
    >
    > This mdx
    >
    > SELECT NON EMPTY [Time].[Month].Members ON COLUMNS, NON EMPTY [Store].[Store Name].Members ON ROWS FROM [Sales]
    >
    > over Olap4j Xmla gives this error
    >
    > Caused by: java.lang.ClassCastException: mondrian.rolap.RolapMemberBase cannot be cast to mondrian.rolap.RolapCubeMember
    >
    >
    >
    > Configuration is Olap4j version: 1.0.0.445, Mondrian: mondrian-3.2.1.13885-embedded, Db: Postgres.
    >
    >
    >
    > What could be the solution for this error?
    >
    >
    >
    > Regards,
    > Erik
    >
    > _______________________________________________
    > Mondrian mailing list
    > Mondrian (AT) pentaho (DOT) org
    > http://lists.pentaho.org/mailman/listinfo/mondrian
    >
    >
    >
    > _______________________________________________
    > Mondrian mailing list
    > Mondrian (AT) pentaho (DOT) org
    > http://lists.pentaho.org/mailman/listinfo/mondrian


    _______________________________________________
    Mondrian mailing list
    Mondrian (AT) pentaho (DOT) org
    http://lists.pentaho.org/mailman/listinfo/mondrian

  6. #6
    Julian Hyde Guest

    Default RE: [Mondrian] ClassCastException RolapMemberBase cannot be casttoRolapCubeMember

    Seems to be a duplicate of one of the bug mentioned by Paul S. in April:

    <http://lists.pentaho.org/pipermail/mondrian/2011-April/003211.html>
    http://lists.pentaho.org/pipermail/m...il/003211.html

    I don't know if there is a workaround. It needs to be fixed.

    Paul,

    Can you log the bugs please. (Sorry I didn't reply to your email at the
    time.)

    Julian


    _____

    From: mondrian-bounces (AT) pentaho (DOT) org [mailto:mondrian-bounces (AT) pentaho (DOT) org] On
    Behalf Of VanIngen, Erik (FIPS)
    Sent: Thursday, May 12, 2011 4:37 AM
    To: Mondrian developer mailing list
    Subject: RE: [Mondrian] ClassCastException RolapMemberBase cannot be cast
    toRolapCubeMember



    Thanks for thinking along with me. My guess is that is a bug in the Mondrian
    XML/A Servlet and that is it related to the use of Members. However with
    other clients I am not able to reproduce the problem. This could suggest
    that the problem relies in the Olap4j driver for XML/A.



    The problem remains. What could be the solution for this error?













    From: mondrian-bounces (AT) pentaho (DOT) org [mailto:mondrian-bounces (AT) pentaho (DOT) org] On
    Behalf Of Paul Stoellberger
    Sent: 12 May 2011 10:35
    To: Mondrian developer mailing list
    Subject: Re: [Mondrian] ClassCastException RolapMemberBase cannot be cast to
    RolapCubeMember



    I think that there are some problems when the Members of a Level are
    selected. So its probably related.



    Occasionally I see something like this as well (olap4j trunk + mondrian
    trunk):



    Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error:
    Error while executing query [select NON EMPTY
    {Hierarchize({[Department].[(All)].Members})} ON COLUMNS,

    NON EMPTY Crossjoin([Employees].[(All)].Members, {[Measures].[Employee
    Salary]}) ON ROWS

    from [HR]

    ......

    Caused by: java.lang.ClassCastException: mondrian.mdx.ResolvedFunCall cannot
    be cast to mondrian.mdx.MemberExpr

    at
    mondrian.rolap.sql.CrossJoinArgFactory.addConstrainingMembersToMap(CrossJoin
    ArgFactory.java:222)

    at
    mondrian.rolap.sql.CrossJoinArgFactory.checkConstrainedMeasures(CrossJoinArg
    Factory.java:157)











    On May 12, 2011, at 9:17 , VanIngen, Erik (FIPS) wrote:





    Dear Mondrian,



    This mdx

    SELECT NON EMPTY [Time].[Month].Members ON COLUMNS, NON EMPTY [Store].[Store
    Name].Members ON ROWS FROM [Sales]

    over Olap4j Xmla gives this error

    Caused by: java.lang.ClassCastException: mondrian.rolap.RolapMemberBase
    cannot be cast to mondrian.rolap.RolapCubeMember



    Configuration is Olap4j version: 1.0.0.445, Mondrian:
    mondrian-3.2.1.13885-embedded, Db: Postgres.



    What could be the solution for this error?



    Regards,
    Erik

    _______________________________________________
    Mondrian mailing list
    Mondrian (AT) pentaho (DOT) org
    http://lists.pentaho.org/mailman/listinfo/mondrian




    _______________________________________________
    Mondrian mailing list
    Mondrian (AT) pentaho (DOT) org
    http://lists.pentaho.org/mailman/listinfo/mondrian

  7. #7
    Paul Stoellberger Guest

    Default Re: [Mondrian] ClassCastException RolapMemberBase cannot be casttoRolapCubeMember

    I just found the source of my problem.
    It only shows up in combination with Measures.Employee Salary for me.

    A closer look to FoodMart.xml:
    <CalculatedMember name="Employee Salary" dimension="Measures"
    formatString="Currency"
    formula="([Employees].currentmember.datamember, [Measures].[Org Salary])"/>


    Julian, is that formula still valid? (The same foodmart is in the mondrian perforce)
    If yes, then it wouldn't be a bug...

    I tried to reproduce Erik's issue but I dont have the time to setup foodmart xmla .. and it works fine on MondrianOlap4j

    Filed a bug for the other issue in my former mail: http://jira.pentaho.com/browse/MONDRIAN-941

    -Paul

    On May 12, 2011, at 16:43 , Julian Hyde wrote:

    > Seems to be a duplicate of one of the bug mentioned by Paul S. in April:
    >
    > http://lists.pentaho.org/pipermail/m...il/003211.html
    >
    > I don't know if there is a workaround. It needs to be fixed.
    >
    > Paul,
    >
    > Can you log the bugs please. (Sorry I didn't reply to your email at the time.)
    >
    > Julian
    >
    > From: mondrian-bounces (AT) pentaho (DOT) org [mailto:mondrian-bounces (AT) pentaho (DOT) org] On Behalf Of VanIngen, Erik (FIPS)
    > Sent: Thursday, May 12, 2011 4:37 AM
    > To: Mondrian developer mailing list
    > Subject: RE: [Mondrian] ClassCastException RolapMemberBase cannot be cast toRolapCubeMember
    >
    > Thanks for thinking along with me. My guess is that is a bug in the Mondrian XML/A Servlet and that is it related to the use of Members. However with other clients I am not able to reproduce the problem. This could suggest that the problem relies in the Olap4j driver for XML/A.
    >
    > The problem remains. What could be the solution for this error?
    >
    >
    >
    >
    >
    >
    > From: mondrian-bounces (AT) pentaho (DOT) org [mailto:mondrian-bounces (AT) pentaho (DOT) org] On Behalf Of Paul Stoellberger
    > Sent: 12 May 2011 10:35
    > To: Mondrian developer mailing list
    > Subject: Re: [Mondrian] ClassCastException RolapMemberBase cannot be cast to RolapCubeMember
    >
    > I think that there are some problems when the Members of a Level are selected. So its probably related.
    >
    > Occasionally I see something like this as well (olap4j trunk + mondrian trunk):
    >
    > Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [select NON EMPTY {Hierarchize({[Department].[(All)].Members})} ON COLUMNS,
    > NON EMPTY Crossjoin([Employees].[(All)].Members, {[Measures].[Employee Salary]}) ON ROWS
    > from [HR]
    > .....
    > Caused by: java.lang.ClassCastException: mondrian.mdx.ResolvedFunCall cannot be cast to mondrian.mdx.MemberExpr
    > at mondrian.rolap.sql.CrossJoinArgFactory.addConstrainingMembersToMap(CrossJoinArgFactory.java:222)
    > at mondrian.rolap.sql.CrossJoinArgFactory.checkConstrainedMeasures(CrossJoinArgFactory.java:157)
    >
    >
    >
    >
    >
    > On May 12, 2011, at 9:17 , VanIngen, Erik (FIPS) wrote:
    >
    >
    > Dear Mondrian,
    >
    > This mdx
    > SELECT NON EMPTY [Time].[Month].Members ON COLUMNS, NON EMPTY [Store].[Store Name].Members ON ROWS FROM [Sales]
    > over Olap4j Xmla gives this error
    > Caused by: java.lang.ClassCastException: mondrian.rolap.RolapMemberBase cannot be cast to mondrian.rolap.RolapCubeMember
    >
    > Configuration is Olap4j version: 1.0.0.445, Mondrian: mondrian-3.2.1.13885-embedded, Db: Postgres.
    >
    > What could be the solution for this error?
    >
    > Regards,
    > Erik
    > _______________________________________________
    > Mondrian mailing list
    > Mondrian (AT) pentaho (DOT) org
    > http://lists.pentaho.org/mailman/listinfo/mondrian
    >
    > _______________________________________________
    > Mondrian mailing list
    > Mondrian (AT) pentaho (DOT) org
    > http://lists.pentaho.org/mailman/listinfo/mondrian



    _______________________________________________
    Mondrian mailing list
    Mondrian (AT) pentaho (DOT) org
    http://lists.pentaho.org/mailman/listinfo/mondrian

  8. #8
    Julian Hyde Guest

    Default RE: [Mondrian] ClassCastException RolapMemberBase cannot becasttoRolapCubeMember

    The formula is valid. In any case, even if it is invalid, we should never
    throw a ClassCastException, NullPointerException,
    ArrayIndexOutOfBoundsException or similar Java runtime error. If we throw
    one of those it is always a bug.


    _____

    From: mondrian-bounces (AT) pentaho (DOT) org [mailto:mondrian-bounces (AT) pentaho (DOT) org] On
    Behalf Of Paul Stoellberger
    Sent: Thursday, May 12, 2011 6:19 PM
    To: Mondrian developer mailing list
    Subject: Re: [Mondrian] ClassCastException RolapMemberBase cannot be
    casttoRolapCubeMember


    I just found the source of my problem.
    It only shows up in combination with Measures.Employee Salary for me.

    A closer look to FoodMart.xml:
    <CalculatedMember name="Employee Salary" dimension="Measures"
    formatString="Currency"
    formula="([Employees].currentmember.datamember, [Measures].[Org
    Salary])"/>




    Julian, is that formula still valid? (The same foodmart is in the mondrian
    perforce)
    If yes, then it wouldn't be a bug...


    I tried to reproduce Erik's issue but I dont have the time to setup foodmart
    xmla .. and it works fine on MondrianOlap4j


    Filed a bug for the other issue in my former mail:
    http://jira.pentaho.com/browse/MONDRIAN-941


    -Paul


    On May 12, 2011, at 16:43 , Julian Hyde wrote:


    Seems to be a duplicate of one of the bug mentioned by Paul S. in April:

    <http://lists.pentaho.org/pipermail/mondrian/2011-April/003211.html>
    http://lists.pentaho.org/pipermail/m...il/003211.html

    I don't know if there is a workaround. It needs to be fixed.

    Paul,

    Can you log the bugs please. (Sorry I didn't reply to your email at the
    time.)

    Julian


    _____

    From: mondrian-bounces (AT) pentaho (DOT) org [mailto:mondrian-bounces (AT) pentaho (DOT) org] On
    Behalf Of VanIngen, Erik (FIPS)
    Sent: Thursday, May 12, 2011 4:37 AM
    To: Mondrian developer mailing list
    Subject: RE: [Mondrian] ClassCastException RolapMemberBase cannot be cast
    toRolapCubeMember


    Thanks for thinking along with me. My guess is that is a bug in the Mondrian
    XML/A Servlet and that is it related to the use of Members. However with
    other clients I am not able to reproduce the problem. This could suggest
    that the problem relies in the Olap4j driver for XML/A.

    The problem remains. What could be the solution for this error?






    From: mondrian-bounces (AT) pentaho (DOT) org [mailto:mondrian-bounces (AT) pentaho (DOT) org] On
    Behalf Of Paul Stoellberger
    Sent: 12 May 2011 10:35
    To: Mondrian developer mailing list
    Subject: Re: [Mondrian] ClassCastException RolapMemberBase cannot be cast to
    RolapCubeMember
    I think that there are some problems when the Members of a Level are
    selected. So its probably related.
    Occasionally I see something like this as well (olap4j trunk + mondrian
    trunk):
    Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error:
    Error while executing query [select NON EMPTY
    {Hierarchize({[Department].[(All)].Members})} ON COLUMNS,
    NON EMPTY Crossjoin([Employees].[(All)].Members, {[Measures].[Employee
    Salary]}) ON ROWS
    from [HR]
    ......
    Caused by: java.lang.ClassCastException: mondrian.mdx.ResolvedFunCall cannot
    be cast to mondrian.mdx.MemberExpr
    at
    mondrian.rolap.sql.CrossJoinArgFactory.addConstrainingMembersToMap(CrossJoin
    ArgFactory.java:222)
    at
    mondrian.rolap.sql.CrossJoinArgFactory.checkConstrainedMeasures(CrossJoinArg
    Factory.java:157)
    On May 12, 2011, at 9:17 , VanIngen, Erik (FIPS) wrote:


    Dear Mondrian,

    This mdx
    SELECT NON EMPTY [Time].[Month].Members ON COLUMNS, NON EMPTY [Store].[Store
    Name].Members ON ROWS FROM [Sales]
    over Olap4j Xmla gives this error
    Caused by: java.lang.ClassCastException: mondrian.rolap.RolapMemberBase
    cannot be cast to mondrian.rolap.RolapCubeMember

    Configuration is Olap4j version: 1.0.0.445, Mondrian:
    mondrian-3.2.1.13885-embedded, Db: Postgres.

    What could be the solution for this error?

    Regards,
    Erik
    _______________________________________________
    Mondrian mailing list
    Mondrian (AT) pentaho (DOT) org
    http://lists.pentaho.org/mailman/listinfo/mondrian

    _______________________________________________
    Mondrian mailing list
    Mondrian (AT) pentaho (DOT) org
    http://lists.pentaho.org/mailman/listinfo/mondrian




    _______________________________________________
    Mondrian mailing list
    Mondrian (AT) pentaho (DOT) org
    http://lists.pentaho.org/mailman/listinfo/mondrian

  9. #9
    Julian Hyde Guest

    Default RE: [Mondrian] How to identify selected Dimensions and how todefinedifferent aggregation function for different Dimensions ?

    The AXIS(n) function is a standard MDX function but Mondrian does not
    implement it.

    (Mondrian implements the syntax 'SELECT [Measures] ON AXIS(0) ... FROM
    [Sales]' -- that is, 'AXIS(0) as a synonym for '0' or 'COLUMNS' but that is
    a different thing.)

    Can you please log a jira case to request this feature:
    <http://jira.pentaho.com/browse/MONDRIAN>
    http://jira.pentaho.com/browse/MONDRIAN.

    Julian


    _____

    From: mondrian-bounces (AT) pentaho (DOT) org [mailto:mondrian-bounces (AT) pentaho (DOT) org] On
    Behalf Of El Mehdi LAHLOU
    Sent: Thursday, May 12, 2011 1:06 AM
    To: Mondrian developer mailing list
    Subject: [Mondrian] How to identify selected Dimensions and how to
    definedifferent aggregation function for different Dimensions ?



    hi,
    to identify selected Dimensions i tried this :
    WITH MEMBER [MEASURES].[AXISDEMO] AS

    SETTOSTR(AXIS(1))

    SELECT [MEASURES].[AXISDEMO] ON COLUMN,

    [STORE].[ALL STOREs] ON ROWS

    FROM [SALES]



    but i got this error message:

    Syntax error at[3:15,3:17], token 'AXIS'

    can someone help me and suggest me a good way to identify the selected
    Dimensions .






    An other question :I would to declare a measure which use a different
    aggregation function for some dimensions.

    I try to better explain my situation.

    I have a measure stock_level and dimensions (product, customer and time)
    the aggregation functions according to each Dimension , are:

    product = PK
    customer= sum(PK)
    time = avg(sum(PK))

    what is the right way to declare in a Mondrian scheme a situation as this?

    thanks

    Mehdinux





    _______________________________________________
    Mondrian mailing list
    Mondrian (AT) pentaho (DOT) org
    http://lists.pentaho.org/mailman/listinfo/mondrian

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.