You are not logged in.

Top 10 not possible for large dimensions?

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.

outlaw77

Master

  • "outlaw77" started this thread

Posts: 42

Date of registration: May 7th 2010

  • Send private message

1

Saturday, June 4th 2011, 1:13pm

Top 10 not possible for large dimensions?

I' m trying to get the top 10 clients by turnover from my cube.

I use the subset editor from the Excel Plugin.
With the Demo it works fine and quick, but with my cube ( 25 dimensions and about 13.000 base elements in the client dimension) Excel freeze - and does nothing for hours. I think palo crashed (I can do nothing until restart)
I used no wildcards, only the top element of each dimension except years I used 2010.

In the subset I chose:
Clients + 1 Alias, only base elements, no duplicates, top 10, sort by value DESC

Is Palo not the correct tool for such report - or I am doing something wrong?

my ini:
verbose debug
splash-limit 1000 500 100
goalseek-limit 1000
goalseek-timeout 10000
cache-size 0
cache-barrier 15000
clear-cache-cells 10000

realquo

Sage

  • "realquo" is male

Posts: 255

Date of registration: Mar 11th 2009

Location: Italy

Occupation: BI Consultant

  • Send private message

2

Monday, June 6th 2011, 12:33pm

RE: Top 10 not possible for large dimensions?

Hi,

I had the same need with a similar cardinality in production environment, same behavior with the Community Edition ;(
Maybe the Premium Ed can perform this calculation by leveraging multicore and NVidia olap accelarator, but I'm stuck with this (as a workaround, I opted for ordering the results in Excel, but for sure I'd like to do it in Palo!!).
Regards,
RQ

scorbett

Master

  • "scorbett" is male

Posts: 67

Date of registration: Nov 4th 2010

Location: Canada

  • Send private message

3

Wednesday, June 15th 2011, 1:09am

RE: Top 10 not possible for large dimensions?

I have done top 10 on large (several thousand element) dimensions without noticing any performance problems. What's the hardware of the machine running Palo?

outlaw77

Master

  • "outlaw77" started this thread

Posts: 42

Date of registration: May 7th 2010

  • Send private message

4

Saturday, June 18th 2011, 9:45am

Hi,
Thanks for your feedback! That's very interesting!

It's a quite strong server (2x Xeon 2,53, 48 GB Ram, Windows 2008) so I don't think its the hardware.

Do you have an idea - how I could identify reasons for my "non-performance" ?

thx,
Robert
Rate this thread