310 • Developing Essbase Applications: Advanced Techniques for Finance and IT Professionals
// query members from the cube
results = cube.queryMembers("<CHILDRENOF Product <SORTNONE
<FORMAT {MBRNAMES ALTNAMES
LEVELNUMBERS}");
Note: ere is one unusual behavior with the <FORMAT command that you need to
be aware of. e <FORMAT command and the opening curly bracket ( { ) must be
separated by a space. If you fail to separate these items by a space, the rst property you
specify inside the curly brackets will not be returned.
is query returns the following tab-delimited string.
Product\t\t2\t100\tColas\t1\t200\tRoot Beer\t1\t300\tCream Soda\t1\
t400\tFruit Soda\t1\tDiet\tDiet Drinks\t1
ough you can parse multiple members that are tab-delimited, ...