Microsoft Olap server

Post Reply
itsmeiza
Posts: 2
Joined: Fri Oct 02, 2009 6:47 am
OLAP Product: microsoft
Version: ---
Excel Version: 2007

Microsoft Olap server

Post by itsmeiza »

hi all,

I'm newbie here...lots that i need to learn about Microsoft Olap server. Thus my question is:

1. Is Microsoft OLAP server same as Microsoft SQL server?
2. If not, can Microsoft SQL server use as OLAP server?
3. What is relationship between Pivot Table and OLAP?
4. Is there any OLAP version from open source?

Pls help me as I need more information about OLAP from experts. ;)
User avatar
jim wood
Site Admin
Posts: 3951
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Re: Microsoft Olap server

Post by jim wood »

1. They behave in a different fashion but they run on the same host service and the OLAP data is based on SQL tables.
2. SQL is DBO compliant and can interact with any tool that uses MDX.
3. A pivot table is a way of viewing data in excel. Some data viewers in OLAP tools look similar.
4. There is a tool called PALO that is open source.
To find out more go to the olapedia site. (Linked towards the top of the forum on the right hand side.)
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
itsmeiza
Posts: 2
Joined: Fri Oct 02, 2009 6:47 am
OLAP Product: microsoft
Version: ---
Excel Version: 2007

Re: Microsoft Olap server

Post by itsmeiza »

Hi Jim Wood..

Thanks for the reply but I still confuse about your answer for question 1.
Your answer: They behave in a different fashion but they run on the same host service and the OLAP data is based on SQL tables.

I still don't get it. If you don't mind, I really loves if you can explain further on how they behave.
Marcus Scherer
Community Contributor
Posts: 126
Joined: Sun Jun 29, 2008 9:33 am
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2016
Location: Karlsruhe

Re: Microsoft Olap server

Post by Marcus Scherer »

The Microsoft OLAP Server is called Microsoft SQL Server Analysis Services (SSAS). With "SQL Server" the relational database component is meant,"SQL tables" how Jim called it. It can serve as the data source for the OLAP server.
Post Reply