Package oracle.olapi.data.source

Examples of oracle.olapi.data.source.NumberSource.join()

82
83
84
85
86
87
88
89
90
91
92
                                            "MEDIA::MEDIA::1"});
                       
    // Produce a query that specifies the unit price and the unit cost for the
    // selected products and the specified month. The month does not appear
    // in the result.
    Source result = unitPrice.join(unitCost)
                             .join(prodSel)
                             .join(calendar, "TIMEHIER::DAY::20110101");
                       
    // Prepare and commit the current Transaction.
    prepareAndCommit();
View Full Code Here
222
223
224
225
226
227
228
229
230
231
232
                                            "CALENDAR_YEAR_AW::MONTH_AW::43",
                                            "CALENDAR_YEAR_AW::MONTH_AW::44",
                                            "CALENDAR_YEAR_AW::MONTH_AW::45"});

    // Code from the example.
    Source unitsForSelections = units.join(prodSel)
                                     .join(custSel)
                                     .join(timeSel)
                                     .join(chanSel);

    // Prepare and commit the current Transaction.
View Full Code Here
222
223
224
225
226
227
228
229
230
231
232
                                            "CALENDAR_YEAR_AW::MONTH_AW::43",
                                            "CALENDAR_YEAR_AW::MONTH_AW::44",
                                            "CALENDAR_YEAR_AW::MONTH_AW::45"});

    // Code from the example.
    Source unitsForSelections = units.join(prodSel)
                                     .join(custSel)
                                     .join(timeSel)
                                     .join(chanSel);

    // Prepare and commit the current Transaction.
View Full Code Here
127
128
129
130
131
132
133
134
135
136
137
                                        "PRODUCT_PRIMARY_AW::ITEM_AW::65"));
   
    // Create a query that specifies the units sold of the selected products,
    // including a short description of the products, for the specified customer
    // through all sales channels in the specified year.
    Source result = sales.join(prodShortDescr.join(mktMngrWithTotal))
                         .join(shipHier, "SHIPMENTS_AW::SHIP_TO_AW::106")
                         .join(chanHier, "CHANNEL_PRIMARY_AW::TOTAL_CHANNEL_AW::1")
                         .join(calendar, "CALENDAR_YEAR_AW::YEAR_AW::3");
   
    // Prepare and commit the current Transaction.
View Full Code Here
108
109
110
111
112
113
114
115
116
117
118
                                             "PRODUCT_PRIMARY_AW::ITEM_AW::61"
                                             });
       
    // Produce a Source that specifies the Unit Cost and Unit Price values
    // for the selected Product and Time dimension members.
    Source result = unitPrice.join(unitCost)
                             .join(prodSel)
                             .join(calendar, "CALENDAR_YEAR_AW::MONTH_AW::47");
       
    // Prepare and commit the current Transaction.
    prepareAndCommit();
View Full Code Here
82
83
84
85
86
87
88
89
90
91
92
    Source custSel = custHier.selectValue("SHIPMENTS_AW::SHIP_TO_AW::52");
    Source timeSel = timeHier.selectValue("CALENDAR_YEAR_AW::MONTH_AW::55");

    // Produce a Source that specifies the units values for the selected
    // dimension values.
    Source unitsSel = units.join(timeSel).join(custSel).join(prodSel);

    // Create aliases for the Channel dimension hierarchy.
    Source chanAlias1 = chanHier.alias();
    Source chanAlias2 = chanHier.alias();
View Full Code Here
454
455
456
457
458
459
460
461
462
463
464
    // Produce a Source that has the units sold measure data as its element
    // values and sortedProductShortDescr as its output.
    // Since the other dimensions are all single values, use joinHidden so
    // the are not outputs of the result.

    Source result = units.join(sortedProductShortDescr)
                         .joinHidden(custSel)
                         .joinHidden(chanSel)
                         .joinHidden(timeSel);

    // Prepare and commit the current Transaction.
View Full Code Here
82
83
84
85
86
87
88
89
90
91
92
                                            "PRODUCT_PRIMARY_AW::ITEM_AW::60"});
                       
    // Produce a query that specifies the unit price and the unit cost for the
    // selected products and the specified month. The month does not appear
    // in the result.
    Source result = unitPrice.join(unitCost)
                             .join(prodSel)
                             .join(calendar, "CALENDAR_YEAR_AW::MONTH_AW::47");
                       
    // Prepare and commit the current Transaction.
    prepareAndCommit();
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.