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 » Fri Oct 02, 2009 7:10 am

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: 3522
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: TM1 10.2.2
Excel Version: 2007
Location: 1639 Route 10, Suite 107, Parsippany, NJ, USA
Contact:

Re: Microsoft Olap server

Post by jim wood » Fri Oct 02, 2009 7:24 am

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.
Application Consulting Group (ACG) TM1 Consulting
OS: Windows 7 64-bit. TM1 Version: 10.1.1

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 » Tue Oct 06, 2009 2:33 pm

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: 125
Joined: Sun Jun 29, 2008 9:33 am
OLAP Product: TM1
Version: 9.5 10.1 10.2
Excel Version: 2007
Location: Karlsruhe

Re: Microsoft Olap server

Post by Marcus Scherer » Wed Oct 07, 2009 6:40 am

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