Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

One TO Many between fact table to dimention

Status
Not open for further replies.

meravsha

Programmer
Jul 27, 2001
21
IL
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.
 
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
 
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?


 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top