Database Reference
In-Depth Information
This parsing routine simply prints the name to the command line.
Name: 100-10
Name: 100-20
Name: 100-30
Name: 100
This example shows the results of a very simple query, but the query language has a
number of options for specifying the members to be returned, how they are sorted and
formatted, and for specifying different properties you can return using this method. Let
us next look at the options available for specifying members. here is an example of a
query that specifies the members based on a relationship.
// query members from the cube
results = cube.queryMembers("<DESCENDANTSOF Product");
When you run this query and parse the results, you get the all of the members in the
Product dimension.
Name: 100-10
Name: 100-20
Name: 100-30
Name: 100
Name: 200-10
Name: 200-20
Name: 200-30
Name: 200-40
Name: 200
Name: 300-10
Name: 300-20
Name: 300-30
Name: 300
Name: 400-10
Name: 400-20
Name: 400-30
Name: 400
Name: 100-20
Name: 200-20
Name: 300-30
Name: Diet
Name: Product
The documented commands you can use for specifying relationships include the
following:
<CHILDRENOF
<ALLINSAMEDIM
<DIMTOP
<OFSAMEGENERATION
<ONSAMELEVELAS
<ANCESTORSOF
<PARENTOF
<DESCENDANTSOF
