EssSetSpanRelationalPartition() sets the Boolean bSpanRelPart field informing Essbase that pertinent data exists in an attached relational store. Some other API functions, such as EssQueryDatabaseMembers, read bSpanRelPart and access the relational store if bSpanRelPart is set.
ESS_FUNC_M EssSetSpanRelationalPartition (hCtx);
ESS_HCTX_T | hCtx |
hCtx | Essbase API context handle. |
Several API functions have been enhanced to retrieve information from relational stores.
ESS_FUNC_M ESS_Report (ESS_HCTX_T hCtx, ESS_HINST_T hInst ) { ESS_FUNC_M sts = ESS_STS_NOERR; ESS_STR_T rString = NULL; sts = EssBeginReport (hCtx,ESS_TRUE,ESS_FALSE); if (!sts) sts = EssSendString (hCtx, "<Desc Year !"); if (!sts) sts = EssSetSpanRelationalPartition (hCtx); /************** * Get report * **************/ if (!sts) sts = EssGetString (hCtx, &rString); while ((!sts) && (rString != NULL)) { printf ("%s", rString); EssFree (hInst, rString); sts = EssGetString (hCtx, &rString); } printf ("\r\n"); return(sts); }EssClearSpanRelationalPartition