Hitachi Vantara Pentaho Community Forums
Results 1 to 6 of 6

Thread: [Mondrian] Formatters and Calculated Members in Virtual Cubes

  1. #1
    Alan Jackson Guest

    Default [Mondrian] Formatters and Calculated Members in Virtual Cubes

    Hi Guys,
    Just wondering if anyone can confirm whether this is a bug I'm seeing or
    not.
    If you take a Virtual Cube and add a calculated measure to it, applying
    a formatter to it (FORMATTER="com.acme.myformatter") it doesn't get
    applied. Applying the same formatter to a cube calculated member works
    fine.
    RolapVirtualCubeMeasure.java has a getFormatter method that returns the
    formatter for the cube measure - should there be a check in here for the
    case where the virtual cube measure doesn't have a cube measure behind
    it?

    TIA
    Alan

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

  2. #2
    Julian Hyde Guest

    Default RE: [Mondrian] Formatters and Calculated Members in Virtual Cubes

    I think that was issue 1407747. See
    http://sourceforge.net/tracker/index.php?func=detail
    <http://sourceforge.net/tracker/index...747&group_id=3
    5302&atid=414616> &aid=1407747&group_id=35302&atid=414616.

    Julian


    _____

    From: mondrian-bounces (AT) pentaho (DOT) org [mailto:mondrian-bounces (AT) pentaho (DOT) org] On
    Behalf Of Alan Jackson
    Sent: Monday, March 17, 2008 4:02 PM
    To: mondrian (AT) pentaho (DOT) org
    Subject: [Mondrian] Formatters and Calculated Members in Virtual Cubes


    Hi Guys,
    Just wondering if anyone can confirm whether this is a bug I'm seeing or
    not.
    If you take a Virtual Cube and add a calculated measure to it, applying a
    formatter to it (FORMATTER="com.acme.myformatter") it doesn't get applied.
    Applying the same formatter to a cube calculated member works fine.
    RolapVirtualCubeMeasure.java has a getFormatter method that returns the
    formatter for the cube measure - should there be a check in here for the
    case where the virtual cube measure doesn't have a cube measure behind it?

    TIA
    Alan


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

  3. #3
    Alan Jackson Guest

    Default RE: [Mondrian] Formatters and Calculated Members in Virtual Cubes

    Thanks Julian
    The issue (#1407747) seems to only relate the the case where the
    calculated member is in a cube
    It doesn't seem to cover the case where the calculated member is in a
    VIRTUAL cube.

    Our calculated measure only exists in the virtual cube, it does not
    exist in the physical cubes.

    It looks like these work in subtly different ways.

    Is it possible to have this fixed in the Virtual Cube scenario as well?

    Our schema looks like:

    <VirtualCube name="VirtCube">
    <VirtualCubeDimension name="Dim1"/>
    ...
    <VirtualCubeMeasure cubeName="Cube1" name="[Measures].[Measure1] />
    ...
    <CalculatedMember dimension="Measures" forumula="..."
    formatter="com.acme.myformatter" name="calcmem1" />
    </VirtualCube>

    Thanks
    Alan

    ________________________________

    From: mondrian-bounces (AT) pentaho (DOT) org [mailto:mondrian-bounces (AT) pentaho (DOT) org]
    On Behalf Of Julian Hyde
    Sent: 17 March 2008 23:50
    To: 'Mondrian developer mailing list'
    Subject: RE: [Mondrian] Formatters and Calculated Members in Virtual
    Cubes


    I think that was issue 1407747. See
    http://sourceforge.net/tracker/index...407747&group_i
    d=35302&atid=414616.

    Julian


    ________________________________

    From: mondrian-bounces (AT) pentaho (DOT) org
    [mailto:mondrian-bounces (AT) pentaho (DOT) org] On Behalf Of Alan Jackson
    Sent: Monday, March 17, 2008 4:02 PM
    To: mondrian (AT) pentaho (DOT) org
    Subject: [Mondrian] Formatters and Calculated Members in Virtual
    Cubes


    Hi Guys,
    Just wondering if anyone can confirm whether this is a bug I'm
    seeing or not.
    If you take a Virtual Cube and add a calculated measure to it,
    applying a formatter to it (FORMATTER="com.acme.myformatter") it doesn't
    get applied. Applying the same formatter to a cube calculated member
    works fine.
    RolapVirtualCubeMeasure.java has a getFormatter method that
    returns the formatter for the cube measure - should there be a check in
    here for the case where the virtual cube measure doesn't have a cube
    measure behind it?

    TIA
    Alan


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

  4. #4
    Julian Hyde Guest

    Default RE: [Mondrian] Formatters and Calculated Members in Virtual Cubes

    Did you try creating a property called CELL_FORMATTER?

    <CalculatedMember dimension="Measures" forumula="..." name="calcmem1" >
    <CalculatedMemberProperty name="CELL_FORMATTER"
    value="com.acme.MyFormatter" />
    </CalculatedMember>

    Julian

    _____

    From: Alan Jackson [mailto:AlanJ (AT) symmetrics (DOT) net]
    Sent: Tuesday, March 18, 2008 1:28 PM
    To: jhyde (AT) pentaho (DOT) org; Mondrian developer mailing list
    Subject: RE: [Mondrian] Formatters and Calculated Members in Virtual Cubes


    Thanks Julian
    The issue (#1407747) seems to only relate the the case where the calculated
    member is in a cube
    It doesn't seem to cover the case where the calculated member is in a
    VIRTUAL cube.

    Our calculated measure only exists in the virtual cube, it does not exist in
    the physical cubes.

    It looks like these work in subtly different ways.

    Is it possible to have this fixed in the Virtual Cube scenario as well?

    Our schema looks like:

    <VirtualCube name="VirtCube">
    <VirtualCubeDimension name="Dim1"/>
    ...
    <VirtualCubeMeasure cubeName="Cube1" name="[Measures].[Measure1] />
    ...
    <CalculatedMember dimension="Measures" forumula="..."
    formatter="com.acme.myformatter" name="calcmem1" />
    </VirtualCube>

    Thanks
    Alan

    _____

    From: mondrian-bounces (AT) pentaho (DOT) org [mailto:mondrian-bounces (AT) pentaho (DOT) org] On
    Behalf Of Julian Hyde
    Sent: 17 March 2008 23:50
    To: 'Mondrian developer mailing list'
    Subject: RE: [Mondrian] Formatters and Calculated Members in Virtual Cubes


    I think that was issue 1407747. See
    http://sourceforge.net/tracker/index.php?func=detail
    <http://sourceforge.net/tracker/index...747&group_id=3
    5302&atid=414616> &aid=1407747&group_id=35302&atid=414616.

    Julian


    _____

    From: mondrian-bounces (AT) pentaho (DOT) org [mailto:mondrian-bounces (AT) pentaho (DOT) org] On
    Behalf Of Alan Jackson
    Sent: Monday, March 17, 2008 4:02 PM
    To: mondrian (AT) pentaho (DOT) org
    Subject: [Mondrian] Formatters and Calculated Members in Virtual Cubes


    Hi Guys,
    Just wondering if anyone can confirm whether this is a bug I'm seeing or
    not.
    If you take a Virtual Cube and add a calculated measure to it, applying a
    formatter to it (FORMATTER="com.acme.myformatter") it doesn't get applied.
    Applying the same formatter to a cube calculated member works fine.
    RolapVirtualCubeMeasure.java has a getFormatter method that returns the
    formatter for the cube measure - should there be a check in here for the
    case where the virtual cube measure doesn't have a cube measure behind it?

    TIA
    Alan


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

  5. #5
    Alan Jackson Guest

    Default RE: [Mondrian] Formatters and Calculated Members in Virtual Cubes

    Thanks Julian, works a treat

    Could I suggest that the doc's are updated to reflect this?

    Thanks
    Alan

    ________________________________

    From: Julian Hyde [mailto:jhyde (AT) pentaho (DOT) org]
    Sent: 19 March 2008 03:53
    To: Alan Jackson
    Cc: mondrian (AT) pentaho (DOT) org
    Subject: RE: [Mondrian] Formatters and Calculated Members in Virtual
    Cubes


    Did you try creating a property called CELL_FORMATTER?

    <CalculatedMember dimension="Measures" forumula="..." name="calcmem1"
    >

    <CalculatedMemberProperty name="CELL_FORMATTER"
    value="com.acme.MyFormatter" />
    </CalculatedMember>

    Julian

    ________________________________

    From: Alan Jackson [mailto:AlanJ (AT) symmetrics (DOT) net]
    Sent: Tuesday, March 18, 2008 1:28 PM
    To: jhyde (AT) pentaho (DOT) org; Mondrian developer mailing list
    Subject: RE: [Mondrian] Formatters and Calculated Members in
    Virtual Cubes


    Thanks Julian
    The issue (#1407747) seems to only relate the the case where the
    calculated member is in a cube
    It doesn't seem to cover the case where the calculated member is
    in a VIRTUAL cube.

    Our calculated measure only exists in the virtual cube, it does
    not exist in the physical cubes.

    It looks like these work in subtly different ways.

    Is it possible to have this fixed in the Virtual Cube scenario
    as well?

    Our schema looks like:

    <VirtualCube name="VirtCube">
    <VirtualCubeDimension name="Dim1"/>
    ...
    <VirtualCubeMeasure cubeName="Cube1"
    name="[Measures].[Measure1] />
    ...
    <CalculatedMember dimension="Measures" forumula="..."
    formatter="com.acme.myformatter" name="calcmem1" />
    </VirtualCube>

    Thanks
    Alan

    ________________________________

    From: mondrian-bounces (AT) pentaho (DOT) org
    [mailto:mondrian-bounces (AT) pentaho (DOT) org] On Behalf Of Julian Hyde
    Sent: 17 March 2008 23:50
    To: 'Mondrian developer mailing list'
    Subject: RE: [Mondrian] Formatters and Calculated Members in
    Virtual Cubes


    I think that was issue 1407747. See
    http://sourceforge.net/tracker/index...407747&group_i
    d=35302&atid=414616.

    Julian


    ________________________________

    From: mondrian-bounces (AT) pentaho (DOT) org
    [mailto:mondrian-bounces (AT) pentaho (DOT) org] On Behalf Of Alan Jackson
    Sent: Monday, March 17, 2008 4:02 PM
    To: mondrian (AT) pentaho (DOT) org
    Subject: [Mondrian] Formatters and Calculated Members in
    Virtual Cubes


    Hi Guys,
    Just wondering if anyone can confirm whether this is a
    bug I'm seeing or not.
    If you take a Virtual Cube and add a calculated measure
    to it, applying a formatter to it (FORMATTER="com.acme.myformatter") it
    doesn't get applied. Applying the same formatter to a cube calculated
    member works fine.
    RolapVirtualCubeMeasure.java has a getFormatter method
    that returns the formatter for the cube measure - should there be a
    check in here for the case where the virtual cube measure doesn't have a
    cube measure behind it?

    TIA
    Alan


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

  6. #6
    Julian Hyde Guest

    Default RE: [Mondrian] Formatters and Calculated Members in Virtual Cubes

    done in change 10735; will be in mondrian-3.0.1.


    _____

    From: Alan Jackson [mailto:AlanJ (AT) symmetrics (DOT) net]
    Sent: Wednesday, March 19, 2008 12:30 PM
    To: jhyde (AT) pentaho (DOT) org
    Cc: mondrian (AT) pentaho (DOT) org
    Subject: RE: [Mondrian] Formatters and Calculated Members in Virtual Cubes


    Thanks Julian, works a treat

    Could I suggest that the doc's are updated to reflect this?

    Thanks
    Alan

    _____

    From: Julian Hyde [mailto:jhyde (AT) pentaho (DOT) org]
    Sent: 19 March 2008 03:53
    To: Alan Jackson
    Cc: mondrian (AT) pentaho (DOT) org
    Subject: RE: [Mondrian] Formatters and Calculated Members in Virtual Cubes


    Did you try creating a property called CELL_FORMATTER?

    <CalculatedMember dimension="Measures" forumula="..." name="calcmem1" >
    <CalculatedMemberProperty name="CELL_FORMATTER"
    value="com.acme.MyFormatter" />
    </CalculatedMember>

    Julian

    _____

    From: Alan Jackson [mailto:AlanJ (AT) symmetrics (DOT) net]
    Sent: Tuesday, March 18, 2008 1:28 PM
    To: jhyde (AT) pentaho (DOT) org; Mondrian developer mailing list
    Subject: RE: [Mondrian] Formatters and Calculated Members in Virtual Cubes


    Thanks Julian
    The issue (#1407747) seems to only relate the the case where the calculated
    member is in a cube
    It doesn't seem to cover the case where the calculated member is in a
    VIRTUAL cube.

    Our calculated measure only exists in the virtual cube, it does not exist in
    the physical cubes.

    It looks like these work in subtly different ways.

    Is it possible to have this fixed in the Virtual Cube scenario as well?

    Our schema looks like:

    <VirtualCube name="VirtCube">
    <VirtualCubeDimension name="Dim1"/>
    ...
    <VirtualCubeMeasure cubeName="Cube1" name="[Measures].[Measure1] />
    ...
    <CalculatedMember dimension="Measures" forumula="..."
    formatter="com.acme.myformatter" name="calcmem1" />
    </VirtualCube>

    Thanks
    Alan

    _____

    From: mondrian-bounces (AT) pentaho (DOT) org [mailto:mondrian-bounces (AT) pentaho (DOT) org] On
    Behalf Of Julian Hyde
    Sent: 17 March 2008 23:50
    To: 'Mondrian developer mailing list'
    Subject: RE: [Mondrian] Formatters and Calculated Members in Virtual Cubes


    I think that was issue 1407747. See
    http://sourceforge.net/tracker/index.php?func=detail
    <http://sourceforge.net/tracker/index...747&group_id=3
    5302&atid=414616> &aid=1407747&group_id=35302&atid=414616.

    Julian


    _____

    From: mondrian-bounces (AT) pentaho (DOT) org [mailto:mondrian-bounces (AT) pentaho (DOT) org] On
    Behalf Of Alan Jackson
    Sent: Monday, March 17, 2008 4:02 PM
    To: mondrian (AT) pentaho (DOT) org
    Subject: [Mondrian] Formatters and Calculated Members in Virtual Cubes


    Hi Guys,
    Just wondering if anyone can confirm whether this is a bug I'm seeing or
    not.
    If you take a Virtual Cube and add a calculated measure to it, applying a
    formatter to it (FORMATTER="com.acme.myformatter") it doesn't get applied.
    Applying the same formatter to a cube calculated member works fine.
    RolapVirtualCubeMeasure.java has a getFormatter method that returns the
    formatter for the cube measure - should there be a check in here for the
    case where the virtual cube measure doesn't have a cube measure behind it?

    TIA
    Alan


    _______________________________________________
    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.