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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Strange Behaviour with @memberat function.

Yashwant SawaiSep 6 2024 — edited Sep 6 2024

I am trying to make use of @memberate funciton to dynamically refer members in calculation script.

I am able to run below code successfully :-

Fix("Budget", “FY25”, “No_View”, “V1”, “CC1”)

     FIX("Jan")

    “MarketViewIndex”=5;

   “MarketShare” = MarketShare -> @MEMBERAT(@Children("Total View"), “MarketViewIndex”);

     ENDFIX

ENDFIX

I am getting error with below code (If trying to run on multiple months or CC

Fix("Budget", “FY25”, “No_View”, “V1”, “CC1”)

     FIX("Jan" : “Feb”)

    “MarketViewIndex”=5;

   “MarketShare” = MarketShare -> @MEMBERAT(@Children("Total View"), “MarketViewIndex”);

     ENDFIX

ENDFIX

Error Says : Error executing formula for [MarketShare, at or after line: [" “MarketShare” = MarketShare -> @MEMBERAT(@Children("Total View"), “MarketViewIndex”);"]] (line 4): single numerical argument expected in function [@_MEMBERAT]

Note :- account and period is dense dimension rest all are sparse.

Added on Sep 6 2024

#business-intelligence-applications, #calc-manager, #essbase21c, #hyperion, #hyperionplanning, #performance-management-applications, #planning, #planning-and-budgeting

1 comment

49 views