You are not logged in.

The values are not going to the right elements.HELp!

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.

Laura

Intermediate

  • "Laura" started this thread

Posts: 11

Date of registration: Apr 2nd 2007

  • Send private message

1

Friday, April 27th 2007, 7:56pm

The values are not going to the right elements.HELp!

Hello,

I imported the values using PALO.SETDATA to three dimensions I created using PALO.EADD.

Region: Country-subregion-region

Product :product-line-division

Time:month-year

My problem is that when I do Paste view the values are not inserted properly.The values are distributed in all the regions and then equally distributed by countries.It does not maintain the data the way is in the original file. How I can maintain the consistency of my data? Is the problem in my Palo.setdata or the formula I am using to import the dimensions or in the PALO.EADD?

Thankssss a lot,

Laura

Stephanie

Sage

Posts: 540

Date of registration: Oct 23rd 2006

Location: Freiburg

  • Send private message

2

Monday, April 30th 2007, 12:06pm

RE: The values are not going to the right elements.HELp!

Hello Laura,

I have a lot of questions:

Could you please report how your formulas look like? Do you use splashing in
PALO.SETDATA? How do you use PALO.EADD? Do you use more than one
function of EADD in your worksheet (this could lead also to problems, see EG
p. 114)? What other functions do you use in your complet workbook?
I suppose your elements in the dimensions are all aggregated. Do you set only
the values of the base elements?

Regards,
Stephanie

Laura

Intermediate

  • "Laura" started this thread

Posts: 11

Date of registration: Apr 2nd 2007

  • Send private message

3

Monday, April 30th 2007, 5:10pm

RE: The values are not going to the right elements.HELp!

Hello Stephanie,

I greatly appreciated your help.

I use Palo.Eadd formula to insert the time,Region and Product dimension in all I use TRUE at the end.

For the time (moth-fiscal year) Dimension I used one formula:

=IF(NOT($B$5),PALO.EADD($B$4,"Time","n",B9,B10,1,TRUE))

For the Region (country-region-area) Dimension I used two formulas very similar for the example in the evaluation guide:

=IF(NOT($B$5),IF(B17<>"",PALO.EADD($B$4,"Region","n",B16,B17,1,TRUE)))

=IF(NOT($B$5),PALO.EADD($B$4,"Region","n",IF(B17<>"",B17,B16),B18,1,TRUE))

For the Product (group-line-division) I use two formulas:

=IF(NOT($B$5),IF(B29<>"",PALO.EADD($B$4,"Product","n",B28,B29,1,TRUE)))

=IF(NOT($B$5),PALO.EADD($B$4,"Product","n",IF(B29<>"",B29,B28),B30,1,TRUE))

In Palo.SetData I use splashing: I created the dimension "Measures" manually and I want to insert the values for Net Sales:

=PALO.SETDATA($AZ$1,TRUE,"localhost/Regions","All Regions",$F$1,$A$1,$G$1,$AZ$2)

Do you set only the values of the base elements?

I am not sure to the answer of this questions but in the previous formula I use country,Product,Fiscal Year,Net Sales ($F$1,$A$1,$G$1,$AZ$2) as set values.I don't use any other formulas.

Thanks and Regards :)

Laura...

Stephanie

Sage

Posts: 540

Date of registration: Oct 23rd 2006

Location: Freiburg

  • Send private message

4

Wednesday, May 2nd 2007, 1:24pm

RE: The values are not going to the right elements.HELp!

Hello Laura,

Quoted

Originally posted by Laura
I use Palo.Eadd formula to insert the time,Region and Product dimension in all I use TRUE at the end.


Please use FALSE in your eadd formula otherwise you erase
all elements in your dimension when starting the import (please see also
the Appendix in the Evaluation Guide p.114) and the result is not as you
expected.

Quoted


In Palo.SetData I use splashing: I created the dimension "Measures" manually and I want to insert the values for Net Sales:

=PALO.SETDATA($AZ$1,TRUE,"localhost/Regions","All Regions",$F$1,$A$1,$G$1,$AZ$2)



If Net Sales is a consolidated element use TRUE otherwise use FALSE.
We also recommend not to use PALO.EADD and SETDATA in the same
worksheet unless you can predict the order of the formulas being
executed (see p. 72).

Quoted


Do you set only the values of the base elements?

I am not sure to the answer of this questions but in the previous formula I use country,Product,Fiscal Year,Net Sales ($F$1,$A$1,$G$1,$AZ$2) as set values.I don't use any other formulas.


Your base elements regarding to your first listing

Quoted


Region: Country-subregion-region

Product :product-line-division

Time:month-year


should be: Country, Product and Month. Fiscal year has to be splashed then.
Regarding Net Sales I don't know where it exactly belongs to.

I would recommend you the following approach: Import first of all the
complete structure and then in a second step import the values.
Be aware of the elements which are aggregated.

I hope that helps.

Regards,
Stephanie

Laura

Intermediate

  • "Laura" started this thread

Posts: 11

Date of registration: Apr 2nd 2007

  • Send private message

5

Wednesday, May 2nd 2007, 6:27pm

RE: The values are not going to the right elements.HELp!

Hello Stephanie!

Thanks very much for your help! It is working now. I was using year as a base element instead of the month. I think this is a great Forum...I had learn so much from here.

Thanks and Regards

Laura.:)

Stephanie

Sage

Posts: 540

Date of registration: Oct 23rd 2006

Location: Freiburg

  • Send private message

6

Wednesday, May 2nd 2007, 8:39pm

RE: The values are not going to the right elements.HELp!

Hello Laura,

It is good to hear that it's working! :-)

Regards,
Stephanie
Rate this thread