Palo Community Forum

I've created a cube that tracks data for people and events. One of my extracts creates a tree of people, consolidated under a root element called "All People". After populating the cube, I use the server browser to confirm that a certain value was entered correctly (see "path-SpecificPerson" attachment). This path shows a specific person's entry, and appears correct. However, when I change the path to "All People" instead of my test person, I no longer see the value (see "path-AllPeople" attachment). The fourth dimension in the cube is people, "3" is my test person and "0" is "All People". I get similar results when using the Excel add-in to view data from my cube: I can see a specific person's event count no problem, but if I select "All People" (or any other consolidation, like "All Years" or "All Months" etc), I see a blank cell.

Maybe I don't understand how consolidations work in Palo, but I would expect that if my test value shows up for a specific person, it will also show up when I select "All People", because my test person belongs to that consolidation.

I don't know if I'm explaining this very well, so let me try an example: under "All People", suppose I have Bob, Fred, and Steve. Bob has 1 event, Fred has 2 events, and Steve has 3 events. If I select a specific person, I see the count of events for that one person, but if I select "All People", should I not see the sum of all events for all three people? This is what I expect but it is not what I am seeing.

Quoted

Originally posted by holger_b

these are all string type cells, right? Only numeric values will be consolidated.

Ah, that might explain what I am seeing. How can I force this measure to be numeric? It seems to default to string type, even when I explicitly tell it that it's a numeric value. You can see in the following attachments that in my extract, my "count" measure is set to be a numeric type, and in my transform, I am again specifying numeric type. However, after the cube is generated, it for some reason shows up as string type!

Even more strange, if I look at my Measures dimension in the server browser, I see that all my measures, including Count, are in fact correctly marked as being numeric type, as seen in this new attachment.

Quoted

Originally posted by h_decker
Hi,
how about the other dimensions? the whole cell coordinate must be numeric. If one of the coordinates element is of type string, the whole cell will be a string cell. Maybe that helps.
Holger

h_decker, I owe you a beer - one of my other dimensions was incorrectly set to string type, which was causing this problem. My consolidations now work as I expect and everything looks great. Thank you for the help!