Company Competences Technologies Projects Contact  
arcplan | Databases | OLAP | SAP | MIS Alea 
Analysis Services
Oracle Express

Microsoft® SQL ServerTM 2000 Analysis Services

Microsoft® Analysis Services is the OLAP component of Microsoft SQL ServerTM 2000 .The SQL ServerTM 2000 is based on SQL Server 7.0 and provides additional web-and e-commerce-functionalities

The Analysis Services component includes a middletier server that enables the user to generate highly developed web-based analyses and queries to process high volumes with excellent performance.

The SQL ServerTM Analysis 2000 Services is completely integrated in the Microsoft® Management Console and - in contrast to other OLAP databases - supports both relational and multidimensional databases for storing the OLAP aggregations. It also allows the administrator to change between the databases at any time.



Microsoft® SQL ServerTM 2000 features

  • Easy to use
  • Full support of XML-and Internet standards
  • Pivot Table ® - Service
  • Direct access to data cubes via Internet·
  • Direct access to hierarchical information (dimensions)
  • Efficent, flexible, web-based analyses
  • Display of dimensions in special graphical navigation objects (e.g.dropdown menu, vertical and horizontal hierarchy container)
  • Dynamic generation of MDX statements (multidimen-sional expressions)
  • Highly scalable architecture
  • Read and write access
  • User-customizable feature set
  • Intelligent client/server data management
  • Supports „dimension member properties “
  • Access via OLE DB for OLAP
  • Access under Windows NT, Windows 2000,98,95
  • Cost-efficient by providing an integrated environment for developing and using a data warehouse (low cost of ownership)
GIS mbH
Rotenbergstraße 8
70190 Stuttgart
fon 0711.460517190
fax 0711.460517199