![sql server date functions sql server date functions](https://www.mssqltips.com/tipimages2/6958_sql-date-functions-sql-server-oracle-postgresql.002.png)
Panorama Software delegation meets with Microsoft Microsoft opens new team to build an OLAP product, codenamed Plato ( permutation of letters from OLAP) The key events in the history of Microsoft Analysis Services cover a period starting in 1996. The major change came to the model in the form of UDM - Unified Dimensional Model. It maintained backward compatibility on the API level: although applications written with OLE DB for OLAP and MDX continued to work, the architecture of the product was completely different. In 2005, Microsoft released the next generation of OLAP and data mining technology as Analysis Services 2005. Other features were dimension security, distinct count, connectivity over HTTP, session cubes, grouping levels, and many others.
![sql server date functions sql server date functions](https://static.javatpoint.com/sqlserver/images/sql-server-dateadd-function6.png)
Another feature was a greatly enhanced calculation engine with support for unary operators, custom rollups, and cell calculations. Major improvements included more flexibility in dimension design through support of parent child dimensions, changing dimensions, and virtual dimensions. Analysis Services 2000 was considered an evolutionary release, since it was built on the same architecture as OLAP Services and was therefore backward compatible with it.
![sql server date functions sql server date functions](https://www.sqlservergeeks.com/wp-content/uploads/ahmadosama/sql-function-to-extract-year-from-date/sql-function-to-extract-year-from-date.png)
It was renamed from "OLAP Services" due to the inclusion of data mining services. In 2000, Microsoft released Analysis Services 2000. It could work in client-server mode or offline mode with local cube files. OLAP Services supported MOLAP, ROLAP, and HOLAP architectures, and it used OLE DB for OLAP as the client access API and MDX as a query language. Just over two years later, in 1998, Microsoft released OLAP Services as part of SQL Server 7. In 1996, Microsoft began its foray into the OLAP Server business by acquiring the OLAP software technology from Canada-based Panorama Software.