Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

MDX Weighted Counts

Go down

MDX Weighted Counts Empty MDX Weighted Counts

Post  cjrinpdx Fri Jul 13, 2012 11: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 : 51
Join date : 2011-07-14
Location : Portland, OR

Back to top Go down

Back to top


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