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.
Microsoft Olap server
- jim wood
- Site Admin
- Posts: 3952
- 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
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.)
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
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
-
- Posts: 2
- Joined: Fri Oct 02, 2009 6:47 am
- OLAP Product: microsoft
- Version: ---
- Excel Version: 2007
Re: Microsoft Olap server
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.
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.
-
- 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
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.