You are not logged in.

Importing Dimension Elements

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.

Sabin

Trainee

  • "Sabin" started this thread

Posts: 3

Date of registration: May 2nd 2006

  • Send private message

1

Tuesday, May 2nd 2006, 11:48am

Importing Dimension Elements

Hi,

I am a new user of Palo Server.

I am trying to load dimensión elements to a palo database and I have problems with the type of the element. All the elements that I import with function:

=PALO.EADD($B$4;"articulo";"n";F7;"";1;VERDADERO)

are created with numeric type. The cell in excel is formatted to text and the data in the inported database are text. But the elements in the dimension "articulo" are created like numeric.

Anybody knows to solve this problem??

Thank you,
Sabin

v_malicevic

Palo Team

  • "v_malicevic" is male

Posts: 454

Date of registration: Oct 26th 2005

Location: Germany

  • Send private message

2

Tuesday, May 2nd 2006, 2:07pm

RE: Importing Dimension Elements

Hi!
The third argument of EADD function desribes element type ... You used default - N which stands for numeric ... alternatives are S = string and C = consolidated.
Mit freundlichen Gruessen/ With kind Regards / Meilleures salutations

Vladislav Malicevic
Head of Research and Development

Jedox AG

h_decker

Sage

  • "h_decker" is male

Posts: 763

Date of registration: Oct 26th 2005

Location: Cologne, Germany

  • Send private message

3

Tuesday, May 2nd 2006, 2:16pm

RE: Importing Dimension Elements

Hi,
if I understand right you want to import dimension elements from a database with article names. The element type "n" just describes that the information, that is saved in the complete palo modell is (mostly) numerical.

Lets say you have 3 Dimensions:

Dimension 1: "Year" with elements: 2006, 2007, 2008,..... (all type n)
Dimension 2: "Articles" with elements: Atricle001, Article002, ....(all type n)
Dimension 3: "Valuetype" with elements: turnover (type s) and comment (type c)

In that last element "comment" you can save text information. Therefore it has to be of type s. So you save

- numerical information in e.g. (2006,Article001,turnover)
- string information in e.g. (2006,Article001,comment)

Look at the demo db that comes with palo. All element types are n there, because only numerical info is beeing saved.

Hope this is kind of right help for you.


Greetings from cologne
Holger

This post has been edited 2 times, last edit by "h_decker" (May 2nd 2006, 2:17pm)

Sabin

Trainee

  • "Sabin" started this thread

Posts: 3

Date of registration: May 2nd 2006

  • Send private message

4

Tuesday, May 2nd 2006, 10:56pm

Thank you

Thank you very much for your support.

In the manual from Palo server and in the examples i only found types "n" or "c". I did not know that it is possible a type "s".

I will try with this type tomorow.

Greetings from Basque Country
Sabin

Sabin

Trainee

  • "Sabin" started this thread

Posts: 3

Date of registration: May 2nd 2006

  • Send private message

5

Thursday, May 4th 2006, 6:39pm

It works fine

The "s" parameter works fine,

Thank you
Rate this thread