What is OLAP and what does it have to do with a TPACC DashBoard?
On-Line Analytical Processing (OLAP) is a way to organize large business databases. OLAP databases are organized to fit the way you retrieve and analyze data so that it’s easier to create the reports you need. OLAP databases are designed to speed up the retrieval of data. TPACC DashBoards use OLAP because OLAP servers compute the summarized values and less data needs to be sent to the program when you create or change a report. This approach lets you work with much larger amounts of source data than you could if the data were organized in a traditional database, where Excel must retrieve all the individual records and then calculate the summarized values. They both work, but differently. if we could be of assistance. * Microsoft is a registered trade mark of Microsoft Corporation.
