Skip to Main Content

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!

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.

Comments