ESS_PERF_CUSTCALC_T

This structure stores information to be used for performing custom calculations with aggregate storage databases.

For complete information about writing and executing custom calculation scripts, see “Performing Custom Calculations and Allocations on Aggregate Storage Databases” in the Oracle Essbase Database Administrator's Guide.

typedef struct ESS_PERF_CUSTCALC_T 
{
    ESS_STR_T      pov;
    ESS_STR_T      script;
    ESS_STR_T      target;
    ESS_STR_T      debitMember;
    ESS_STR_T      creditMember;
    ESS_STR_T      offset;
    ESS_STR_T      sourceRegion;
    ESS_ULONG64_T    groupID;
    ESS_ULONG64_T    ruleID;
} ESS_PERF_CUSTCALC_T;
Data TypeFieldDescription
ESS_STR_TpovMDX set expression specifying script execution area within the database
ESS_STR_TscriptContents of the custom calculation script. Should include multiple assignments of the form Target := Formula; where Target is an MDX tuple expression and Formula is an MDX numeric value expression. The script can contain only MDX tuple expressions and arithmetic operators (+ ,- , * , /). MDX functions are not supported.
ESS_STR_TtargetOptional: MDX tuple expression specifying location, in combination with pov and the left-hand side of the assignment statements in script, to which calculation results will be written. If dimensions overlap , the order for resolving conflicts is assignment statements first, then target, then pov.
ESS_STR_TdebitMemberOptional: MDX member expression specifying the debit member. Positive results are stored here. If empty, debit/credit processing is not performed.
ESS_STR_TcreditMemberOptional: MDX member expression specifying the credit member. Negative results will be stored here. If empty, debit/credit processing is not performed.
ESS_STR_ToffsetOptional: MDX tuple expression specifying the location for offset entries, if any, to be written
ESS_STR_TsourceRegionMDX set expression indicating the database region referred to by the right-hand sides of the formulas in the script
ESS_ULONG64_TgroupIDInternal use only. Always enter 0.
ESS_ULONG64_TruleIDInternal use only. Always enter 0.