Re: sum using member property

#1

Look at Russ Whitney's SQL Server Magazine article on Member Properties from
last August:
http://www.winnetmag.com/Article/Art...384/39384.html

It is one of my favorites. If he doesn't do something like this directly,
I'd bet that you can derive a hint on how to do it from one of his examples.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"MT" <MT (AT) discussions (DOT) microsoft.com> wrote

Quote:

I have a customer parent-child dimension with a sales rep
as a member property (the sales rep is a column of the
customer dimension table).
I also have defined a sales rep dimension.

The fact table contains the measure sales.

I would like to define a calculated member that allows me
to see all sales for which the sales rep is reponsible.
In other words, not just his direct sales but those of all customers
below his.

Any help would be greatly appreciated!
Mario

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

Re: sum using member property

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

Re: sum using member property - 07-21-2004 , 01:14 PM