EssOtlSetMemberFormula() sets the formula for the specified member.
ESS_FUNC_M EssOtlSetMemberFormula (hOutline, hMember, pszFormula);
| ESS_HOUTLINE_T | hOutline |
| ESS_HMEMBER_T | hMember |
| ESS_STR_T | pszFormula |
| hOutline | Outline context handle. |
| hMember | Member handle. |
| pszFormula | Buffer containing the member formula. |
Returns 0 if successful; otherwise one of the following:
OTLAPI_ERR_SHAREDMEMBERFORMULA
OTLAPI_ERR_MEMBERCALC
#include <essapi.h>
#include <essotl.h>
ESS_STS_T sts = 0;
ESS_HOUTLINE_T hOutline;
ESS_OBJDEF_T Object;
ESS_APPNAME_T szAppName;
ESS_DBNAME_T szDbName;
ESS_OBJNAME_T szFileName;
ESS_HMEMBER_T hMember;
ESS_STR_T pszFormula;
memset(&Object, '\0', sizeof(Object));
Object.hCtx = hCtx;
Object.ObjType = ESS_OBJTYPE_OUTLINE;
strcpy(szAppName, "Sample");
strcpy(szDbName, "Basic");
strcpy(szFileName, "Basic");
Object.AppName = szAppName;
Object.DbName = szDbName;
Object.FileName = szFileName;
sts = EssOtlOpenOutline(hCtx, &Object, ESS_TRUE,
ESS_TRUE, &hOutline);
/************ Set Member Formula *************/
pszFormula = "@VAR(Budget, Actual);";
if (!sts)
{
sts = EssOtlFindMember(hOutline,
"Variance",&hMember);
}
if (!sts && hMember)
{
sts = EssOtlSetMemberFormula(hOutline, hMember,
pszFormula);
}