Clientes Web OLAP baseados no MS Analysis Services: uma análise comparativa entre soluções Fat-Client e Thin-Client

Abstract

This paper begins with a comparative analysis, in terms of functionalities and limitations, between the Fat-Client and Thin-Client OLAP Solutions. Later, the paper analyzes some, Web-based, OLAP Client Solutions supported by Analysis Services: one Fat-Client and three Thin-Clients. The Fat-Client OLAP Solution analyzed is based on OWC, PivotTable Services and the .NET Platform. One of the Thin-Client OLAP Solution is based on a MS SQL Server 2000Resource Kit tool, the Analysis Services Thin Web ClientBrowser. Other of the Thin-Client OLAP Solution is basedon the use of the OWC, as an in-memory object, on theServer side. The last Thin-Client OLAP Solution analyzed isXMLA based. Related to this last Solution, the paper introduces and analyzes, in detail, the XMLA, as aMultidimensional Data Source Access Mechanism, coveringits Methods and its implementation on Analysis Services.