Knowledge

Palo (OLAP database)

Source 📝

294: 173:
is suitable to handle complex data models for business management and statistics. Apart from multidimensional queries, data can also be written back and consolidated in real-time. To give rapid access to all data, Palo stores them in the memory during run time. The server is available as
270:
Palo Suite is a tightly integrated framework consisting of: Palo MOLAP Server, Palo ETL Server, Palo Web (Palo Spreadsheet - Connection, User, ETL, File and Report Manager), Palo for Excel, Palo Supervision Server and the Palo Client Libraries.
24: 274:
The Data in Palo database is stored as a cube in the Palo MOLAP server. The Palo Excel Add-In component is used as a service to communicate between the Excel and the Palo MOLAP Server.
212:
named PalOOCa (discontinued), with Java and web client also available from the JPalo project. Palo can also be integrated into other systems via its client libraries for
344: 436: 162:
software acting as the user interface. Beyond the multidimensional data concept, Palo enables multiple users to share one centralised data storage (
425:
In: Ronald Gleich, Andreas Klein (Hrsg.): Marketing- und Vertriebs-Controlling (Der Controlling-Berater Bd. 11). Haufe-Lexware, Freiburg 2010,
504: 430: 415: 299: 192:, Germany. The firm currently employs approximately 300 people. Kristian Raue's departure from Jedox was announced in June 2014. 233: 509: 244: 135: 213: 163: 45: 251:
interface which allows standard Excel pivot tables to serve as a client tool. Starting September 2011, Palo supports
252: 322: 104: 387: 221: 341: 317: 312: 151: 147: 179: 175: 108: 201: 87: 426: 411: 80: 240: 99: 71: 391: 348: 248: 205: 229: 209: 498: 454: 408:
Advanced Controlling mit Excel. Unternehmenssteuerung mit OLAP und PALO, m. CD-ROM.
188:
was founded by Kristian Raue in 2002 and developed by Jedox AG, a company HQed in
282:
Jedox announced only commercial licensing is available since 5.1 version (2015).
483: 159: 445:
Free Online Knowledgebase with full-text search and export as PDF functionality
289: 31: 23: 371: 479: 189: 170: 143: 460:- Open Source OLAP in the Retail Environment. John Hobson, February 2008 232:. It is fairly easy to communicate with Palo OLAP Server, since it uses 372:"Palo Open Source OLAP Server now supports MDX and Excel Pivot Tables" 262:
Palo also provides a web-based spreadsheet interface called Palo Web.
423:
Business Intelligence im Vertrieb auf Basis von Open-Source-Lösungen.
384: 155: 439:- Documentation to Palo (pdf) in the download section of the website 225: 307: 185: 139: 76: 488: 442: 256: 92: 217: 448: 359: 138:(OLAP) or multidimensional online analytical processing ( 472: 120: 115: 98: 86: 70: 44: 30: 8: 16: 208:. There is also an open source plug-in for 22: 15: 239:Starting in October 2008, Palo supports 334: 134:is a memory resident multidimensional ( 360:Tools, Consulting and Service for Palo 7: 300:Free and open-source software portal 342:Jedox announces founder's departure 51:2020.4 / November 26, 2020 14: 247:(MDX) APIs for connectivity, and 200:Palo for Excel is an open source 491:- Palo project page on ohloh.net 292: 234:representational state transfer 146:server and typically used as a 489:Palo project page on ohloh.net 421:Stefan Müller, Leif Mergener: 1: 505:Online analytical processing 451:Feedback/Feature Voting Tool 245:MultiDimensional eXpressions 136:online analytical processing 164:single version of the truth 526: 323:Comparison of OLAP servers 406:Bernd Held, Hartmut Erb: 66: 40: 21: 410:, Franzis, Poing 2006, 318:Performance management 510:Business intelligence 313:Business intelligence 148:business intelligence 53:; 3 years ago 480:Palo (OLAP database) 443:Online Knowledgebase 180:proprietary software 449:Feature Voting Tool 18: 437:Palo Documentation 401:Additional sources 390:2012-07-20 at the 347:2014-06-06 at the 431:978-3-648-00489-0 416:978-3-7723-7585-9 129: 128: 517: 476: 475: 473:Official website 394: 382: 376: 375: 368: 362: 357: 351: 339: 302: 297: 296: 295: 241:XML for Analysis 125: 122: 72:Operating system 61: 59: 54: 26: 19: 525: 524: 520: 519: 518: 516: 515: 514: 495: 494: 471: 470: 467: 403: 398: 397: 392:Wayback Machine 383: 379: 374:. 17 July 2009. 370: 369: 365: 358: 354: 349:Wayback Machine 340: 336: 331: 298: 293: 291: 288: 280: 268: 249:OLE DB for OLAP 206:Microsoft Excel 198: 119: 62: 57: 55: 52: 12: 11: 5: 523: 521: 513: 512: 507: 497: 496: 493: 492: 486: 477: 466: 465:External links 463: 462: 461: 452: 446: 440: 434: 419: 402: 399: 396: 395: 377: 363: 352: 333: 332: 330: 327: 326: 325: 320: 315: 310: 304: 303: 287: 284: 279: 276: 267: 264: 230:.NET Framework 210:OpenOffice.org 197: 194: 158:purposes with 127: 126: 117: 113: 112: 102: 96: 95: 90: 84: 83: 74: 68: 67: 64: 63: 50: 48: 46:Stable release 42: 41: 38: 37: 34: 28: 27: 13: 10: 9: 6: 4: 3: 2: 522: 511: 508: 506: 503: 502: 500: 490: 487: 485: 481: 478: 474: 469: 468: 464: 459: 457: 456:b-eye network 453: 450: 447: 444: 441: 438: 435: 433:. (in German) 432: 428: 424: 420: 417: 413: 409: 405: 404: 400: 393: 389: 386: 381: 378: 373: 367: 364: 361: 356: 353: 350: 346: 343: 338: 335: 328: 324: 321: 319: 316: 314: 311: 309: 306: 305: 301: 290: 285: 283: 277: 275: 272: 265: 263: 260: 258: 254: 250: 246: 242: 237: 235: 231: 227: 223: 219: 215: 211: 207: 203: 195: 193: 191: 187: 183: 181: 177: 172: 169:This type of 167: 165: 161: 157: 153: 149: 145: 141: 137: 133: 124: 118: 114: 110: 106: 103: 101: 97: 94: 91: 89: 85: 82: 78: 75: 73: 69: 65: 49: 47: 43: 39: 35: 33: 29: 25: 20: 455: 422: 407: 380: 366: 355: 337: 281: 273: 269: 266:Architecture 261: 238: 199: 184: 168: 131: 130: 105:GPL v2, LGPL 32:Developer(s) 484:SourceForge 418:(in German) 255:dialect of 176:open-source 160:spreadsheet 152:controlling 109:Proprietary 107:until v5.1 499:Categories 329:References 58:2020-11-26 278:Licensing 156:budgeting 150:tool for 111:from v5.1 388:Archived 385:Palo Web 345:Archived 286:See also 236:(REST). 196:Features 190:Freiburg 171:database 144:database 36:Jedox AG 458:article 202:plug-in 116:Website 100:License 81:Windows 56: ( 429:  414:  308:MOLAP 228:, or 186:Jedox 140:MOLAP 121:jedox 77:Linux 427:ISBN 412:ISBN 257:LINQ 243:and 214:Java 204:for 178:and 154:and 132:Palo 123:.com 93:OLAP 88:Type 17:Palo 482:on 253:SDX 226:C++ 218:PHP 166:). 142:)) 501:: 259:. 220:, 216:, 182:. 79:, 224:/ 222:C 60:)

Index


Developer(s)
Stable release
Operating system
Linux
Windows
Type
OLAP
License
GPL v2, LGPL
Proprietary
jedox.com
online analytical processing
MOLAP
database
business intelligence
controlling
budgeting
spreadsheet
single version of the truth
database
open-source
proprietary software
Jedox
Freiburg
plug-in
Microsoft Excel
OpenOffice.org
Java
PHP

Text is available under the Creative Commons Attribution-ShareAlike License. Additional terms may apply.