HPCM: Genealogy Calc Produces Unexpected Results (Doc ID 1574916.1)

Last updated on JULY 28, 2016

Applies to:

Hyperion Profitability - Version 11.1.2.1.103 and later
Information in this document applies to any platform.

Symptoms

HPCM application have a 3 stage model. The model is a full absorption model with every dollar passing through each stage. In order to produce a report, with representatives of dimensions from each stage, users run Genealogy 1-2-3 Profile. They want a report with a significant dimension from each of the 3 stages. The result is not as that what is expect, so they have broken it down to a small sample. It is expected that the direct allocation amount received in stage 3 as shown would be the same as the genealogy amount in stage 3, after running 1-2-3.

How would one produce a report with significant members (i.e. not NoMember) from each stage? Users can quite easily do a report with members from Stage 1 and 2, as they are adjacent to one another, and the Direct Allocation allocation type gives this. Similarly with Stage 2 and 3. It is assumed that to get a report with stage 1 and 3, Users can run Genealogy 1-3. The query is, how to get Significant members from all 3 Stages 1-2-3.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms