Excel pivot tables are extremely powerful OLAP browsers. They allow you to analyze impossible amounts of data in a familiar environment, the most powerful analytical tool in Excel. Reporting solutions built on OLAP data sources are easy to build with pivot tables, and are typically more efficient than those that are built using transactional databases. OLAP-based pivot tables run on MDX queries. It's worth your time to understand MDX and find creative ways to use the MDX behind pivot tables to improve your processes. ADO MD offers some automated ways to do things that are difficult to do using the pivot table interface in Excel. ADO MD allows you to investigate your OLAP cube's schema, as well as automate the creation of offline OLAP cubes.

0 0

Post a comment