Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: [Mondrian] Lazy validation of Calculated Members

  1. #1
    Thiyagu Palanisamy Guest

    Default [Mondrian] Lazy validation of Calculated Members

    Hi,
    We have schema with very large number of calculated members, validating
    all of those during schema load slows our system startup considerably.
    Do you see any major issue if we skip the validation of Calculated
    Members until it is used?


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

  2. #2
    Richard Emberson Guest

    Default Re: [Mondrian] Lazy validation of Calculated Members

    If you must do it, please make it an option via a Mondrian
    property. Some of us want to know when things startup
    that everything is ok, rather than wait an hour for
    some user to tell us that a query does not work.

    Richard


    Thiyagu Palanisamy wrote:
    >
    > Hi,
    > We have schema with very large number of calculated members,
    > validating all of those during schema load slows our system startup
    > considerably.
    > Do you see any major issue if we skip the validation of Calculated
    > Members until it is used?
    >
    >
    > Thanks,
    > Thiyagu
    >
    >
    > ------------------------------------------------------------------------
    >
    > _______________________________________________
    > Mondrian mailing list
    > Mondrian (AT) pentaho (DOT) org
    > http://lists.pentaho.org/mailman/listinfo/mondrian



    --
    Quis custodiet ipsos custodes:
    This email message is for the sole use of the intended recipient(s) and
    may contain confidential information. Any unauthorized review, use,
    disclosure or distribution is prohibited. If you are not the intended
    recipient, please contact the sender by reply email and destroy all
    copies of the original message.
    _______________________________________________
    Mondrian mailing list
    Mondrian (AT) pentaho (DOT) org
    http://lists.pentaho.org/mailman/listinfo/mondrian

  3. #3
    Thiyagu Palanisamy Guest

    Default Re: [Mondrian] Lazy validation of Calculated Members

    Sure Richard,

    Just started to analyse the possibility of implementing this function.

    Thanks,
    Thiyagu




    Richard Emberson <remberson (AT) edgedynamics (DOT) com>
    Sent by: mondrian-bounces (AT) pentaho (DOT) org
    12/06/2007 18:40
    Please respond to
    Mondrian developer mailing list <mondrian (AT) pentaho (DOT) org>


    To
    Mondrian developer mailing list <mondrian (AT) pentaho (DOT) org>
    cc

    Subject
    Re: [Mondrian] Lazy validation of Calculated Members






    If you must do it, please make it an option via a Mondrian
    property. Some of us want to know when things startup
    that everything is ok, rather than wait an hour for
    some user to tell us that a query does not work.

    Richard


    Thiyagu Palanisamy wrote:
    >
    > Hi,
    > We have schema with very large number of calculated members,
    > validating all of those during schema load slows our system startup
    > considerably.
    > Do you see any major issue if we skip the validation of Calculated
    > Members until it is used?
    >
    >
    > Thanks,
    > Thiyagu
    >
    >
    > ------------------------------------------------------------------------
    >
    > _______________________________________________
    > Mondrian mailing list
    > Mondrian (AT) pentaho (DOT) org
    > http://lists.pentaho.org/mailman/listinfo/mondrian



    --
    Quis custodiet ipsos custodes:
    This email message is for the sole use of the intended recipient(s) and
    may contain confidential information. Any unauthorized review, use,
    disclosure or distribution is prohibited. If you are not the intended
    recipient, please contact the sender by reply email and destroy all
    copies of the original message.
    _______________________________________________
    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] Lazy validation of Calculated Members

    Sounds like a feature which will cause more problems than it solves. I
    think you should just live with it. We have enough properties already.

    How many calc members do you have? It should be able to validate
    hundreds per second. Consider tuning the validation process (there might
    be an O(n^2) perf bug somewhere).

    If the server startup is only a problem during development, use a
    smaller schema file with fewer members during development.

    Julian


    _____

    From: mondrian-bounces (AT) pentaho (DOT) org [mailto:mondrian-bounces (AT) pentaho (DOT) org]
    On Behalf Of Thiyagu Palanisamy
    Sent: Tuesday, June 12, 2007 6:04 AM
    To: Mondrian developer mailing list
    Subject: Re: [Mondrian] Lazy validation of Calculated Members



    Sure Richard,

    Just started to analyse the possibility of implementing this function.

    Thanks,
    Thiyagu




    Richard Emberson <remberson (AT) edgedynamics (DOT) com>
    Sent by: mondrian-bounces (AT) pentaho (DOT) org


    12/06/2007 18:40


    Please respond to
    Mondrian developer mailing list <mondrian (AT) pentaho (DOT) org>



    To
    Mondrian developer mailing list <mondrian (AT) pentaho (DOT) org>

    cc

    Subject
    Re: [Mondrian] Lazy validation of Calculated Members






    If you must do it, please make it an option via a Mondrian
    property. Some of us want to know when things startup
    that everything is ok, rather than wait an hour for
    some user to tell us that a query does not work.

    Richard


    Thiyagu Palanisamy wrote:
    >
    > Hi,
    > We have schema with very large number of calculated members,
    > validating all of those during schema load slows our system startup
    > considerably.
    > Do you see any major issue if we skip the validation of Calculated
    > Members until it is used?
    >
    >
    > Thanks,
    > Thiyagu
    >
    >
    >

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



    --
    Quis custodiet ipsos custodes:
    This email message is for the sole use of the intended recipient(s) and
    may contain confidential information. Any unauthorized review, use,
    disclosure or distribution is prohibited. If you are not the intended
    recipient, please contact the sender by reply email and destroy all
    copies of the original message.
    _______________________________________________
    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.