Examples of recursiveJoin()

Examples of oracle.olapi.data.source.StringSource.recursiveJoin()

67
68
69
70
71
72
73
74
75
76
77
            shipments.selectValue("SHIPMENTS_AW::WAREHOUSE_AW::17");
   
    // Example 1: Using the full recursiveJoin method signature.
    // Create a Source that specifies the parent value and its children.
    Source parentAndChildren =
            shipments.recursiveJoin(custDim.value(),
                                    parentValue,
                                    shipmentsParentAttr,
                                    Source.COMPARISON_RULE_SELECT,
                                    true,
                                    true,
View Full Code Here

Examples of oracle.olapi.data.source.StringSource.recursiveJoin()

89
90
91
92
93
94
95
96
97
98
99
    // Example 2: recursiveJoin(Source joined, String comparison,
    //                          Source parent, int comparisonRule)
    // Using a single String as the comparison, select the parent values and
    // their children.
    Source parentAndChildrenShortcut =
            shipments.recursiveJoin(custDim.value(),
                                    "SHIPMENTS_AW::WAREHOUSE_AW::17",
                                    shipmentsParentAttr,
                                    Source.COMPARISON_RULE_SELECT);
    // Add the value descriptions to the selections.
    Source parentAndChildrenShortcutWithDescr =
View Full Code Here

Examples of oracle.olapi.data.source.StringSource.recursiveJoin()

107
108
109
110
111
112
113
114
115
116
117
    // Example 3: recursiveJoin(Source joined, String[] comparison,
    //                          Source parent, int comparisonRule)
    // Using a String array as the comparison, select the parent values and
    // their children.
    Source parentsAndChildrenShortcut =
            shipments.recursiveJoin(custDim.value(),
                                    new String[]
                                      {"SHIPMENTS_AW::WAREHOUSE_AW::17",
                                       "SHIPMENTS_AW::WAREHOUSE_AW::18"},
                                    shipmentsParentAttr,
                                    Source.COMPARISON_RULE_SELECT);
View Full Code Here

Examples of oracle.olapi.data.source.StringSource.recursiveJoin()

439
440
441
442
443
444
445
446
447
448
449
    Source custSel = custHier.selectValue("SHIPMENTS_AW::TOTAL_CUSTOMER_AW::1");

    // Sort all products hierarchically in ascending order of units sold,
    // with parents first.
    Source sortedProduct =
                      prodHier.recursiveJoin(units,
                                             units.getDataType(),
                                             prodParent,
                                             Source.COMPARISON_RULE_ASCENDING,
                                             true,  // Parents first
                                             true); // Restrict parents to base
View Full Code Here

Examples of oracle.olapi.data.source.StringSource.recursiveJoin()

44
45
46
47
48
49
50
51
52
53
54
    StringSource prodHier = (StringSource) mdmProdHier.getSource();
    Source prodParent = mdmProdParentAttr.getSource();

    // Sort products hierarchically, parents first, in ascending order
    // without using the package attribute.
    Source result1 = prodHier.recursiveJoin(prodDim.value(),
                                            prodHier.getDataType(),
                                            prodParent,
                                            Source.COMPARISON_RULE_ASCENDING);

    // Sort products hierarchically, parents first, in ascending order
View Full Code Here

Examples of oracle.olapi.data.source.StringSource.recursiveJoin()

54
55
56
57
58
59
60
61
62
63
64
    // Sort products hierarchically, parents first, in ascending order
    // by package attribute value with null values first.
    // Nulls first is the default, so this should this should produce
    // the same results as COMPARISON_RULE_ASCENDING.
    Source sortedHierNullsFirst =
          prodHier.recursiveJoin(prodPkgAttr,
                                 prodPkgAttr.getDataType(),
                                 prodParent,
                                 Source.COMPARISON_RULE_ASCENDING_NULLS_FIRST);
    Source result2 = prodPkgAttr.join(sortedHierNullsFirst);
View Full Code Here

Examples of oracle.olapi.data.source.StringSource.recursiveJoin()

63
64
65
66
67
68
69
70
71
72
73
    Source result2 = prodPkgAttr.join(sortedHierNullsFirst);

    // Sort all products hierarchically, parents first, in ascending order
    // by package attribute value with null values first.
    Source sortedHierNullsLast =
          prodHier.recursiveJoin(prodPkgAttr,
                                 prodPkgAttr.getDataType(),
                                 prodParent,
                                 Source.COMPARISON_RULE_DESCENDING_NULLS_FIRST);

    Source result3 = prodPkgAttr.join(sortedHierNullsLast);
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.