One TO Many between fact table to dimention

[meravsha]

Hi,
I hope you'll anderstand my problem.
I craeted a fact table that observe Status of orders. mean that each order contain a 4 status (Draft, Approval , Action, Final) ===> 4 rows in fact table for each order.
also I need to show orderPrice and customerName.

my problem is how can I calculate price that multiplied in each Order rows?
same in customers?
Thanks.

 

[MDXer]

Use a calculated cell that can count the total number of records for the order in question for that product and then divide by your price by the number of records.

Shoot Me! Shoot Me NOW!!!
- Daffy Duck

 

[meravsha]

thanks for your answer.
1. How can I declare counting by number of oreder records?
2. How can I handel with fields like CustomerName and orderDate (also appear more then one?

 

[Flybridge]

Another way could be to create a dimension over order status, then filter on a particular order type. For a total for all orders, presumably all orders exist as a draft so using that would show a total of all orders.


'The world isn't round - it's bent!' Spike Milligan