#0 Calc time is very Long

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.

Hiten

Intermediate

Posts: 5

Date of registration: Jul 21st 2009

Location: Sydney

Friday, June 15th 2012, 2:46am

#0 Calc time is very Long

Hi

I have a simple spreadsheet used for forecasting, by year and month. When I enter any figure in a certain cell #12, #100, anything the calculation time is instant but when I zero out (#0) the cell it is taking up to 5 minutes to calculate, any reason why?

Hightower

Go to the top of the page

jjunek

Jedox Team

Posts: 58

Date of registration: Sep 16th 2009

Location: Prague

Occupation: PALO OLAP Server architect

Friday, June 15th 2012, 10:45am

Hi

you are probably using markers in your rules. Right? Writing 0 (deletion) causes that all markers are recreated in memory That's why it takes longer. There were some performance problems in models with big dimensions that has been fixed and will be available soon in 3.3SR3. Version 4.0 that should be released in one month will eliminate the described problem. Writing 0 should be as fast as writing any other value.

Go to the top of the page

tish1

Sage

Posts: 762

Date of registration: Jul 13th 2009

Location: Vienna / Austria

Occupation: Senior Consultant @ Vector SW DV GmbH

Wednesday, August 1st 2012, 9:37pm

Hi,

are any workarounds available? We have the same problem, but our cube doesn't have any large dimension. All below 1,000 elements.

Regards.

Robert Tischler
Senior Consultant Vector SW DV GmbH

Unterstützung für Jedox und Palo Projekte - Jedox und Palo Schulungen in Wien - Vector Blog auch über Jedox und Palo

Go to the top of the page