Displaying Aliases

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.

OGAHS

Trainee

Posts: 3

Date of registration: Jan 20th 2012

Thursday, March 15th 2012, 1:08pm

Displaying Aliases

Hi,

I would like to display the Aliases of all elements in a dimension (like can be done using paste view). I have sucessfully been able to display the actual elements with the formulas PALO.FIRST and PALO.ECHILD ((PALO.EFIRST($A$2;$H$1); A2 being the Server/Database and H1 from where I want to collect the elements and the using eg. (PALO.ECHILD($A$2;$H$1;$H$4;1) to display the first level of underlying hierarchy of elements, H4 being the "Parent" Element).

How would I go about displaying the Aliases for each of the elements instead of the actual elements as I am diong at present? The elements in the diemsion are Dealer Numbers and I want the display the actual Delaer Name which is one of the possible aliases for each element.

I tried using PALO.SUBSET but only got as far as displaying the Parent element ((PALO.SUBSET($A$2;$H$1;;$A$17) A17 being the Alias "name")

I would be grateful for any input you would e able to provide.

Thanks!

Go to the top of the page

dmarkovic

Master

Posts: 90

Date of registration: Aug 11th 2011

Location: Vienna / Austria

Occupation: Vector SW DV GmbH

Thursday, March 15th 2012, 2:17pm

Hello Ogahs,

Quoted from "OGAHS"

I would like to display the Aliases of all elements in a dimension (like can be done using paste view). I have sucessfully been able to display the actual elements with the formulas PALO.FIRST and PALO.ECHILD ((PALO.EFIRST($A$2;$H$1); A2 being the Server/Database and H1 from where I want to collect the elements and the using eg. (PALO.ECHILD($A$2;$H$1;$H$4;1) to display the first level of underlying hierarchy of elements, H4 being the "Parent" Element).

How would I go about displaying the Aliases for each of the elements instead of the actual elements as I am diong at present? The elements in the diemsion are Dealer Numbers and I want the display the actual Delaer Name which is one of the possible aliases for each element.

You have a very good example in the documentation for excel:
Without an alias:

	Source code
1	=PALO.ENAME("localhost/Demo";"Months";"Years";1;"")

With an alias:

	Source code
1	=PALO.ENAME("localhost/Demo";"Months";"Years";1;"";"German";"Sheet1!__palo622272")

The last parameter is "Sheet1!__palo622272" is from the system and it can't be changed (documentation).

Quoted from "OGAHS"

I tried using PALO.SUBSET but only got as far as displaying the Parent element ((PALO.SUBSET($A$2;$H$1;;$A$17) A17 being the Alias "name")

I would recommed to read the documation for excel advanded.
But you have to select 2 colums and then paste the subset > select your alias > paste.
Now you should see the element name (alias).

Regards.

Djordja Markovic
Vector SW DV GmbH

Interessant things:
Internal derby:
http://www.jedox.com/community/palo-foru…14338#post14338
Calculate your cube size:
http://www.jedox.com/community/palo-foru…14406#post14406