Hitachi Vantara Pentaho Community Forums

Search Forums:

Type: Posts; User: magnosis; Keyword(s):

Search Forums: Search took 0.02 seconds.

  1. I've resolved this problem, here's my solution to...

    I've resolved this problem, here's my solution to applying mixed formatting across rows & columns:

    WITH

    MEMBER [Measures].[# trans] AS ( ... )

    MEMBER [Measures].[$ spent ] AS ( ... )...
  2. Workaround to "HAVING" clause with "CoalesceEmpty( , )" ?

    I am trying to get rid of all-null results in a calculated member, before applying CoalesceEmpty( , ) on a calculated member.

    Basically:
    - If tuple contains some NULL values, replace them with 0 ...
  3. Mixing percentage and absolute values in same column

    Hello all,

    Is is possible, with MDX, to create a table with both absolute values and percentage in the same columns ?

    The table should display # of transactions and amount spent (measures) per...
  4. Replies
    3
    Views
    1,729

    Thanks. Also found this:...

    Thanks.
    Also found this: http://forums.pentaho.com/showthread.php?65993-Support-for-non-additive-and-semi-additive-measures
    Should help me achieve my goal.
  5. Replies
    3
    Views
    1,729

    Does Mondrian implement DistinctCount aggregation...

    Does Mondrian implement DistinctCount aggregation ? I haven't seen any reference to it in the docs but might have overlooked it...
  6. Replies
    3
    Views
    1,729

    SUM-OF-MIN aggregate function ?

    Hello all !

    I am very new to Mondrian/OLAP. I need to either modify an existing cube, or fix MDX queries to use a sum-of-min aggregation.
    I hope this can be done without resorting to a custom...
Results 1 to 6 of 6
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

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