 | |
#1
 
| |||
| |||
|
OLAP servers -
12-21-2004
, 05:39 AM
#2
| |||
| |||
|
|
Hi There! If anybody could give me some information about OLAP engines besides Oracle, SQL Server, SAS and Sybase products? I'm creating client application in Excel and I'd like to get data from cubes using PovotTable so engine should have OLE DB for OLAP drivres. |
(which both use MDX) include Hyperion Essbase, SAP BW and Applix TM1.
#3
| |||
| |||
|
|
"sajdor" <slawomis (AT) gazeta (DOT) pl> wrote in message news:cq922m$j1k$1 (AT) portraits (DOT) wsisiz.edu.pl Hi There! If anybody could give me some information about OLAP engines besides Oracle, SQL Server, SAS and Sybase products? I'm creating client application in Excel and I'd like to get data from cubes using PovotTable so engine should have OLE DB for OLAP drivres. Other OLAP servers that support OLE DB for OLAP or XML for Analysis (which both use MDX) include Hyperion Essbase, SAP BW and Applix TM1. |
#4
| |||
| |||
|
|
"sajdor" == sajdor <slawomis (AT) gazeta (DOT) pl> writes: |
sajdor> Access database and Excel client application. I need some
sajdor> engine to create, implement and process cubes and then
sajdor> produce some reports. What do you think about that issue?
http://sourceforge.net/projects/mondrian
Yours - Billy
================================================== ==========
William Goedicke goedicke (AT) goedsole (DOT) com
Cell 617-510-7244 http://www.goedsole.com:8080
================================================== ==========
Lest we forget:
The devil's in the details
#5
| |||
| |||
|
|
Hmm... I think that I need something cheaper;-) I have Access database and Excel client application. I need some engine to create, implement and process cubes and then produce some reports. What do you think about that issue? Regards sajdor "Nigel Pendse" <nigelp.nospam (AT) compuserve (DOT) com> wrote in message news:1103633013.10094.0 (AT) echo (DOT) uk.clara.net... "sajdor" <slawomis (AT) gazeta (DOT) pl> wrote in message news:cq922m$j1k$1 (AT) portraits (DOT) wsisiz.edu.pl Hi There! If anybody could give me some information about OLAP engines besides Oracle, SQL Server, SAS and Sybase products? I'm creating client application in Excel and I'd like to get data from cubes using PovotTable so engine should have OLE DB for OLAP drivres. Other OLAP servers that support OLE DB for OLAP or XML for Analysis (which both use MDX) include Hyperion Essbase, SAP BW and Applix TM1. |
#6
| |||
| |||
|
|
Realistically, you won't find a full-function OLAP server that's cheaper than Analysis Services Standard Edition. If you can't afford that, why not just use the relational PivotTables in Excel? "sajdor" <slawomis (AT) gazeta (DOT) pl> wrote in message news:cq9a1b$tq1$1 (AT) portraits (DOT) wsisiz.edu.pl Hmm... I think that I need something cheaper;-) I have Access database and Excel client application. I need some engine to create, implement and process cubes and then produce some reports. What do you think about that issue? Regards sajdor "Nigel Pendse" <nigelp.nospam (AT) compuserve (DOT) com> wrote in message news:1103633013.10094.0 (AT) echo (DOT) uk.clara.net... "sajdor" <slawomis (AT) gazeta (DOT) pl> wrote in message news:cq922m$j1k$1 (AT) portraits (DOT) wsisiz.edu.pl Hi There! If anybody could give me some information about OLAP engines besides Oracle, SQL Server, SAS and Sybase products? I'm creating client application in Excel and I'd like to get data from cubes using PovotTable so engine should have OLE DB for OLAP drivres. Other OLAP servers that support OLE DB for OLAP or XML for Analysis (which both use MDX) include Hyperion Essbase, SAP BW and Applix TM1. |
#7
| |||
| |||
|
|
Is it possible to process Access database using PivotTable enhancement in Excel like any multidimensional cube? Do I need OLAP engine or not? What are differences? Regards and Happy New Year! sajdor "Nigel Pendse" <nigelp.nospam (AT) compuserve (DOT) com> wrote in message news:1103638918.13169.0 (AT) echo (DOT) uk.clara.net... Realistically, you won't find a full-function OLAP server that's cheaper than Analysis Services Standard Edition. If you can't afford that, why not just use the relational PivotTables in Excel? "sajdor" <slawomis (AT) gazeta (DOT) pl> wrote in message news:cq9a1b$tq1$1 (AT) portraits (DOT) wsisiz.edu.pl Hmm... I think that I need something cheaper;-) I have Access database and Excel client application. I need some engine to create, implement and process cubes and then produce some reports. What do you think about that issue? Regards sajdor "Nigel Pendse" <nigelp.nospam (AT) compuserve (DOT) com> wrote in message news:1103633013.10094.0 (AT) echo (DOT) uk.clara.net... "sajdor" <slawomis (AT) gazeta (DOT) pl> wrote in message news:cq922m$j1k$1 (AT) portraits (DOT) wsisiz.edu.pl Hi There! If anybody could give me some information about OLAP engines besides Oracle, SQL Server, SAS and Sybase products? I'm creating client application in Excel and I'd like to get data from cubes using PovotTable so engine should have OLE DB for OLAP drivres. Other OLAP servers that support OLE DB for OLAP or XML for Analysis (which both use MDX) include Hyperion Essbase, SAP BW and Applix TM1. |
#8
| |||
| |||
|
|
Excel has basic PivotTables for any relational database. There are no cubes involved and therefore you don't get full cube functionality like aggregations, MDX calculations, multidimensional security, etc, but you can do pivots. "sajdor" <slawomis (AT) gazeta (DOT) pl> wrote in message news:cq9c84$16c$1 (AT) portraits (DOT) wsisiz.edu.pl Is it possible to process Access database using PivotTable enhancement in Excel like any multidimensional cube? Do I need OLAP engine or not? What are differences? Regards and Happy New Year! sajdor "Nigel Pendse" <nigelp.nospam (AT) compuserve (DOT) com> wrote in message news:1103638918.13169.0 (AT) echo (DOT) uk.clara.net... Realistically, you won't find a full-function OLAP server that's cheaper than Analysis Services Standard Edition. If you can't afford that, why not just use the relational PivotTables in Excel? "sajdor" <slawomis (AT) gazeta (DOT) pl> wrote in message news:cq9a1b$tq1$1 (AT) portraits (DOT) wsisiz.edu.pl Hmm... I think that I need something cheaper;-) I have Access database and Excel client application. I need some engine to create, implement and process cubes and then produce some reports. What do you think about that issue? Regards sajdor "Nigel Pendse" <nigelp.nospam (AT) compuserve (DOT) com> wrote in message news:1103633013.10094.0 (AT) echo (DOT) uk.clara.net... "sajdor" <slawomis (AT) gazeta (DOT) pl> wrote in message news:cq922m$j1k$1 (AT) portraits (DOT) wsisiz.edu.pl Hi There! If anybody could give me some information about OLAP engines besides Oracle, SQL Server, SAS and Sybase products? I'm creating client application in Excel and I'd like to get data from cubes using PovotTable so engine should have OLE DB for OLAP drivres. Other OLAP servers that support OLE DB for OLAP or XML for Analysis (which both use MDX) include Hyperion Essbase, SAP BW and Applix TM1. |
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.