You are not logged in.

Palo recalc

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.

Allen Lu

Intermediate

  • "Allen Lu" is male
  • "Allen Lu" started this thread

Posts: 8

Date of registration: Nov 27th 2008

Location: Wellington NZ

  • Send private message

1

Friday, December 5th 2008, 3:05am

Palo recalc

It seems that when I do data entry on the cells contain "PALO.DATAC,X,V()"formula, seemingly the Excel sheet will recalculate the ENTIRE WORKBOOK twice in order to send in and return data, that's fine when you only have 1-2 sheets in a Workbook, but when you have more than 5 sheets containing quite a lot of PALO formulas, then the whole Palo-Excel application will become real slow.

and with the automatic calculation on Excel turned off, sometimes when I type in a number in a base level cell and press shift+F9, the number consolidation level cell won't show the change!! I have to click on formula of the consolidation cell and press Enter to refresh to show me the change.

Does anyone have the same experience? Is it normal? or I'm just simply bad luck?

Thanks for your help, GOD bless you.

This post has been edited 3 times, last edit by "Allen Lu" (Dec 5th 2008, 3:21am)

h_decker

Sage

  • "h_decker" is male

Posts: 763

Date of registration: Oct 26th 2005

Location: Cologne, Germany

  • Send private message

2

Friday, December 5th 2008, 11:34am

RE: Palo recalc

Hi,

did you try DATAX. This should only calculate the current sheet.

Holger

Allen Lu

Intermediate

  • "Allen Lu" is male
  • "Allen Lu" started this thread

Posts: 8

Date of registration: Nov 27th 2008

Location: Wellington NZ

  • Send private message

3

Tuesday, December 9th 2008, 4:24am

Yip it works thanks

cuboo

Master

  • "cuboo" is male

Posts: 62

Date of registration: Sep 30th 2008

  • Send private message

4

Wednesday, December 10th 2008, 11:02am

RE: Palo recalc

Hi,

I received strange effects because of low memory ... to avoid them it's recommended to use at least 2GBM RAM. No joke ... the best, Lars

Malc

Beginner

Posts: 1

Date of registration: Dec 11th 2008

  • Send private message

5

Thursday, December 11th 2008, 3:30am

RE: Palo recalc

Quoted

Originally posted by Allen Lu
and with the automatic calculation on Excel turned off, sometimes when I type in a number in a base level cell and press shift+F9, the number consolidation level cell won't show the change!! I have to click on formula of the consolidation cell and press Enter to refresh to show me the change.


I am also having this problem, where it can take a few minutes and multiple recalculations for the changes to show up.

Allen Lu

Intermediate

  • "Allen Lu" is male
  • "Allen Lu" started this thread

Posts: 8

Date of registration: Nov 27th 2008

Location: Wellington NZ

  • Send private message

6

Monday, December 22nd 2008, 11:46pm

Yeah, I still got that problem. especially when I do Rules in pulling data from one cube to another cube.

Every time I have to click on the formula on Excel and Enter to get the numbers updated, that's not satisfatory......

knixon

Intermediate

  • "knixon" is male

Posts: 14

Date of registration: Dec 14th 2008

Location: Australia

  • Send private message

7

Tuesday, December 23rd 2008, 4:48am

Are there any performance stats available to understand what performance levels should be being achieved?

I would have thought that Palo would be able to quote these as it's a fundamental measure that will determine whether the product suceeds or fails.


Karl

h_decker

Sage

  • "h_decker" is male

Posts: 763

Date of registration: Oct 26th 2005

Location: Cologne, Germany

  • Send private message

8

Tuesday, December 23rd 2008, 9:07am

Its hard to post performance stats because really everything depends on the data model.

Holger

dibe0014

Sage

Posts: 85

Date of registration: Sep 25th 2008

Location: Oakville, ON

  • Send private message

9

Tuesday, December 23rd 2008, 10:21am

Hi,

I recently read a good article about performance tests. General performance tests are not very helpful because the result is only good for one scenario.
The best is to do your own performance tests and find out if it's fast enough for your situation. Maybe there might be a faster tool on the market, but maybe the slower one is still fast enough.

Benjamin
My blog on Open Source BI and living in Canada
Rate this thread