Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: [Mondrian] Adding calculated member to non-measure dim not workingas expected

  1. #1
    Andy Grohe Guest

    Default [Mondrian] Adding calculated member to non-measure dim not workingas expected

    I am trying to add a calculated member representing the aggregate of all
    children in a level

    with member [Markets].[Territory].[Andy] as 'Aggregate([Markets].[All
    Markets].Children)'
    select NON EMPTY {[Measures].[Quantity]} ON COLUMNS,
    [Markets].[Territory].Allmembers ON ROWS
    from [SteelWheelsSales]

    If I run that in JPivot, the Andy measure is assigned to a new hierarchy.

    I see

    MeasuresFullQuantity
    #null

    APAC
    12,878
    EMEA
    49,578
    Japan
    4,923
    NA
    37,952


    But I would want to see the Andy member alongside the Children.

    I can only get it to display when specifically called out like so.

    with member [Markets.Full].[Andy] as 'Aggregate([Markets.Full].[All
    Markets].Children)'
    select NON EMPTY {[Measures].[Quantity]} ON COLUMNS,
    {[Markets.Full].[Andy], [Markets].[All Markets].Children} ON ROWS
    from [SteelWheelsSales]

    It also appears that mondrian does not let you add members at other levels
    other than the root level. Is this correct?

    Any ideas or thoughts on getting a calculated member on a lower level?

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

  2. #2
    Pedro Alves Guest

    Default Re: [Mondrian]Adding calculated member to non-measure dim not working as expected

    Afaik your conclusion is correct. + 1 on that feature, would be extremely useful



    -pedro

    Andy Grohe <agrohe21 (AT) gmail (DOT) com> wrote:

    I am trying to add a calculated member representing the aggregate of all children in a level

    with member [Markets].[Territory].[Andy] as 'Aggregate([Markets].[All Markets].Children)'
    select NON EMPTY {[Measures].[Quantity]} ON COLUMNS,
    [Markets].[Territory].Allmembers ON ROWS
    from [SteelWheelsSales]

    If I run that in JPivot, the Andy measure is assigned to a new hierarchy.

    I see

    Measures Full Quantity

    #null



    APAC

    12,878

    EMEA

    49,578

    Japan

    4,923

    NA

    37,952


    But I would want to see the Andy member alongside the Children.

    I can only get it to display when specifically called out like so.

    with member [Markets.Full].[Andy] as 'Aggregate([Markets.Full].[All Markets].Children)'
    select NON EMPTY {[Measures].[Quantity]} ON COLUMNS,
    {[Markets.Full].[Andy], [Markets].[All Markets].Children} ON ROWS
    from [SteelWheelsSales]

    It also appears that mondrian does not let you add members at other levels other than the root level. Is this correct?

    Any ideas or thoughts on getting a calculated member on a lower level?


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

  3. #3
    Ati Rosselet Guest

    Default Re: [Mondrian] Adding calculated member to non-measure dim notworking as expected

    Hi.. at one point I had implemented a "Level" property addition to the
    schema to allow the addition of a calculated member at other than root
    levels (mondrian Jpivot). If you're interested, I can find the code and
    send it to you.. I'm not sure if it is compatible with the current version
    of mondrian, or if it would be an 'accepted' solution, but it worked ..
    which was the important part for me
    Cheers

    On Sat, Oct 22, 2011 at 12:49 PM, Pedro Alves <pmgalves (AT) gmail (DOT) com> wrote:

    > **
    > Afaik your conclusion is correct. + 1 on that feature, would be extremely
    > useful
    >
    >
    >
    > -pedro
    >
    > Andy Grohe <agrohe21 (AT) gmail (DOT) com> wrote:
    >>
    >> I am trying to add a calculated member representing the aggregate of all
    >> children in a level
    >>
    >> with member [Markets].[Territory].[Andy] as 'Aggregate([Markets].[All
    >> Markets].Children)'
    >> select NON EMPTY {[Measures].[Quantity]} ON COLUMNS,
    >> [Markets].[Territory].Allmembers ON ROWS
    >> from [SteelWheelsSales]
    >>
    >> If I run that in JPivot, the Andy measure is assigned to a new hierarchy.
    >>
    >> I see
    >>
    >> MeasuresFull Quantity
    >> #null
    >>
    >> APAC
    >> 12,878
    >> EMEA
    >> 49,578
    >> Japan
    >> 4,923
    >> NA
    >> 37,952
    >>
    >>
    >> But I would want to see the Andy member alongside the Children.
    >>
    >> I can only get it to display when specifically called out like so.
    >>
    >> with member [Markets.Full].[Andy] as 'Aggregate([Markets.Full].[All
    >> Markets].Children)'
    >> select NON EMPTY {[Measures].[Quantity]} ON COLUMNS,
    >> {[Markets.Full].[Andy], [Markets].[All Markets].Children} ON ROWS
    >> from [SteelWheelsSales]
    >>
    >> It also appears that mondrian does not let you add members at other levels
    >> other than the root level. Is this correct?
    >>
    >> Any ideas or thoughts on getting a calculated member on a lower level?
    >>

    >
    > _______________________________________________
    > 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
    Julian Hyde Guest

    Default Re: [Mondrian] Adding calculated member to non-measure dim notworking as expected

    To be clear. This is an issue with JPivot. The feature was implemented in Mondrian (see http://jira.pentaho.com/browse/MONDRIAN-335) and AFAIK works correctly.

    Julian

    On Oct 21, 2011, at 8:55 PM, Andy Grohe wrote:

    > I am trying to add a calculated member representing the aggregate of all children in a level
    >
    > with member [Markets].[Territory].[Andy] as 'Aggregate([Markets].[All Markets].Children)'
    > select NON EMPTY {[Measures].[Quantity]} ON COLUMNS,
    > [Markets].[Territory].Allmembers ON ROWS
    > from [SteelWheelsSales]
    >
    > If I run that in JPivot, the Andy measure is assigned to a new hierarchy.
    >
    > I see
    >
    > Measures
    > Full Quantity
    > #null
    >
    > APAC
    > 12,878
    > EMEA
    > 49,578
    > Japan
    > 4,923
    > NA
    > 37,952
    >
    >
    > But I would want to see the Andy member alongside the Children.
    >
    > I can only get it to display when specifically called out like so.
    >
    > with member [Markets.Full].[Andy] as 'Aggregate([Markets.Full].[All Markets].Children)'
    > select NON EMPTY {[Measures].[Quantity]} ON COLUMNS,
    > {[Markets.Full].[Andy], [Markets].[All Markets].Children} ON ROWS
    > from [SteelWheelsSales]
    >
    > It also appears that mondrian does not let you add members at other levels other than the root level. Is this correct?
    >
    > Any ideas or thoughts on getting a calculated member on a lower level?
    > _______________________________________________
    > 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

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.