Count Number of Members in Dimesion

#1

I have a demension called Project which incldues a attribute hierarcy called
employee. I need a calcualted member that count the number of projects for a
given employee from the dimension.

#2

Try and add the project as a measure.Make the aggregation as count

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

Count Number of Members in Dimesion

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

Count Number of Members in Dimesion - 10-28-2005 , 05:09 AM

Re: Count Number of Members in Dimesion - 10-28-2005 , 07:54 AM