You are not logged in.

Reference to a whole row or column in DATA formula generates an error (Element nicht gefunden!)

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.

rapid

Master

  • "rapid" started this thread

Posts: 39

Date of registration: Jun 24th 2008

  • Send private message

1

Thursday, June 26th 2008, 4:00pm

Reference to a whole row or column in DATA formula generates an error (Element nicht gefunden!)

Hello

I'm using a lot of DATA-formulas in an excel sheet. I have there rows, where I have my dimension elements - e.g. in Row 2 I have the period elements.

In the Data-formulas I made references e.g. for the period-element to this row 2:

PALO.DATA([Database], [Cube], $2:$2, [more dimension-elements])

So Excel refers as following - e.g.
Formula in C10 => refers to C2
Formula in D252 => refers to D2
(standard Excel-funktionality)

So it would be easier to handle many formulas on an excel sheet.

When I do this reference as written above, I get an error message "Element nicht gefunden!". But after this message, the value is correct. When I have an input sheet, every time I do an entry, the error message is shown.

What can I do to work with such references (and not getting this errors)?

Thank you very much!

h_decker

Sage

  • "h_decker" is male

Posts: 763

Date of registration: Oct 26th 2005

Location: Cologne, Germany

  • Send private message

2

Friday, June 27th 2008, 9:25am

RE: Reference to a whole row or column in DATA formula generates an error (Element nicht gefunden!)

Hi, why not use
PALO.DATA([Database], [Cube], b$2, [more-dimension-elements])?

B$2 means that 2 is fix and you can copy the formula e.g. from the left to the rigfht and down. Then it will automatically be C$2 or D$2 and so on.

Holger

rapid

Master

  • "rapid" started this thread

Posts: 39

Date of registration: Jun 24th 2008

  • Send private message

3

Friday, June 27th 2008, 11:12am

RE: Reference to a whole row or column in DATA formula generates an error (Element nicht gefunden!)

Hi Holger

thank you for the answer. If I use B$2 I always have to check if the column-reference is ok when I insert columns, copy formulas, copy parts of the formula etc - e.g. for a SETDATA-formula I can copy the part of the dimension-list from a DATA-formula (so the references are not automatically like they should be). So it's easier to handle with references like $2:$2.

Thanks a lot.

h_decker

Sage

  • "h_decker" is male

Posts: 763

Date of registration: Oct 26th 2005

Location: Cologne, Germany

  • Send private message

4

Friday, June 27th 2008, 12:15pm

RE: Reference to a whole row or column in DATA formula generates an error (Element nicht gefunden!)

I am not sure if PALO Excel AddIn was designed to deal with that $2:$2 syntax. Anyone else an idea?

Holger

dominik_l

Jedox Team

  • "dominik_l" is male

Posts: 344

Date of registration: May 7th 2008

Location: Freiburg / Germany

  • Send private message

5

Tuesday, August 12th 2008, 2:15pm

The $X:$X Notation currently isn't supported by the Palo Excel Addin.

kyong

Trainee

Posts: 2

Date of registration: Sep 2nd 2008

  • Send private message

6

Monday, December 15th 2008, 10:28pm

RE: Reference to a whole row or column in DATA formula generates an error (Element nicht gefunden!)

if you're still looking for a solution, you could try a mixture of two excel functions in your formula - ADDRESS and COLUMN - to set up a specific reference to a cell. So instead of $2:$2, you'd put ADDRESS(2,COLUMN()). I might have got the elements of ADDRESS the wrong way round though...
Rate this thread