Re: Count of number of occurences of member

#1

You can add another measure and its value will be 1 in every record,

then you can use that as a measure in your cube. and its expression

will be SUM(that measure)

Thanks

Asim Naveed

--
Posted via http://dbforums.com

#2

Is this a count of fact table occurences or dimension table occurences?

tom @ the domain below
www.tomchester.net

"devnoronha" <member33654 (AT) dbforums (DOT) com> wrote

Quote:

Hi ,

What is the function which returns the count of the number of
occurences of a member ? If the follwoing is the table :

1 John 200

2 John 300

3 Pete 100

4 Ralph 100

5 Pete 100

6 Pete 100

I've created the cube which shows me the 3 sales guys names and the
Total Sales by each :

John 500

Pete 300

Ralph 100

What I want is to also display the number of sales . The cube should
display as follows :

Name Tot Sales Number of Units

----------------------------------------------------------

John 500 2

Pete 300 3

Ralph 100 1

How do i crete the calculated member for 'Number of Units' ???

--
Dev Noronha

Posted via http://dbforums.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Count of number of occurences of member

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

Re: Count of number of occurences of member - 10-10-2003 , 04:00 PM

Re: Count of number of occurences of member - 10-14-2003 , 07:58 PM