Hyperion Planning (MOSC)

MOSC Banner

Dense dimension behaving as sparse in PBCS?

edited Aug 19, 2019 8:06AM in Hyperion Planning (MOSC) 4 commentsAnswered

Hi all,

I've experienced a strange behavior in a PBCS application where sometimes a dense dimension seemingly behaves as a sparse one —in the meaning that some calculations don't produce any output in empty cells unless a value is manually inserted in that cell previously.

This application only singularity is that it has 3 dense dimensions (Account, Period, and ContractYear).

Here's an example:

I'm expecting cell C13 to get the same value as C9 (so Initial_Cont_Date = Start_Date)

Now look at this piece of code:

SET CACHE HIGH;

SET CALCPARALLEL 8;

SET CALCTASKDIMS 2;

SET MSG DETAIL;

SET LOCKBLOCK HIGH;

FIX

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center