MDX Weighted Counts
Page 1 of 1 • Share •
MDX Weighted Counts
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
Similar topics» MDX Weighted Counts
» Weighted Clothing
» Changing Post Counts - 2
» Changing Post Counts
» Example of a business process with more than 1 fact table
» Weighted Clothing
» Changing Post Counts - 2
» Changing Post Counts
» Example of a business process with more than 1 fact table
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum