Hitachi Vantara Pentaho Community Forums
Results 1 to 17 of 17

Thread: [Mondrian] Infobright Distinct Count

  1. #1
    Tom Barber Guest

    Default [Mondrian] Infobright Distinct Count

    Hey Guys,

    I'm working with Pedro on a project involving Infobright(3.4.2). Pedro noticed that Mondrian is executing the following:

    select count(*) as `c0` from (select distinct `dim_marketing_sources`.`sublevel2` as `c0`, `dim_marketing_sources`.`sublevel1` as `c1`, `dim_marketing_sources`.`mkt_channel` as `c2` from `dim_marketing_sources` as `dim_marketing_sources`) as `init`;

    which takes 18 seconds to execute where as,

    select count(distinct `dim_marketing_sources`.`sublevel2` , `dim_marketing_sources`.`sublevel1`, `dim_marketing_sources`.`mkt_channel`) as `c` from `dim_marketing_sources`;

    takes less than 1.

    Is there any technical reason why the top count is preferred and if not, what needs to occur for the dialect to change?

    Thanks

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

  2. #2
    Julian Hyde Guest

    Default RE: [Mondrian] Infobright Distinct Count

    The method that controls this is Dialect.allowsCompoundCountDistinct().

    This method returns false by default, MySqlDialect overrides to return true,
    and InfobrightDialect overrides that to return false.

    I added InfobrightDialect in change 12402, fixing bug
    http://jira.pentaho.com/browse/MONDRIAN-512. I must have made it return
    false for a good reason. Looking at
    DialectTest.testAllowsCompoundCountDistinct, it appears that older versions
    of Infobright returned the following error:

    "The query includes syntax that is not supported by the Infobright
    Optimizer. Either restructure the query with supported syntax, or enable the
    MySQL Query Path in the brighthouse.ini file to execute the query with
    reduced performance."

    My guess is that you are running a later version of Infobright. What version
    are you running?

    If so, the fix would be for the method to return a different value depending
    on the version of infobright. Run the full mondrian test suite through
    infobright, and let me know the results. It will be interesting if other
    DialectTest methods fail... each of those failures may indicate a feature of
    infobright that we can take advantage of.

    I have logged http://jira.pentaho.com/browse/MONDRIAN-889 to track this.

    Julian

    > -----Original Message-----
    > From: mondrian-bounces (AT) pentaho (DOT) org
    > [mailto:mondrian-bounces (AT) pentaho (DOT) org] On Behalf Of Tom Barber
    > Sent: Tuesday, February 08, 2011 4:10 AM
    > To: mondrian (AT) pentaho (DOT) org
    > Subject: [Mondrian] Infobright Distinct Count
    >
    > Hey Guys,
    >
    > I'm working with Pedro on a project involving
    > Infobright(3.4.2). Pedro noticed that Mondrian is executing
    > the following:
    >
    > select count(*) as `c0` from (select distinct
    > `dim_marketing_sources`.`sublevel2` as `c0`,
    > `dim_marketing_sources`.`sublevel1` as `c1`,
    > `dim_marketing_sources`.`mkt_channel` as `c2` from
    > `dim_marketing_sources` as `dim_marketing_sources`) as `init`;
    >
    > which takes 18 seconds to execute where as,
    >
    > select count(distinct `dim_marketing_sources`.`sublevel2` ,
    > `dim_marketing_sources`.`sublevel1`,
    > `dim_marketing_sources`.`mkt_channel`) as `c` from
    > `dim_marketing_sources`;
    >
    > takes less than 1.
    >
    > Is there any technical reason why the top count is preferred
    > and if not, what needs to occur for the dialect to change?
    >
    > Thanks
    >
    > Tom
    >


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

  3. #3
    Pedro Alves Guest

    Default Re: [Mondrian] Infobright Distinct Count

    On 02/08/2011 05:45 PM, Julian Hyde wrote:
    > My guess is that you are running a later version of Infobright. What version
    > are you running?


    3.4.2

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

  4. #4
    Tom Barber Guest

    Default RE: [Mondrian] Infobright Distinct Count

    Thanks for the reply Julian,

    Interestingly, the mysql client says there is a warning. But "show warnings" returns null, and the result is of course correct so I think this may be a legacy thing, I am running 3.4.2 and I think 3.5 is now available as well.

    I shall run the mondrian test suite and let you know the results.

    Cheers

    Tom
    ________________________________________
    From: mondrian-bounces (AT) pentaho (DOT) org [mondrian-bounces (AT) pentaho (DOT) org] On Behalf Of Julian Hyde [jhyde (AT) pentaho (DOT) com]
    Sent: 08 February 2011 17:45
    To: 'Mondrian developer mailing list'
    Subject: RE: [Mondrian] Infobright Distinct Count

    The method that controls this is Dialect.allowsCompoundCountDistinct().

    This method returns false by default, MySqlDialect overrides to return true,
    and InfobrightDialect overrides that to return false.

    I added InfobrightDialect in change 12402, fixing bug
    http://jira.pentaho.com/browse/MONDRIAN-512. I must have made it return
    false for a good reason. Looking at
    DialectTest.testAllowsCompoundCountDistinct, it appears that older versions
    of Infobright returned the following error:

    "The query includes syntax that is not supported by the Infobright
    Optimizer. Either restructure the query with supported syntax, or enable the
    MySQL Query Path in the brighthouse.ini file to execute the query with
    reduced performance."

    My guess is that you are running a later version of Infobright. What version
    are you running?

    If so, the fix would be for the method to return a different value depending
    on the version of infobright. Run the full mondrian test suite through
    infobright, and let me know the results. It will be interesting if other
    DialectTest methods fail... each of those failures may indicate a feature of
    infobright that we can take advantage of.

    I have logged http://jira.pentaho.com/browse/MONDRIAN-889 to track this.

    Julian


    > -----Original Message-----
    > From: mondrian-bounces (AT) pentaho (DOT) org
    > [mailto:mondrian-bounces (AT) pentaho (DOT) org] On Behalf Of Tom Barber
    > Sent: Tuesday, February 08, 2011 4:10 AM
    > To: mondrian (AT) pentaho (DOT) org
    > Subject: [Mondrian] Infobright Distinct Count
    >
    > Hey Guys,
    >
    > I'm working with Pedro on a project involving
    > Infobright(3.4.2). Pedro noticed that Mondrian is executing
    > the following:
    >
    > select count(*) as `c0` from (select distinct
    > `dim_marketing_sources`.`sublevel2` as `c0`,
    > `dim_marketing_sources`.`sublevel1` as `c1`,
    > `dim_marketing_sources`.`mkt_channel` as `c2` from
    > `dim_marketing_sources` as `dim_marketing_sources`) as `init`;
    >
    > which takes 18 seconds to execute where as,
    >
    > select count(distinct `dim_marketing_sources`.`sublevel2` ,
    > `dim_marketing_sources`.`sublevel1`,
    > `dim_marketing_sources`.`mkt_channel`) as `c` from
    > `dim_marketing_sources`;
    >
    > takes less than 1.
    >
    > Is there any technical reason why the top count is preferred
    > and if not, what needs to occur for the dialect to change?
    >
    > Thanks
    >
    > Tom
    >


    _______________________________________________
    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

  5. #5
    Julian Hyde Guest

    Default RE: [Mondrian] Infobright Distinct Count

    > Tom wrote:
    >
    > Interestingly, the mysql client says there is a warning. But
    > "show warnings" returns null, and the result is of course
    > correct so I think this may be a legacy thing, I am running
    > 3.4.2 and I think 3.5 is now available as well.
    >
    > I shall run the mondrian test suite and let you know the results.


    Thanks. Looking forward to those results. Attach a patch to the jira case
    when you have one.

    If I remember rightly, in the previous version there was an outright error,
    not just a warning.

    In previous versions of Infobright the concern was not correctness. If the
    feature was not handled by the Infobright engine it would fall through to
    MySQL and performance would be abyssmal.

    It looks like every version of Infobright has significant improvements. Keep
    a close eye on that log4j.category.mondrian.sql output and let me know if
    you see anything else that is odd.

    Julian

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

  6. #6
    Tom Barber Guest

    Default RE: [Mondrian] Infobright Distinct Count

    When was IB last tested? Cause the loader keeps freaking out at:

    3100,3000,"Gross Sales","Income","+","LookUpCube("[Sales]","(Measures.[Store Sales],"+time.currentmember.UniqueName+","+ Store.currentmember.UniqueName+")")"

    [java] java.lang.RuntimeException: Error while executing statement: LOAD DATA INFILE '/tmp/tmpfile2200554152399396504.csv' INTO TABLE account FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'

    We've had issues with the IB loader before, but I was wondering if this was in the test suite before or this is post last IB test run.

    Cheers

    Tom
    ________________________________________
    From: Julian Hyde [jhyde (AT) pentaho (DOT) com]
    Sent: 08 February 2011 18:13
    To: Tom Barber; 'Mondrian developer mailing list'
    Subject: RE: [Mondrian] Infobright Distinct Count


    > Tom wrote:
    >
    > Interestingly, the mysql client says there is a warning. But
    > "show warnings" returns null, and the result is of course
    > correct so I think this may be a legacy thing, I am running
    > 3.4.2 and I think 3.5 is now available as well.
    >
    > I shall run the mondrian test suite and let you know the results.


    Thanks. Looking forward to those results. Attach a patch to the jira case
    when you have one.

    If I remember rightly, in the previous version there was an outright error,
    not just a warning.

    In previous versions of Infobright the concern was not correctness. If the
    feature was not handled by the Infobright engine it would fall through to
    MySQL and performance would be abyssmal.

    It looks like every version of Infobright has significant improvements. Keep
    a close eye on that log4j.category.mondrian.sql output and let me know if
    you see anything else that is odd.

    Julian


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

  7. #7
    Tom Barber Guest

    Default RE: [Mondrian] Infobright Distinct Count

    Always helps if I actually list the error

    [java] Caused by: java.sql.SQLException: Row 4 was truncated; it contained more data than there were input columns

    ________________________________________
    From: mondrian-bounces (AT) pentaho (DOT) org [mondrian-bounces (AT) pentaho (DOT) org] On Behalf Of Tom Barber [Tom.Barber (AT) ecommera (DOT) co.uk]
    Sent: 09 February 2011 16:08
    To: jhyde (AT) pentaho (DOT) com; 'Mondrian developer mailing list'
    Subject: RE: [Mondrian] Infobright Distinct Count

    When was IB last tested? Cause the loader keeps freaking out at:

    3100,3000,"Gross Sales","Income","+","LookUpCube("[Sales]","(Measures.[Store Sales],"+time.currentmember.UniqueName+","+ Store.currentmember.UniqueName+")")"

    [java] java.lang.RuntimeException: Error while executing statement: LOAD DATA INFILE '/tmp/tmpfile2200554152399396504.csv' INTO TABLE account FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'

    We've had issues with the IB loader before, but I was wondering if this was in the test suite before or this is post last IB test run.

    Cheers

    Tom
    ________________________________________
    From: Julian Hyde [jhyde (AT) pentaho (DOT) com]
    Sent: 08 February 2011 18:13
    To: Tom Barber; 'Mondrian developer mailing list'
    Subject: RE: [Mondrian] Infobright Distinct Count


    > Tom wrote:
    >
    > Interestingly, the mysql client says there is a warning. But
    > "show warnings" returns null, and the result is of course
    > correct so I think this may be a legacy thing, I am running
    > 3.4.2 and I think 3.5 is now available as well.
    >
    > I shall run the mondrian test suite and let you know the results.


    Thanks. Looking forward to those results. Attach a patch to the jira case
    when you have one.

    If I remember rightly, in the previous version there was an outright error,
    not just a warning.

    In previous versions of Infobright the concern was not correctness. If the
    feature was not handled by the Infobright engine it would fall through to
    MySQL and performance would be abyssmal.

    It looks like every version of Infobright has significant improvements. Keep
    a close eye on that log4j.category.mondrian.sql output and let me know if
    you see anything else that is odd.

    Julian


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

  8. #8
    Tom Barber Guest

    Default RE: [Mondrian] Infobright Distinct Count

    Scratch that I overrode the bulkloader type on the IB server and it loads up

    Cheers

    Tom
    ________________________________________
    From: mondrian-bounces (AT) pentaho (DOT) org [mondrian-bounces (AT) pentaho (DOT) org] On Behalf Of Tom Barber [Tom.Barber (AT) ecommera (DOT) co.uk]
    Sent: 09 February 2011 16:18
    To: Mondrian developer mailing list
    Subject: RE: [Mondrian] Infobright Distinct Count

    Always helps if I actually list the error

    [java] Caused by: java.sql.SQLException: Row 4 was truncated; it contained more data than there were input columns

    ________________________________________
    From: mondrian-bounces (AT) pentaho (DOT) org [mondrian-bounces (AT) pentaho (DOT) org] On Behalf Of Tom Barber [Tom.Barber (AT) ecommera (DOT) co.uk]
    Sent: 09 February 2011 16:08
    To: jhyde (AT) pentaho (DOT) com; 'Mondrian developer mailing list'
    Subject: RE: [Mondrian] Infobright Distinct Count

    When was IB last tested? Cause the loader keeps freaking out at:

    3100,3000,"Gross Sales","Income","+","LookUpCube("[Sales]","(Measures.[Store Sales],"+time.currentmember.UniqueName+","+ Store.currentmember.UniqueName+")")"

    [java] java.lang.RuntimeException: Error while executing statement: LOAD DATA INFILE '/tmp/tmpfile2200554152399396504.csv' INTO TABLE account FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'

    We've had issues with the IB loader before, but I was wondering if this was in the test suite before or this is post last IB test run.

    Cheers

    Tom
    ________________________________________
    From: Julian Hyde [jhyde (AT) pentaho (DOT) com]
    Sent: 08 February 2011 18:13
    To: Tom Barber; 'Mondrian developer mailing list'
    Subject: RE: [Mondrian] Infobright Distinct Count


    > Tom wrote:
    >
    > Interestingly, the mysql client says there is a warning. But
    > "show warnings" returns null, and the result is of course
    > correct so I think this may be a legacy thing, I am running
    > 3.4.2 and I think 3.5 is now available as well.
    >
    > I shall run the mondrian test suite and let you know the results.


    Thanks. Looking forward to those results. Attach a patch to the jira case
    when you have one.

    If I remember rightly, in the previous version there was an outright error,
    not just a warning.

    In previous versions of Infobright the concern was not correctness. If the
    feature was not handled by the Infobright engine it would fall through to
    MySQL and performance would be abyssmal.

    It looks like every version of Infobright has significant improvements. Keep
    a close eye on that log4j.category.mondrian.sql output and let me know if
    you see anything else that is odd.

    Julian


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

  9. #9
    Julian Hyde Guest

    Default RE: [Mondrian] Infobright Distinct Count

    I enabled bulk-loading for infobright because the community edition didn't
    support INSERT.

    Looks like I didn't deal with double-quotes correctly. I don't know why this
    worked in previous versions.

    Can you change MondrianFoodMartLoader so that the load statement is

    LOAD DATA INFILE <filename> INTO TABLE account
    FIELDS TERMINATED BY ','
    OPTIONALLY ENCLOSED BY '"'
    ESCAPED BY '\\'

    And the code to generate the temporary CSV file should be

    fileOutput.write(
    massagedLine.toString().replaceAll("\"", "\\\"")
    .replace('\'', '"').trim());

    Hence that line in the CSV file would be

    3100,3000,"Gross
    Sales","Income","+","LookUpCube(\"[Sales]\",\"(Measures.[Store
    Sales],\"+time.currentmember.UniqueName+\",\"+Store.currentmember.UniqueName
    +\")\")"

    Julian

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

  10. #10
    Julian Hyde Guest

    Default RE: [Mondrian] Infobright Distinct Count

    > Scratch that I overrode the bulkloader type on the IB server
    > and it loads up


    Can you describe in more detail what you did to fix this problem?

    If it is not straightforward or not applicable to Infobright community
    edition, I'd like to fix MondrianFoodMartLoader so that it works out of the
    box.

    Julian

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

  11. #11
    Julian Hyde Guest

    Default RE: [Mondrian] Infobright Distinct Count

    Tom,

    I have checked in a fix to the loader in change 14104. Please let me know
    whether it helps.

    Julian

    > -----Original Message-----
    > From: Julian Hyde [mailto:jhyde (AT) pentaho (DOT) com]
    > Sent: Wednesday, February 09, 2011 11:22 AM
    > To: 'Mondrian developer mailing list'
    > Subject: RE: [Mondrian] Infobright Distinct Count
    >
    > > Scratch that I overrode the bulkloader type on the IB server
    > > and it loads up

    >
    > Can you describe in more detail what you did to fix this problem?
    >
    > If it is not straightforward or not applicable to Infobright
    > community edition, I'd like to fix MondrianFoodMartLoader so
    > that it works out of the box.
    >
    > Julian
    >


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

  12. #12
    Tom Barber Guest

    Default RE: [Mondrian] Infobright Distinct Count

    I ran the test suite in its current suite through InfoBright and attached the log.

    Excuse my mornic understanding, but if I run the test suite as is, doesn't it run with the current IB dialect and prove nothing?

    Cheers

    Tom
    ________________________________________
    From: Julian Hyde [jhyde (AT) pentaho (DOT) com]
    Sent: 08 February 2011 18:13
    To: Tom Barber; 'Mondrian developer mailing list'
    Subject: RE: [Mondrian] Infobright Distinct Count


    > Tom wrote:
    >
    > Interestingly, the mysql client says there is a warning. But
    > "show warnings" returns null, and the result is of course
    > correct so I think this may be a legacy thing, I am running
    > 3.4.2 and I think 3.5 is now available as well.
    >
    > I shall run the mondrian test suite and let you know the results.


    Thanks. Looking forward to those results. Attach a patch to the jira case
    when you have one.

    If I remember rightly, in the previous version there was an outright error,
    not just a warning.

    In previous versions of Infobright the concern was not correctness. If the
    feature was not handled by the Infobright engine it would fall through to
    MySQL and performance would be abyssmal.

    It looks like every version of Infobright has significant improvements. Keep
    a close eye on that log4j.category.mondrian.sql output and let me know if
    you see anything else that is odd.

    Julian


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

  13. #13
    Julian Hyde Guest

    Default RE: [Mondrian] Infobright Distinct Count

    > Tom wrote:
    >
    > I ran the test suite in its current suite through InfoBright
    > and attached the log.
    >
    > Excuse my mornic understanding, but if I run the test suite
    > as is, doesn't it run with the current IB dialect and prove
    > nothing?


    You'd be testing against a version of Infobright that we haven't tested
    against before.

    This is particularly important for DialectTest, which tests that if the
    dialect says a database CAN'T do a particular thing, then the database gives
    an error confirming that it can't. So, if a future version of the database
    improves, the test will fail, indicating that we can use that feature.

    Looking at the test output, 3 failures is pretty good. The collation test is
    a minor concern; probably the dialect needs to be fixed, but only really a
    concern if you are sorting sets with null values of measures.

    Julian

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

  14. #14
    Tom Barber Guest

    Default RE: [Mondrian] Infobright Distinct Count

    Thanks for that Julian,

    I've been tinkering today and when I set
    allowsCompoundCountDistinct()

    and

    supportsGroupByExpressions()

    to true the test suite still runs okay it seems (same 3 failures).

    Don't bother with
    supportsMultiValueInExpr()

    IN's are still abysmal.

    What I'll probably do is compile a test jar from this source with my tweaks and slap it on my dev box and run my dashboards through it, see if I get the performance boost my bosses are craving.

    Cheers
    Tom
    ________________________________________
    From: Julian Hyde [jhyde (AT) pentaho (DOT) com]
    Sent: 10 February 2011 16:05
    To: Tom Barber; 'Mondrian developer mailing list'
    Subject: RE: [Mondrian] Infobright Distinct Count


    > Tom wrote:
    >
    > I ran the test suite in its current suite through InfoBright
    > and attached the log.
    >
    > Excuse my mornic understanding, but if I run the test suite
    > as is, doesn't it run with the current IB dialect and prove
    > nothing?


    You'd be testing against a version of Infobright that we haven't tested
    against before.

    This is particularly important for DialectTest, which tests that if the
    dialect says a database CAN'T do a particular thing, then the database gives
    an error confirming that it can't. So, if a future version of the database
    improves, the test will fail, indicating that we can use that feature.

    Looking at the test output, 3 failures is pretty good. The collation test is
    a minor concern; probably the dialect needs to be fixed, but only really a
    concern if you are sorting sets with null values of measures.

    Julian


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

  15. #15
    Tom Barber Guest

    Default RE: [Mondrian] Infobright Distinct Count

    Hey Julian,

    The other thing I found on the WWW was

    "In regard to query performance, users should see gains ranging from 20 - 400% depending on the type of query. Most notably, performance gains will be greatest for queries using AND, OR operators and IN clause; Order by, Group by; Union and Union all; Joins (LEFT OUTER Joins, Large

  16. #16
    Tom Barber Guest

    Default RE: [Mondrian] Infobright Distinct Count

    Anyone who can get Mondrian to create a Compound Distinct Count in MDX world from FoodMart, wins a beer.

    Replicating this, is proving mighty tricky.
    _______________________________________________
    Mondrian mailing list
    Mondrian (AT) pentaho (DOT) org
    http://lists.pentaho.org/mailman/listinfo/mondrian

  17. #17
    Julian Hyde Guest

    Default RE: [Mondrian] Infobright Distinct Count

    Eyeballing the code, it only gets called to count the number of members in a
    level, and then only

    (a) if the level's key is compound
    (b) the database has allowsFromQuery() = false

    Several examples of (a) in Foodmart (look for non-top levels where
    uniqueMEmbers=false), but for (b) you will need old DB2 AS/400, Informix,
    MySQL earlier than 4.0 (e.g. 3.23), or Sybase. Not very likely...

    Mondrian seems to generate

    Select count(*) from (select distinct ...)

    for any database that supports subqueries in the FROM clause. If your goal
    is to make it call compound count distinct instead, as an experiment try
    temporarily making allowsFromQuery return false.

    If that succeeds, then switch the logic around in
    SqlMemberSource.makeLevelMemberCountSql to use compound count distinct if
    the database supports it, even if it DOES allow subqueries in the FROM
    clause.

    Julian


    > -----Original Message-----
    > From: Tom Barber [mailto:Tom.Barber (AT) ecommera (DOT) co.uk]
    > Sent: Thursday, February 10, 2011 3:01 PM
    > To: Mondrian developer mailing list; jhyde (AT) pentaho (DOT) com
    > Subject: RE: [Mondrian] Infobright Distinct Count
    >
    > Anyone who can get Mondrian to create a Compound Distinct
    > Count in MDX world from FoodMart, wins a beer.
    >
    > Replicating this, is proving mighty tricky.
    >


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