Post reply

AVG in cube

  • July 22, 2004 at 4:42 pm

    #108661

    Hi all, I'm trying Analysis Services to possibly deploy some projects over it.

    I'm doing my first cube, so, I'm totally newbie and I have only access to 2k Standard Edition 🙁

    My first problem is: I need AVG function, and only have SUM, COUNT, MAX, MIN & DISTINCT COUNT.

    Exists an AVG function here?

    Is only avaliable in Enterprise Edition?

    Thanks

  • July 23, 2004 at 6:33 am

    #515847

    Mithrandir,

    Build yourself a measure using SUM (for illustrative purposes call it MySum) and another using COUNT (MyCount) in the conventional way.

     

    Then you need to build yourself a calculated member that belongs to the Measures dimension. There are 2 ways of doing this. 1, in an MDX query in which case your MDX query would look like this:

    WITH MEMBER Measures.MyAvg = 'Measures.MySum / Measures.MyCount'

    The other way is to define the calculated member in your cube using the Calculated Member Builder.

    Enjoy!

     

    Regards

     

    Jamie Thomson
    http://sqlblog.com/blogs/jamie_thomson

  • July 23, 2004 at 8:38 am

    #515912

    Great, that done the job (used culaculated member).

    I don't remembered to use old-style procedures to get desired data

    Thanks!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply