Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Count

  1. #1
    Join Date
    Oct 2003

    Default Count

    Count function is not taking in account any conditions - if i do a query like:
    with member [Measures].[Count] as 'Count([Something].Children, ExcludeEmpty)'
    select {[Measures].[Count]} on Columns,
    {[Dim].[Val1], [Dim].[Val2]} on Rows
    from [My Cube]
    it will return full count of [Something].Children for both rows rather then returning only those with the proper Val1 and Val2 [Dim] values
    Is it a cnown bug and is there a workaround for now?

  2. #2
    Join Date
    Nov 1999

    Default RE: Count

    Yes, this is a bug.
    I just fixed it (change 992).
    The workaround is to use Count(..., Filter(Not(IsEmpty([Measures].CurrentMember)))).

  3. #3
    Join Date
    Oct 2003

    Default RE: Count

    Works great!

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.