Dimensional Model

I am in the process of designing a Booking, Billing and Backlog
datamart. My backend is going to be SQL Server 2K. Data source is
Baan ERP system. The transaction level I have to populate the
datamart is at sales order line level.
My problem is that the data model I have come up with is more
relational than dimensional. Here is what I have got so far.
Orders
Order Detail
Customer
Products
Countries
Regions
Employees
Other way of sourcing the data would be to write one big query from
ERP and then do the dimensional model but that would slow down the
data retrieval. I would be grateful if any you can share your
experience with this sort of a datamart.
Thanks
AtherWell, you have to take the approach of dimensional modelling to make it
work. http://www.ralphkimball.com has some good articles to get you started,
also I would recommend a book "Data Wareshousing TookKit" by the same author
has some good examples that you can related to.
Pramod
"Ather Mian" <athermian@.yahoo.com> wrote in message
news:6ed9e09e.0403310515.4c0e0a79@.posting.google.com...
> I am in the process of designing a Booking, Billing and Backlog
> datamart. My backend is going to be SQL Server 2K. Data source is
> Baan ERP system. The transaction level I have to populate the
> datamart is at sales order line level.
> My problem is that the data model I have come up with is more
> relational than dimensional. Here is what I have got so far.
> Orders
> Order Detail
> Customer
> Products
> Countries
> Regions
> Employees
> Other way of sourcing the data would be to write one big query from
> ERP and then do the dimensional model but that would slow down the
> data retrieval. I would be grateful if any you can share your
> experience with this sort of a datamart.
> Thanks
> Ather