Ultimately DTS may or may not be the right tool for your needs. The decision as to the best way to manage the flow and transformation of data in your application is but one of many that CRA can help you to make. This phase is one of the most time consuming and critical in the path to developing an OLAP database. You can leverage our experience to get to an optimal solution in as little time as possible. With MDX, an OLAP cube can become more than just a repository for data, but also a powerful modeling tool.
Most users are familiar with model building in two dimensions using spreadsheets.
With MDX calculations that incorporate operations from multiplication and division to financial and statistical functions built right into the OLAP database, all end-users can get consistent results from a single source. The learning curve for MDX is acknowledged to be very steep. CRA, with its history of model building using other OLAP products, and deep technical and programming experience, is already ahead of the game in scaling this curve, and can help you to do so quickly as well. Learning MDX is a technical challenge. Learning how to apply it to build business models adds another layer to the challenge of deploying it to its full potential.