Hyperion Essbase (MOSC)

MOSC Banner

Issue with Replicated Partition from BSO to ASO with Calculated member

edited Jun 18, 2019 5:01AM in Hyperion Essbase (MOSC) 1 commentAnswered

Hi all,

I have an issue with a partition between BSO & ASO. The partition works well on regular periods (i.e. P01-P12) but when I try to run it for P00 (our Opening Balance), which is set to DynamicCalcAndStore, only some of the numbers pull through. There is a member formula on the "P00" member in the BSO which states:

IF ( @ISMBR (@RELATIVE ("BS",0)))

     IF (@ISMBR (GL3100000X))

     "P00" = #MISSING;

     ELSE

     "P00" = @PRIOR ("P12",1,@RELATIVE("YearT",0));

ENDIF

I can see the numbers when running an AdHoc on the BSO cube, but only some of it gets pushed through to ASO via the partition. There's nothing in the logs to indicate that an error occurred during the partition, no partition process seems to be stuck. We're on version

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