You are not logged in.

Change The Sorting Of Palo ?!

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.

TR7

Intermediate

  • "TR7" started this thread

Posts: 14

Date of registration: Jan 26th 2011

  • Send private message

1

Tuesday, March 22nd 2011, 3:45pm

Change The Sorting Of Palo ?!

Hi all,

is it possible to affect the sorting of palo?

for example I have the dimension "Regions" with elements on three levels.

- 1. level = Europe
- 2. level = West, East, South, North
- 3. level = (for West) Germany, France, Switzerland etc.
(see attached screenshot)

Palo will show the attributes in the same structure ("Europe" will be on the top, then e. g. "West" and then there will be all countries for this region.).

But I would like to view a different structure in Excel. I would like to see first all countries for a region (e. g. "Germany, France, Switzerland etc.") followed by the typ of region (e. g. "West"). And I would like to see "Europe" at the bottom.

Is there a chance to do this? Can someone help me?
Hope it is clear what I am looking for?!

Thx

realquo

Sage

  • "realquo" is male

Posts: 255

Date of registration: Mar 11th 2009

Location: Italy

Occupation: BI Consultant

  • Send private message

2

Tuesday, March 22nd 2011, 4:11pm

RE: Change The Sorting Of Palo ?!

Hi,

in the element selector it's quite "normal" to have sub-elements below the parent element and anyway there's no way to change this behavior in palo.
When building your view, instead, you can use the => button to put the selected elements in the list on the right and then order them as desired.

Regards,
RQ

tish1

Sage

Posts: 761

Date of registration: Jul 13th 2009

Location: Vienna / Austria

Occupation: Senior Consultant @ Vector SW DV GmbH

  • Send private message

3

Saturday, March 26th 2011, 3:47pm

Hi,

when using subsets in reports you can change the hierarchy layout.

Regards.
Robert Tischler
Senior Consultant Vector SW DV GmbH

c.herzog

Professional

  • "c.herzog" is male

Posts: 19

Date of registration: Jan 28th 2011

Location: Vienna

Occupation: BI/CPM Senior Consultant

  • Send private message

4

Tuesday, March 29th 2011, 12:34pm

Hi,

subsets would also offer you the possibility to create an order based on specific conditions (an attribute for example which you could use to define the "default order") in a dimension.

Kind regards,

Christian
Christian Herzog, Senior Consultant, Vector SW DV GmbH

Dominic

Intermediate

  • "Dominic" is male

Posts: 5

Date of registration: Mar 30th 2011

Location: Langenfeld / Germany

Occupation: Financial Controller

  • Send private message

5

Wednesday, March 30th 2011, 10:24am

Management structure instead of parent / child

Dear all,

I have the same problem with the accounts in P&L which is upside down in parent / child structure. Has anybody an example how to solve that with subset feature? May be a small demo database?
kind regards
Rate this thread