You are not logged in.

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.

JMTOURBEZ

Trainee

  • "JMTOURBEZ" is male
  • "JMTOURBEZ" started this thread

Posts: 1

Date of registration: Jul 9th 2009

Location: FRANCE

  • Send private message

1

Thursday, July 9th 2009, 5:38pm

Time Function / Time Slice

Hi,

I would a time comparaison :

Quantity sale for 01/2009 compare to Quantity sale for 01/2008
I have a time dimension (year, period, week 4/4/5) and a measure dimension

Someone can tell me if a palo function exist or how can i make it ?

Thanks for all
JMTOURBEZ
Consultant Manager - KEYRUS

  • "realquo" is male

Posts: 255

Date of registration: Mar 11th 2009

Location: Italy

Occupation: BI Consultant

  • Send private message

2

Friday, July 10th 2009, 4:01pm

Hi,
just a question in order to able to help you: "period" is "month"?

Posts: 122

Date of registration: Aug 1st 2007

  • Send private message

3

Saturday, July 11th 2009, 2:34am

I hate the 4-4-5 weeks!!!

What you can do is to have a consolidation called

"01/2009 vs 01/2008"

Have 2 children underneath it

"01/2008" weighting = -1
"01/2009" weighting = 1

With the difference in weighting, you should be able to get the comparison. Just run a direct retrieve of the consolidation "01/2009 vs 01/2008".

Kind Regards,

Jimmy

Rate this thread