ESS_FUNC_M EssQueryDatabaseMembers (hCtx, mbrQuery);
ESS_HCTX_T | hCtx |
ESS_STR_T | mbrQuery |
hCtx | Essbase API context handle. |
mbrQuery | Member query string. A query string is a command similar to a report specification. For valid query strings see the Notes topic. |
Not all member selection strings are supported in the relational store. This function can return relational information on the following member selection strings:
mbrQuery ==: <selectionstring> [<sortcommand> [<outputcommand>] ]
<CHILDRENOF <ALLINSAMEDIM <DIMTOP <OFSAMEGENERATION <ONSAMELEVELAS <ANCESTORSOF <PARENTOF <DESCENDANTSOF <ALLSIBLINGSOF <LSIBLINGOF
<SORTASCENDING <SORTDESCENDING <SORTNONE <SORTMBRNAMES <SORTALTNAMES <SORTMBRNUMBERS <SORTDIMNUMBERS <SORTLEVELNUMBERS <SORTGENERATION
<outputcommand> ==: Item [separator] | FORMAT {<item> <separator> }
<outputcommand> ==: <MBRNAMES | <ALTNAMES | <MBRNUMBERS | <DIMNUMBERS | <LEVELNUMBERS | <GENERATIONS | <CALCSTRINGS | <UCALCS | <TABSEPARATED | <SPACESEPARATED | <COMMASEPARATED | <NEWLINESEPARATED | <ATTRIBUTES
<FORMAT <item> [<separator>] {<item> [<separator>]}The valid values for <item> are:
MBRNAMES ALTNAMES MBRNUMBERS DIMNUMBERS LEVELNUMBERS GENERATIONS CALCSTRINGS UCALCS ATTRIBUTESATTRIBUTES are listed as the number of attributes followed by a tab-separated list of attribute names.
TABSEPARATED SPACESEPARATED COMMASEPARATED NEWLINESEPARATEDIf you do not specify a separator, the default is TABSEPARATED.
login "local" "user1" "password" "" "" select "attr" "attr" GetMembers "<NEWLINESEPARATED <FORMAT { MBRNAMES SPACESEPARATED ALTNAMES TABSEPARATED MBRNUMBERS SPACESEPARATED DIMNUMBERS TABSEPARATED LEVELNUMBERS SPACESEPARATED GENERATIONS TABSEPARATED CALCSTRINGS SPACESEPARATED UCALCS TABSEPARATED DIMTYPES SPACESEPARATED STATUSES TABSEPARATED ATTRIBUTES } <DESCENDANTS Product "
ESS_STS_T ESS_GetMembers (ESS_HCTX_T hCtx, ESS_HINST_T hInst ) { ESS_STS_T sts = ESS_STS_NOERR; ESS_STR_T mString = NULL; sts = EssQueryDatabaseMembers (hCtx, "<ALLINSAMEDIM Year"); if (!sts) sts = EssGetString (hCtx, &mString); while ((!sts) && (mString != NULL)) { printf ("%s\r\n", mString); EssFree (hInst, mString); sts = EssGetString (hCtx, &mString); } return(sts); }EssCheckMemberName()