Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Count

  1. #1
    Join Date
    Oct 2003
    Posts
    20

    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?
    Thanks

  2. #2
    Join Date
    Nov 1999
    Posts
    1,618

    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
    Posts
    20

    Default RE: Count

    Works great!
    Thnks.

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.