Hi @ all,

the formular
palo.eadd does not work properly, for example:

Database:
localhost/test

Dimension: KTR

Now I want to import
the following:

Basis-Element: 2500012312
Next Level: 25000123
Next Level: 25000

Formular1:
=PALO.EADD(localhost/test;KTR;"n";2500012312;25000123;1)

Formular
2: =PALO.EADD(localhost/test;KTR;"n";25000123;25000;1)

Now in the Modeller
I get the Elements „2500012312“ and „25000123“, but not
„25000“ and not the hyrachie 25000 → 25000123 → 2500012312

Any hint?

I work with PalOOCa
2.0.2 and Palo Server 3.1; LibreOffice 3.4.7.2 and Windows 7

Btw: The „newer“
Proclos-AddIn is useless because the „Import“-Funktion
(Datenimport) is gone and so Palo.Eadd and Setdata doesn´t work at
all. So Palo-Calc Add-In 5.xxx IS NOT the descendant of PalOOCa, it´s a
great step backwards!

Thx 4 help!!!

No hint?

Maybe someone had tried the palo.eadd formular including the hyrachies successfully?
So that I know that it is not a general failure of the Calc-AddIn...

Thx!

And there´s another thing:

In PalOOCa 5.2.1 (as well as in Excel AddIn 3.1) there´s one more field in the palo.eadd formular:
After "Konsolidierungsfaktor - consolidation factor (?)" there is the option "Löschen - delete".

So does anyone know when the formular palo.eadd was extended? Maybe that´s the reason why it does
not work in Version 2.0.2? Is there anywhere a download-link to version 2.0.3, perhaps it´s fixed there?

And if the eadd-formular works in 5.2.1, how can I do the import when there is no longer the menu integrated to start it???? (As well as running the setdata import?).

I work with Palo Server 3.1 64bit for Linux because it´s fast enough at least for a 100 million of datarecords and easy to install under Linux (which could handle that data --> no windows server is required, Windows [7] Pro can´t deal with so many datarecords in Palo-Server because it cant start the palo-server --> time limit), so there´s no need for another jedox server (5.x), only for a Calc-Addin-
functionality like Palo for Excel!!!

Well, if - however - the setdata and eadd functionality in PalOOCa 5.2.1 works, i have to use the Jedox
Server 5.x as well because it doesn´t work with Palo Server 3.1, right? (Palo Server 3.2 doesn´t work
properly....it´s useless because of it´s failures)
Where could i find a download-link for the jedox server 5.x 64bit Linux?? I need only the server, no ETL or whatever more.

Sometimes it seems like Palo (Open Source) should be a test but not usable for productivity...
-->
Palo Server 3.1 64bit Linux works fine with big data but newbies can´t find it anymore on the internet. And if they get it they don´t have the required start folders (I got them from Palo Server 2.5...).
Now - if you´re lucky and got all you need - you could start for example a Linux Mint 64bit OS (which has the required Java included, not like Debian or Ubuntu ... and the right-management works fine with Palo-Server, not like Debian based OS) and then, after all it´s useless because eadd doesn´t work automatically (this is a must for productive controlling software because when you have thousands of
records per day you can´t handle
them by hand and if you have less records, you don´t need palo). Is it really the intention of Proclos or any other supporter to realize a open source software
designed for users? Or do they create a playground for themselves?? What firm invests so much time
in installing and testing all this stuff? --> They all use Windows Server, Windows SQL Server etc. and I think it´s
good invested money instead of playing with libreoffice, linux and palooca...
Or they buy Windows 7 (30 bugs) and Excel 2013 including Powerpivot (100 bugs) and things work
fine.

Hope my testing contributes to the open-source project linux / libreoffice [incl. palo}, because it´s free
for all and not depending on a single firm, but right now it doesn´t look like PalOOCa has a future and
this makes libreoffice less usable in firms compared to MS Office (Excel) because MS has introduced
a killerfeature: Powerpivot. And the open-source community has not even a good pivot in calc... the
only hope is PalOOCa: More than 1 Mio records are possible (much more) and the pivot feature is integrated as well as the cube-functions and it´s usable for normal users or IT members who are not so familiar with open source.

And again, thx 4 helping me solving my questions!

To come to an end in this thread:

PalOOCa works quite well in version 5-1-0, except of the formular EADD (no hyrachies are
possible). In the actual 5.2.1 Import-functionality is removed so right now I can´t find any reason why
to use this newer version).

To solve the EADD-failure I use Talend Open Studio Data Integration 5.6.2.
(Also data-import and attribute-import is possible; it´s a full ETL-tool)
Latest Version 6.0 can´t deal properly with Proxy-Server, right now it´s better
to void it.

Talend also works together with MySQL 5 which I use as database. CSV-files, textfiles,
MS SQL Server and many other sources are possible, too.

The OS is Linux Mint 17.2 64bit (as Server as well as for clients, but windows-clients
are possible, too).

Palo Server is version 3.1 (the latest version 3.2 has failures which make it useless) and
I have no clue where to get a 5.x server (only the server software).

After all, I think a fully open source solution instead of MS Excel, MS Windows Server and MS SQL
Server (Database, Integration Services and Reporting Services) is available right now.
--> Business Intelligence for free is possible! If anyone is interested in that, this is one way of
doing it (no deeper it-knowledge or coding is needed).