MDX Weighted Counts

View previous topic View next topic Go down

MDX Weighted Counts

Post  cjrinpdx on Fri Jul 13, 2012 8:57 am

I have a simple fact table that is used to count completed orders. The fact table uses conformed dimensions Employee and OrderType. I want to create a calculated measure that will weigh the completed order count for each employee. The weight is determined by the order type (i.e. new = 1.5, change = .75, cancel = .5). I want the calculation to be dynamic, so I was thinking of storing the weight in the dimension table, then using the weight in the MDX expression. Will this work? Or, maybe there is a better approach. Thanks



cjrinpdx

Posts: 50
Join date: 2011-07-14
Location: Portland, OR

View user profile

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

Permissions in this forum:
You cannot reply to topics in this forum