EssBuildDimension() allows the addition or removal of members from the outline in the active database from a data file and rules file.
ESS_FUNC_M EssBuildDimension (hCtx, rulesObj, dataObj, mbrUser, ErrorName);
| ESS_HCTX_T | hCtx |
| ESS_POBJDEF_T | pRulesObj |
| ESS_POBJDEF_T | pDataObj |
| ESS_PMBRUSER_T | pMbrUser |
| ESS_STR_T | ErrorName |
| hCtx | Essbase API context handle. |
| pRulesObj | Pointer to rules file object definition structure. |
| pDataObj | Pointer to data file object definition structure. |
| pMbrUser | SQL user structure (if data source is SQL database). A NULL SQL user structure indicates a non SQL data source. |
| ErrorName | Name of error output file on client. |
None.
This function requires the caller to have database design privilege for the specified database (ESS_PRIV_DBDESIGN).
ESS_FUNC_M
ESS_BuildDim(ESS_HCTX_T hCtx)
{
ESS_FUNC_M sts = ESS_STS_NOERR;
ESS_OBJDEF_T RulesObj;
ESS_OBJDEF_T DataObj;
ESS_MBRUSER_T User;
ESS_STR_T ErrorName;
RulesObj.hCtx = hCtx;
RulesObj.FileName = "Prodmap";
RulesObj.ObjType = ESS_OBJTYPE_RULES;
DataObj.hCtx = hCtx;
DataObj.FileName = "Prodtabl";
DataObj.ObjType = ESS_OBJTYPE_TEXT;
ErrorName = "builddim.err";
sts = EssBuildDimension (hCtx, &RulesObj, &DataObj,
NULL, ErrorName);
return (sts);
/*******************************************************************/
/* */
/* When a SQL data source is defined in the rules file, define */
/* the variables in the ESS_OBJDEF_T DataObj structure as follows: */
/* DataObj.hCtx = hCtx; */
/* DataObj.AppName = NULL; */
/* DataObj.DbName = NULL; */
/* DataObj.ObjType = ESS_OBJTYPE_NONE; */
/* DataObj.FileName = NULL; */
/* */
/* Also, provide strings for the variables in the ESS_MBRUSER_T */
/* User structure; for example: */
/* User.User = "Dbusernm"; */
/* User.Password = "Dbpasswd"; */
/* */
/* Use a blank string for User and Password, if the SQL source */
/* does not require user and password information; for example: */
/* User.User = ""; */
/* User.Password = ""; */
/* */
/* Also, define sts as follows: */
/* sts = EssBuildDimension (hCtx, &RulesObj, &DataObj, */
/* &User, ErrorName); */
/* */
/*******************************************************************/
}
EssImport()
EssBuildDimFile
EssBuildDimStart
EssOtlRestructure()