PaloKettlePlugin : Splashing : import consolidated elements

[sebhm]

Hi,

I'm using the Palo Plugin in PDI.
I made a test with a CSV file for input, and i put data in my Palo Base.
It works when i import data of lower level in each dimension.
But if i have a consolidated element, PDI says that splasing is disabled :

2009/11/06 11:04:29 - Palo Cells Output .0 - ERROR (version 3.2.2-stable, build 10951 from 2009-09-15 15.34.19 by buildguy) : Erreur inattendue :
2009/11/06 11:04:29 - Palo Cells Output .0 - ERROR (version 3.2.2-stable, build 10951 from 2009-09-15 15.34.19 by buildguy) : org.pentaho.di.core.exception.KettleException:
2009/11/06 11:04:29 - Palo Cells Output .0 - ERROR (version 3.2.2-stable, build 10951 from 2009-09-15 15.34.19 by buildguy) : Failed to add Cell Row: REEL HYPER 2009 OCTOBRE 60290003 2533 00000017.88
2009/11/06 11:04:29 - Palo Cells Output .0 - ERROR (version 3.2.2-stable, build 10951 from 2009-09-15 15.34.19 by buildguy) : com.tensegrity.palojava.PaloException: 5005
splash disabled
cell path is consolidated, but splashing is disabled
2009/11/06 11:04:29 - Palo Cells Output .0 - ERROR (version 3.2.2-stable, build 10951 from 2009-09-15 15.34.19 by buildguy) :
2009/11/06 11:04:29 - Palo Cells Output .0 - ERROR (version 3.2.2-stable, build 10951 from 2009-09-15 15.34.19 by buildguy) : at plugin.palo.celloutput.PaloCellOutput.processRow(PaloCellOutput.java:104)
2009/11/06 11:04:29 - Palo Cells Output .0 - ERROR (version 3.2.2-stable, build 10951 from 2009-09-15 15.34.19 by buildguy) : at plugin.palo.celloutput.PaloCellOutput.run(PaloCellOutput.java:140)
2009/11/06 11:04:29 - Palo Cells Output .0 - ERROR (version 3.2.2-stable, build 10951 from 2009-09-15 15.34.19 by buildguy) : Caused by: org.palo.api.PaloAPIException: com.tensegrity.palojava.PaloException: 5005
splash disabled
cell path is consolidated, but splashing is disabled
2009/11/06 11:04:29 - Palo Cells Output .0 - ERROR (version 3.2.2-stable, build 10951 from 2009-09-15 15.34.19 by buildguy) : at org.palo.api.impl.CubeImpl.setDataInternal(Unknown Source)
2009/11/06 11:04:29 - Palo Cells Output .0 - ERROR (version 3.2.2-stable, build 10951 from 2009-09-15 15.34.19 by buildguy) : at org.palo.api.impl.CubeImpl.setData(Unknown Source)
2009/11/06 11:04:29 - Palo Cells Output .0 - ERROR (version 3.2.2-stable, build 10951 from 2009-09-15 15.34.19 by buildguy) : at plugin.palo.core.PaloHelper.addCells(PaloHelper.java:478)
2009/11/06 11:04:29 - Palo Cells Output .0 - ERROR (version 3.2.2-stable, build 10951 from 2009-09-15 15.34.19 by buildguy) : at plugin.palo.celloutput.PaloCellOutput.processRow(PaloCellOutput.java:96)
2009/11/06 11:04:29 - Palo Cells Output .0 - ERROR (version 3.2.2-stable, build 10951 from 2009-09-15 15.34.19 by buildguy) : ... 1 more
How enable splashing ?

Thanks

[Braeu]

Hi,

I'm running in the same problem. In the normal use of PALO you can splash values via "#", but it does not work with the kettle plugin. Now I splash the values direkt in kettle. In my case:

heraiche dimension "daytime"

Day -> 8.00-10.00 Uhr -> 8.00-9.00 Uhr
-> 9.00-10.00 Uhr
->10.00-12.00 Uhr-> 10.00-11.00 Uhr
-> 11.00-12.00 Uhr
....

I get a value for 8.00-10.00 Uhr -> clone the row, and splash the value to thies 2 rows:

10 Euro 8.00-10.00 Uhr

becomes:

5 Euro 8.00-9.00 Uhr
5 Euro 9.00-10.00 Uhr

Greetings

Braeu

[sebhm]

i don't understand.

you just tell me : "make the calcul yourself and put the values in the lower levels" ???
so kettlePlugin can't receive splash values ?

[pstoellberger]

as far as i know the kettle plugin is a bit outdated, so i wouldn't fully rely on it.. just for your interest

[Braeu]

I called with jedox and he told me, that kettle does not support all features of the PALO System. He suggest me to use there own ETL-Tool.:)

I think, you can only write on the lowest level in a hierarchy dimension with the kettle plugin. So you have to portion the value for the lowest level (the same make PALO with the "#"-Tag).

Sorry for my bad english!

Braeu

[sebhm]

anyway, i had used another solution
(i tested palo ELT too, but finaly, i use SDK PHP)

thanks