Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: How to set aggregation type of measure in mdx ?

  1. #1

    Default How to set aggregation type of measure in mdx ?

    In xml schema measure have this attributes
    <Measure aggregator="sum" column="market_cap" name="market_cap" visible="true"/>
    Can i change aggregation type of measure in mdx query ? Some like this:

    select {avg([Measure][market_cap]), count([Measure][market_cap])} on 0 
    from [cube]

  2. #2
    Join Date
    Nov 2008


    Off the top of my head I think it would be easiest to create another measure called market_cap_count with the "count" aggregator and use that in your query.
    Java 1.7 (64 bit)
    MySQL 5.6 (64 bit)
    Windows 7 (64 bit)

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 - 2017 Pentaho Corporation. All Rights Reserved.