You are not logged in.

error with datav

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.

glvingne

Master

  • "glvingne" started this thread

Posts: 36

Date of registration: Feb 11th 2010

  • Send private message

1

Thursday, July 1st 2010, 10:43am

error with datav

Good morning,

I am trying to enhance the performance of a report i am creating.
my report is quite basic: i have a flat file representing the projects of different offices and showing the budget planned per project.

i have three columns: the first one is a palo subset, showing a predefined set of projects.
the second one is the colomn representing the office where the project belongs.

i would like to have a DATAV formula in the third column, retrieving the values on each project and bureau.
a palo.data would be palo.data(server;cube;A1;B1) right?

this works fine but when i try to replace the 500 DATA formulas in the column C by one DATAV, I select the whole column, enter the formula palo.datav(server;cube;A1:A500;B1:B500) and press ctrl shift enter.

Then palo gives me the values of the project in A1, A2, A3 etc so it's perfect
BUT, the formula always gives me the result of the office shown in B1...

Does that mean that the DATAV formula does not work with two rows as argument? because in other places of the rerport i use only one column as argument and it works fine...

thanks a lot for your help !
_____________
Windows 7
Office 2010
IE9
Firefox 5.0

George Jovanovic

Professional

  • "George Jovanovic" is male

Posts: 24

Date of registration: Jun 8th 2006

Location: Chile

Occupation: sales & consulting

  • Send private message

2

Thursday, July 1st 2010, 10:27pm

RE: error with datav

Please note this thread:

http://www.jedox.com/community/palo-foru…3&hilight=datav

It´s a subtle difference in explanation with the Palo documentation. It appears it is not mandatory to define PALO.DATAV as an array formula...

If you replace all PALO.DATAC with PALO.DATAV not in an array the values are retrieved. It appears it´s a internal difference of how the excel plug-in works before retrieve the data.

George
Gjovan
georgejovanovic.blogspot.com
Rate this thread