Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

@Allocate

3651461Feb 22 2018 — edited Feb 23 2018

Hi All,

I am using @Allocate function to copy data from one level Zero member(No_CostCentre) to all the level zero members of "Total Cost Center".

Cost Center is Sparse dimension and stored parents.

I am unable to specify the member list in @allocate which will list all level zeros of "Total Cost Center" member as target of allocation. Please help what should I use?

Cost Center

----- Total Cost Center

------------Audit

---------------1000000001 (Lev 0)

---------------1000000002

------------Finance

---------------1000000003

------------IT

No_CostCentre

WORKS:

"Processed Driver" = @ALLOCATE("No_CostCentre"->"Processed Driver",@CHILDREN("Audit"), "Processed Driver",,Add); /* Allocates data to children of Audit*/

DOES NOT WORK:

"Processed Driver" = @ALLOCATE("No_CostCentre"->"Processed Driver",@LIST(@RELATIVE ("Total CostCentre",0)), "Processed Driver",,Add); /*No error, run fast but no results*/

Thanks,

Tarini

This post has been answered by Dan Gagnon on Feb 22 2018

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 23 2018

Added on Feb 22 2018

#business-intelligence-applications, #essbase, #performance-management-applications, #planning, #planning-and-budgeting

7 comments

404 views