cubefunctions

Imagine you have a db with [user], [customer] and [number of receipts]. Within every receipt you have both a username (cashier) and a customer name. I would like to use cuberankedmember to find top 10 users according to number of receipts where user name is equal to customer name any suggestions?

I am trying to get at some specific information in a cube. The structure is Code > vendor > product > source in the field I'm cubesetting. If I were looking for all orders by a particular vendor, I'd do something like {[Code].[Vendor].[VendorX]} However, I'm actually looking for all orders...

I'm not sure if this is possible, but does anyone have any recommendations on how to improve calculation speed of cube functions? I have a workbook which builds a report and thus has a lot of cells which are basically just cubevalue functions. It takes on average 5 minutes if I make a change...