On the base of discussing the technology of data warehousing and its decision supports tools-the On-line Analytical Processing (OLAP) in detail, it is applied to the oil and gas auxiliary decision support. Accordingly the data of multi-dimensions are successfully analysed and the accuracy and flexibility of auxiliary decision support are improved. All of this gives the reliable information for the success of decision support. And this article, presents a reference solution to this kind of problem.