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 -- returns ICHILDRENOF <ALLINSAMEDIM <DIMTOP <OFSAMEGENERATION <ONSAMELEVELAS <ANCESTORSOF -- returns IANCESTORSOF <PARENTOF <DESCENDANTSOF -- returns IDESCENDANTSOF <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()