You are not logged in.

consolidation of multiple values calculated with rules

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.

ap_OM

Professional

  • "ap_OM" started this thread

Posts: 17

Date of registration: May 21st 2009

  • Send private message

1

Sunday, June 7th 2009, 6:04pm

consolidation of multiple values calculated with rules

Hello,

I have the following problem:

I want to consolidate some Values to "Gewinn KK":

Garantierte Einsparung 1
Zusaetzliche Ertraege aus relativen Einsparungen 1
laufende Managementpauschale -1

if i just consolidate
Garantierte Einsparung 1
Zusaetzliche Ertraege aus relativen Einsparungen 1

it is working but if I add "laufende Managementpauschale". Just the value of "laufende Managementpauschale" is shown in "Gewinn KK" (see the attached images)

All three values above are calculated via rules (see the attached images)

I tried to recalculate everything (hit F9), restart palo and excel, restart the computer, set the rules cache to 0 in the palo.ini but nothing have had any effect. Any further ideas?

This post has been edited 1 times, last edit by "ap_OM" (Jun 7th 2009, 6:06pm)

Cuitlahua

Professional

  • "Cuitlahua" is male

Posts: 32

Date of registration: Feb 27th 2009

Location: Hungary

  • Send private message

2

Monday, June 8th 2009, 12:19pm

RE: consolidation of multiple values calculated with rules

Hello!


Maybe,

this is because of the Marker technology of Palo. In Palo, you do not have to marker a cube completely, you are allowed to "forget" to marker certain rules. Now let's suppose, you have such a half-markered cube. If you query the sum of a subcube that contains only markered cells or only unmarkered cells, you will get the correct results in both case. But if you query a subcube where there are markered and also unmarkered cells, then the values of the unmarkered cells will not be calculated and omitted from consolidation.

Looking at your rules, you marker the rules for "laufende Managementpauschale" and do not marker the other two elements. That may cause the phenomenon described.


C.

ap_OM

Professional

  • "ap_OM" started this thread

Posts: 17

Date of registration: May 21st 2009

  • Send private message

3

Monday, June 8th 2009, 1:18pm

Hello and thank you a lot. I had no idea about this PALO-Marker-specifications. I removed the Marker in the other two rules (I can't add Markers to the two rules, because then the calculation is not functioning. I don't know why. I just can guess, that this is also a problem with the marker, because this two rules are refering to other rules). Now it's working.

kind regards

Alex

realquo

Sage

  • "realquo" is male

Posts: 257

Date of registration: Mar 11th 2009

Location: Italy

Occupation: BI Consultant

  • Send private message

4

Monday, March 26th 2012, 1:56pm

You made my day, thanks!!

Hi,
I just wanted to share the fact that I was stuck with aggregations of markers-calculated leaf elements not working properly (it worked for subcubes, not for the entire cube): marking all the 2 elements of the calculation ([[X]] x [[Y]] instead of [X] x [[Y]] made it working perfectly,
Now I'm on track again, thanks!!!


:thumbsup: :thumbsup: :thumbsup: :thumbsup: :thumbsup:

Quoted from "Cuitlahua"



Maybe,

this is because of the Marker technology of Palo. In Palo, you do not have to marker a cube completely, you are allowed to "forget" to marker certain rules. Now let's suppose, you have such a half-markered cube. If you query the sum of a subcube that contains only markered cells or only unmarkered cells, you will get the correct results in both case. But if you query a subcube where there are markered and also unmarkered cells, then the values of the unmarkered cells will not be calculated and omitted from consolidation.

Looking at your rules, you marker the rules for "laufende Managementpauschale" and do not marker the other two elements. That may cause the phenomenon described.


C.
[/b][/b]
Rate this thread