Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 Allocating Financial Transactions

Author  Topic 

megancamp
Starting Member

1 Post

Posted - 2012-03-23 : 11:51:28
I have a fact table with transaction amount. It also lists a part number, which determines the product family for me. For overhead transactions, I need to split each transaction into 2 entries based on % of sales for the period. I cannot think of a viable solution for this. Any suggestions?
   

- Advertisement -