Palo c Library Bindings for Pascal lazarus / 16-Databases ---------------------------------------------------------------------- HIGH-Zen · 2011-05-24 00:07 Palo c Library Bindings for Pascal 24.05.2011 This package is a Pascal language translation of the Palo library header files (*.h) (Palo version 3.1) Palo OLAP Server is a multidimensional in-memory OLAP Server. http://hotfile.com/dl/118746489/ec8c0bc/PALO_3.1_PAS_SDK.rar.html Edit: https://rapidshare.com/files/2752134067/PALO_3.1_PAS_SDK.7z ---------------------------------------------------------------------- HIGH-Zen · 2011-09-15 08:10 2 units: 1. palocomm.pas PaloConnection class (main class to use for communication with the Palo server) procedures: -GetData -SetData -Ping -DimensionAddOrUpdateDimElement -DimElementDelete -DimElementMove -DimensionListElements -DimElementListConsolidated -ElementInformation 2. commhelper.pas CommHelperBasic class procedure: - GetDimElementInfoTreeList: TList http://hotfile.com/dl/129842937/adb846f/PALO_3.1_PAS_SDK_update.zip.ht ml https://rapidshare.com/files/1577801051/PALO_3.1_PAS_SDK_update.zip ---------------------------------------------------------------------- xinyiman · 2011-09-15 11:40 Hello I do not know the potential PALO, describe me a moment? The library is cross-platform? ---------------------------------------------------------------------- HIGH-Zen · 2011-09-15 12:44 Yes, it is cross-platform. Server can run on Win or Linux, so client too can be used on Win or Linux. QuoteYou will avoid the well known spreadsheet hell due to Palo’s central data storage logic.. Palo Client Addin for Excel, Addin for OpenOffice and Java Client are available. C, .Net or Java library can be used to write own client. I use C library with Free Pascal/Lazarus and KGrid 1.7. QuotePalo Palo is a memory resident multidimensional (OLAP or MOLAP) database server and typically used as a Business Intelligence tool for Controlling and Budgeting purposes with Spreadsheet software acting as the user interface. Beyond the multidimensional data concept, Palo enables multiple users to share one centralised data storage ("Single version of the truth"). This type of database is suitable to handle complex data models for business management and statistics. Apart from multidimensional queries, data can also be written back and consolidated real-time. In order to give rapid access to all data, Palo stores them in the memory during run time. The server is available as Open Source and Closed Source. http://www.jedox.com/en/home/overview.html ---------------------------------------------------------------------- xinyiman · 2011-09-15 13:22 So just download and install pole as a server, then download and install the library that you suggested above and in theory we should be able to use OLAP cubes within applications lazarus? it? ---------------------------------------------------------------------- HIGH-Zen · 2011-09-15 13:27 Exactly. ---------------------------------------------------------------------- xinyiman · 2011-09-15 13:30 Beautifull. Is possible see a little example code?! ---------------------------------------------------------------------- xinyiman · 2011-09-15 13:36 palo from where you download the server? ---------------------------------------------------------------------- HIGH-Zen · 2011-09-15 14:06 Sensitive data scrambled in example. See attachment. Archive Palo 3.1 Community Edition download http://www.jedox.com/en/downloads/archive/download.html EDIT: A better approach is to use Palo Web API in the similar way as Python Palo Interface http://www.jedox.com/community/palo- forum/index.php?page=Thread&threadID=1420. e.g. Code: [Select]function TPaloDimension.GetAttributeCubeName: string; var   CMD: string;   Url: string;   HTML: string; begin   if Length(AttrCubeID) <= 0 then   begin     GetAttributeCubeName := '';     Exit;   end;   CMD := 'cube/info';   HTML := '';   Params.Values['database'] := Database.ID;   Params.Values['cube'] := AttrCubeID;   Params.Values['sid'] := Database.server.Sid;   Url := Database.server.ServerRoot + CMD;   HTML := Database.server.IdHTTP1.Post(Url, Params, Enc, Enc, Enc);   strfns.ExplodeStr(HTML, ';', Res);   GetAttributeCubeName := StripFirstNLastChar(Res.Strings[1]);   Params.Clear;   Res.Clear; end; function TPaloCube.GetValue(Coordinates: TStringList): string; var   CMD: string;   Url: string;   HTML: string;   i, j: integer; begin   CMD := 'cell/value';   HTML := '';   Params.Values['database'] := Database.ID;   Params.Values['cube'] := ID;   Params.Values['path'] := JoinStr(GetElementsID(Coordinates), ',', False);   Params.Values['sid'] := Database.server.Sid;   Url := Database.server.ServerRoot + CMD;   HTML := Database.server.IdHTTP1.Post(Url, Params, Enc, Enc, Enc);   strfns.ExplodeStr(HTML, ';', Res);   // check for ';' in Value field of cell/value result   if Res.Count > 4 then   begin     i := Res.Count - 4;     for j := 0 to i - 1 do     begin       Res.Strings[2] := Res.Strings[2] + ';' + Res.Strings[j + 3];     end;   end;   // if it is string   if (Length(Res.Strings[2]) > 2) and (Res.Strings[2][1] = '"') then   begin     Res.Strings[2] := StripFirstNLastChar(Res.Strings[2]);     Res.Strings[2] := StringReplace(Res.Strings[2], '""', '"', [rfReplaceAll]);   end;   GetValue := Res.Strings[2];   Params.Clear;   Res.Clear; end; ---------------------------------------------------------------------- php_Teufel · 2013-01-10 11:11 Is this PALO SDK still available? I'm very interested in this. regards Volker ---------------------------------------------------------------------- HIGH-Zen · 2013-04-27 12:18 PM. ---------------------------------------------------------------------- HIGH-Zen · 2013-12-29 04:50 Update 2013/2014 Palo Web API was VERY slow so I soon reverted back to Palo C/Pascal API. Now it works lightning fast. Palo 3.1 Pascal SDK 2013 Palo 3.1 Pascal SDK 2013.7z 24.05.2011 Updated 29.12.2013 And take a look at these real-life Palo OLAP apps. http://youtu.be/W10MT4hVmUI ---------------------------------------------------------------------- HIGH-Zen · 2023-04-18 07:06 Update 18.04.2023! You can get commercial Palo: https://www.jedox.com/en/ Palo forum now is gone.  Source available: https://sourceforge.net/projects/palo/ If you need pascal bindings and/or Palo binaries write private message.