Modeling a Sales Order to Billing to Shipping consolidated data model

Hello,

This situation is arising based out of queries. We know that facts do not have relationships to each other, other than in queries and only along conforming dimensions. I want to continue along these lines.

Basically, we have separate data models for Sales Orders, Billing and Shipping events for our business.

The queries have a most common requirement. It is:- How a Sales Order gets billed and how it is shipped? Right now, we have separate stars. The reports are using a temporary space to serve as a buffer and continue processing to see the transition.

We now have to build a data model which will have all metrics from Sales, Billing and Shipping along with the common dimensions among these stars.

I need some ideas on how this can be modeled. Should it be a single star schema or are there any other ideas?

Thanks,
Sreekanth

This is on Teradata 13.

Two options we suggested were:-
1. Use Teradata temporary tables. But, the reporting tool was BO and BO was not in favor of working around with temporary tables.
2. Create a table with all the metrics from Billing, Sales and Shipping and then bring in only the common dimensions across.

Any suggestions are welcome.

Thanks,
Sreekanth