US and Worldwide: +1 (866) 660-7555
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
    Code:
    <Measure aggregator="sum" column="market_cap" name="market_cap" visible="true"/>
    Can i change aggregation type of measure in mdx query ? Some like this:

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

  2. #2
    Join Date
    Nov 2008
    Posts
    727

    Default

    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.
    pdi-ce-4.4.0-stable
    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
  •