EssImport() allows importing data from different sources to the Essbase server.
ESS_FUNC_M EssImport (hCtx, pRules, pData, ppMbrErr, pMbrUser, abortOnError);
ESS_HCTX_T | hCtx |
ESS_POBJDEF_T | pRules |
ESS_POBJDEF_T | pData |
ESS_PPMBRERR_T | ppMbrErr |
ESS_PMBRUSER_T | pMbrUser |
ESS_USHORT_T | abortOnError |
hCtx | Essbase API context handle. |
pRules | Pointer to the rules file object definition structure. |
pData | Pointer to the data file object definition structure. |
ppMbrErr | Pointer to linked list of errors contained in
ESS_MBRERR_T. Possible errors are: ESS_MBRERR_BADDIM ESS_MBRERR_BADGEN ESS_MBRERR_UNKNOWN ESS_MBRERR_BADACCESS ESS_MBRERR_BADSYNTAX |
pMbrUser | Pointer to the SQL user structure (if data source is a SQL database). A NULL SQL user structure indicates a non SQL data source. |
AbortOnError | If TRUE import stops on the first error otherwise continues. |
ESS_FUNC_M ESS_Import(ESS_HCTX_T hCtx) { ESS_FUNC_M sts = ESS_STS_NOERR; ESS_SHORT_T isAbortOnError; ESS_OBJDEF_T Rules; ESS_OBJDEF_T Data; ESS_MBRUSER_T User; ESS_PMBRERR_T pMbrErr = NULL; Data.hCtx = hCtx; Data.AppName = "Olap"; Data.DbName = "Demo"; Data.ObjType = ESS_OBJTYPE_TEXT; Data.FileName = "Actuals"; Rules.hCtx = hCtx; Rules.AppName = "Olap"; Rules.DbName = "Demo"; Rules.ObjType = ESS_OBJTYPE_RULES; Rules.FileName = "Actmap"; /**********************/ /* Running conditions */ /**********************/ isAbortOnError = ESS_TRUE; sts = EssImport (hCtx, &Rules, &Data, &pMbrErr, NULL, isAbortOnError); if(pMbrErr) EssFreeMbrErr(hCtx, pMbrErr); /*******************************************************************/ /* */ /* When a SQL data source is defined in the rules file, define */ /* the variables in the ESS_OBJDEF_T Data structure as follows: */ /* Data.hCtx = hCtx; */ /* Data.AppName = NULL; */ /* Data.DbName = NULL; */ /* Data.ObjType = ESS_OBJTYPE_NONE; */ /* Data.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 = EssImport (hCtx, &Rules, &Data, &pMbrErr, */ /* &User, isAbortOnError); */ /* */ /*******************************************************************/ }EssExport()