Function To Look Down Multiple Levels Of A Dimension Heirarchy

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.

dave.edwards

Intermediate

Posts: 7

Date of registration: Oct 19th 2007

Location: London

Occupation: Olap Consultant

Tuesday, May 13th 2008, 12:49pm

Function To Look Down Multiple Levels Of A Dimension Heirarchy

Is there a rules function that will allow a rule to be applied down multiple levels of a hierarchy.
For example, apply a rule to all European cities, where the cities
London, Leeds, Vienna, Graz, Berlin and Frankfurt consolidate into Europe:-

World
- Europe
- UK
- England
London
Leeds
- Scotland
Glasgow
Edinburgh
- Austria
Vienna
Graz
- Germany
Berlin
Frankfurt
- Americas
- USA
New York
LA
Denver

This is a similar rules function to the TM1 Elisanc rules function.

Go to the top of the page

Michel

Sage

Posts: 154

Date of registration: Jun 1st 2007

Location: Netherlands

Tuesday, May 13th 2008, 3:24pm

RE: Function To Look Down Multiple Levels Of A Dimension Heirarchy

Hi Dave,

PALO (currently) doesn't have an ElIsAnc function like TM1.

What you could do is add an attribute to your 'geography' dimension indicating the region and do a lookup of this attribute in the rule to determine whether a city is in a certain region.

Michel

Go to the top of the page

dave.edwards

Intermediate

Posts: 7

Date of registration: Oct 19th 2007

Location: London

Occupation: Olap Consultant

Tuesday, May 13th 2008, 10:43pm

RE: Function To Look Down Multiple Levels Of A Dimension Heirarchy

Michel,
This is the work around I have used. It is neater than the other method I tried, using an additional consolidation/hierarchy to group all the European cities together and then using the EISCHILD function.
Best Regards
Dave

Go to the top of the page

Pommie

Sage

Posts: 411

Date of registration: Feb 21st 2007

Location: Lytham UK

Occupation: OLAP consultant specialising in retail

Saturday, January 24th 2009, 4:36pm

Quoted

PALO (currently) doesn't have an ElIsAnc function like TM1.

Is this function going to be available in V3 - we had to fight Applix long and hard to get this in TM! but they did eventually get their heads around the fact that it really was needed.

It would be nice if Jedox could give us this without such a struggle

Best wishes

John Hobson
The Planning Factory, Lytham, UK
www.planfact.co.uk

Go to the top of the page

dominik_l

Jedox Team

Posts: 344

Date of registration: May 7th 2008

Location: Freiburg / Germany

Monday, January 26th 2009, 1:43pm

Do i understand you correctly, that you're looking for a function to check wether a given element is a (multi-level) descendant of another?

There's a feature request for this one, but it won't be in the initial 3.0 version.

Go to the top of the page

Pommie

Sage

Posts: 411

Date of registration: Feb 21st 2007

Location: Lytham UK

Occupation: OLAP consultant specialising in retail

Monday, January 26th 2009, 5:37pm

Yes - what I need to know is not simply is an element a component ofa particular consolidation (e.g. Frankfurt belongs to Germany) but whether it is an N level descendant. (E.G. Frankfurt belongs to Europe, because it belongs to Germany which belongs to Europe).

As the number of parent "generations" may vary, nested "eischild"s won't suffice.

The functionality is needed in both rules and in spreadsheets.

Thanks

Best wishes

John Hobson
The Planning Factory, Lytham, UK
www.planfact.co.uk

This post has been edited 1 times, last edit by "Pommie" (Jan 26th 2009, 5:38pm)

Go to the top of the page