otmfaqForumsBlogsRegister
FAQMembers ListCalendarToday's PostsSearch


 Subscribe Blogs:RSS
 Subscribe Forums:RSS
OTMFAQ Home
OTMFAQ Blogs
OTMFAQ Forums
OTMFAQ Tutorials

OTM SIG
MavenWire


Email List Archive Archive of the OTM SIG email list.

Tags:

Closed Thread
 
Submit Tools LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old January 19th, 2008, 14:23
Quint Dick
 
Posts: n/a
[SOLVED] Data modeling

We are looking for a modeling solution that we can use with OTM.
Basically, we are trying to find a solution where we could take 3 to 6
months of a customer's data and show them how a system like OTM could
provide them more consolidation opportunities for their LTL freight. We
would also like to be able to run it with different pricing scenarios
reflecting LTL vs TL rates. We would also like to be able to do what-if
scenarios where we could analyze the impact of pricing changes for both
buy and sell rates.



It has been suggested that we use a TEST system and import CSV files.
This would represent between 25 to 30 files. Modifying pricing would
result in the need to import additional CSV files. We would like to see
if we can do this without having to involve a DBA skill set for days or
weeks at a time.



If anyone has any suggestions, I would appreciate your input.



Richard M. Quint

Information Technology Manager

MBX Logistics, L.L.C.

7699 Commerce Center Drive

Orlando, FL 32819

321-354-2074 direct

407-492-5039 cell

dquint (AT) mbxlogistis (DOT) com








__________________________________________________ _____________________

This message and any files transmitted with it may contain confidential and/or legally privileged material. The information is intended only for the use of the intended recipient. If you are not the intended recipient, any disclosure, copying, distribution, or taking of any action in reliance on the contents of this information is strictly prohibited. If you received this message in error, please contact the sender and delete the message.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
  #2 (permalink)  
Old January 29th, 2008, 20:09
Senior Member and Blogger
 
Join Date: May 2007
Posts: 170
Thanks: 4
Thanked 31 Times in 31 Posts
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 2
bmj_23 will become famous soon enough
Re: Data modeling

Hi Richard - we have used TMS modellling type applications from other software vendors to do this type of work in the past. They have allowed us to import data from Excel / Access etc and run very effective optimization models to study the effect of TL v LTL etc.

It can probably be done in OTM, but as you have highlighted, it will take a lot of effort and data loading / manipulation via CSV files.

Send me a PM if you want more details.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Closed Thread



Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
[SOLVED] RE: Data modeling Quint Dick Email List Archive 0 January 30th, 2008 07:16



All times are GMT. The time now is 19:19.
Copyright © 2008, Open Book Solutions LLC. All rights reserved.

Sponsored by MavenWire - MavenWire.com


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36