You are not logged in.

Importing strings and numbers into the same dimension

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.

Rom

Master

  • "Rom" started this thread

Posts: 30

Date of registration: Dec 14th 2005

Location: Rosenheim

  • Send private message

1

Wednesday, December 14th 2005, 5:38pm

Importing strings and numbers into the same dimension

Hi all,

is it possible to import strings and numbers into the same dimension? If a string value apears, I change the cube, and I also change the importing cell, which is formated as string (text), before writing into the database

In my sheet, only string values are written.

Tx for help!

Dave

Master

Posts: 37

Date of registration: Dec 8th 2005

  • Send private message

2

Wednesday, December 14th 2005, 7:23pm

RE: Importing strings and numbers into the same dimension

Yes its possible.

Rom

Master

  • "Rom" started this thread

Posts: 30

Date of registration: Dec 14th 2005

Location: Rosenheim

  • Send private message

3

Thursday, December 15th 2005, 9:12am

RE: Importing strings and numbers into the same dimension

I uploaded my import file. In my import sheet, only one of the values (either strings or numbers) are written, How do i get both in my database?

tx for help.
Rom has attached the following file:
  • Testumgebung2.txt (517 Byte - 214 times downloaded - latest: Jun 12th 2013, 3:36am)
RJ
Rosenheim

holger

Palo Team

  • "holger" is male

Posts: 64

Date of registration: Oct 27th 2005

  • Send private message

4

Monday, December 19th 2005, 10:17am

RE: Importing strings and numbers into the same dimension

Rom

you will have to decide upon an element type to use, very probably this will be text in this case. Remember that you will not be able to calculate with values from these cells, and there will be no consolidation.

To import 'numeric' string in this case, add a field with an Excel formula to convert the numeric values into text strings, like =TEXT($A$5;"0.00").

Hope this helps! Let me know in case I did not understand what you are trying to do exactly.

Holger
Jedox QA
Rate this thread