Abstract: This article proposed a solution of Railway Passenger Marketing aided Decision System, introduced several key technologies, such as Kettle based ETL design, report cube design, OLAP analysis, report making and custom personalized report control, and so on. This solution could overcome the shortage of closing codes and hardness of custom control, save software cost, and lead to a wide used prospect. Otherwise, some problems should be settled in the future, such as a large amount of coding work, lack of documents, insufficient safety test and parallel performance test.