You are not logged in.

TableTransform with aggregation avg does not work

Dear visitor, welcome to Palo Community Forum. If this is your first visit here, please read the Help. It explains in detail how this page works. To use all features of this page, you should consider registering. Please use the registration form, to register here or read more information about the registration process. If you are already registered, please login here.

dpolke

Trainee

  • "dpolke" started this thread

Posts: 2

Date of registration: Apr 20th 2012

  • Send private message

1

Friday, April 20th 2012, 5:15pm

TableTransform with aggregation avg does not work

Hello,

I try to aggregate two colums with avg in TableTransform. After loading the data into the cube I get only the sum of the colums! What's going wrong?

My settings are in the attached screenshot.

Dirk
dpolke has attached the following image:
  • Bildschirmfoto 2012-04-20 um 17.08.27.png

a_froehlich

Sage

Posts: 173

Date of registration: Jan 4th 2008

Location: Freiburg / Germany

  • Send private message

2

Wednesday, April 25th 2012, 1:17pm

This should work like this. Test the Results already in the Data-Preview and make sure that there are several rows that aggregate to one row (to see difference between sum and avg)

dpolke

Trainee

  • "dpolke" started this thread

Posts: 2

Date of registration: Apr 20th 2012

  • Send private message

3

Wednesday, May 9th 2012, 8:15am

Sorry, but this the results are not as expected. In the consolidated fields are only the sum of the underlying cells, not the average. When I use the function palo.data.avg I get the correct result for all cells (see screenshot).
dpolke has attached the following image:
  • 09.05.png

tish1

Sage

Posts: 761

Date of registration: Jul 13th 2009

Location: Vienna / Austria

Occupation: Senior Consultant @ Vector SW DV GmbH

  • Send private message

4

Wednesday, May 9th 2012, 10:35pm

Hi,

the aggregation mode in ETL Server only influences the values that are loaded to the base level of Palo. If you want to calculate the averages of values already in Palo, you have to use rules.

Regards.
Robert Tischler
Senior Consultant Vector SW DV GmbH

Similar threads

Rate this thread