Results 1 to 3 of 3

Thread: How to create a measure with count function

  1. #1
    Join Date
    Jan 2005
    Posts
    1

    How to create a measure with count function

    Hi,
    i created a cube that has 2 measures. I created the measures by selecting the columns from my fact table, but the function that applied in the measures was the sum function. I need to apply the count function in my measure. How can i do that?

    Thanks in advance.

  2. #2
    Join Date
    Dec 2003
    Posts
    140
    Hi,

    1) Right click on the cube

    2) Select Edit

    3) In the resulting window, click on the measure for which you want to apply the COUNT function (instead of SUM)

    4) In the Properties Pane, select COUNT as the Aggregate Function

    5) Don't forget to Save the changes

    Hope this helps.

  3. #3
    Join Date
    Jun 2004
    Location
    Atlanta and Manhattan
    Posts
    607
    You might also want to consider my article re: DISTINCT COUNTS at:

    http://www.databasejournal.com/featu...le.php/3454931

    In addition, I have articles in the pipleline re: optimization of counts - if that is not a consideration in the current instance (which sounds pretty basic), then perhaps it will be useful in a more complex need down the road.

    Good Luck.

    Bill

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •