Modeling a Sales Order to Billing to Shipping consolidated data model

View previous topic View next topic Go down

Modeling a Sales Order to Billing to Shipping consolidated data model

Post  sreekanth573 on Tue Jul 17, 2012 10:44 am

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

sreekanth573

Posts : 3
Join date : 2010-11-08
Location : Dublin

View user profile

Back to top Go down

Options being tried now

Post  sreekanth573 on Tue Jul 17, 2012 10:47 am

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

sreekanth573

Posts : 3
Join date : 2010-11-08
Location : Dublin

View user profile

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum