Package oracle.olapi.data.source

Examples of oracle.olapi.data.source.NumberSource

201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
  {
    println("\nUsing COMPARISON_RULE_DESCENDING");

    // Get the UNIT_PRICE_AW measure and the Source for it.
    MdmMeasure mdmUnitPrice = getMdmMeasure("UNIT_PRICE_AW");
    NumberSource unitPrice = (NumberSource) mdmUnitPrice.getSource();

    // Get the PRODUCT and TIME dimensions.
    MdmPrimaryDimension mdmProdDim = getMdmPrimaryDimension("PRODUCT_AW");
    MdmPrimaryDimension mdmTimeDim = getMdmPrimaryDimension("TIME_AW");

    // Get the short description attribute for the dimensions.
    MdmAttribute mdmProdShortDescrAttr =
                mdmProdDim.getShortValueDescriptionAttribute();
    MdmAttribute mdmTimeShortDescrAttr =
                mdmTimeDim.getShortValueDescriptionAttribute();

    // Get the Source objects for the attributes.
    Source prodShortDescr = mdmProdShortDescrAttr.getSource();
    Source timeShortDescr = mdmTimeShortDescrAttr.getSource();

    // Get the default hierarchies of the dimensions and their Source objects.
    MdmLevelHierarchy mdmProdHier = (MdmLevelHierarchy)
                                     mdmProdDim.getDefaultHierarchy();
    MdmLevelHierarchy mdmTimeHIer = (MdmLevelHierarchy)
                                     mdmTimeDim.getDefaultHierarchy();
    Source prodHier = mdmProdHier.getSource();
    StringSource timeHier = (StringSource) mdmTimeHIer.getSource();

    // Get the FAMILY level of the hierarchy and the Source for it.
      MdmLevel mdmFamilyLevel =
                     getContext().getLevelByName(mdmProdHier, "FAMILY_AW");
      Source prodSel = mdmFamilyLevel.getSource();

    // Join the family elements to the product short description attribute.
    Source prodSelWithShortDescr = prodShortDescr.join(prodSel);

    // Select the May, 2001.
    Source timeSel = timeHier.selectValue("CALENDAR_YEAR_AW::MONTH_AW::59");

    // Join the time selection to the time short description attribute.
    Source timeSelWithShortDescr = timeShortDescr.join(timeSel);


    Source result =
                 prodSelWithShortDescr.join(unitPrice,
                                            unitPrice.getDataType(),
                                            Source.COMPARISON_RULE_DESCENDING,
                                            true)
                                      .join(timeSelWithShortDescr);

      prepareAndCommit();
View Full Code Here
314
315
316
317
318
319
320
321
322
323
324
325
326
    MdmMeasure mdmSales     = getMdmMeasure("SALES_AW");
    MdmMeasure mdmUnitPrice = getMdmMeasure("UNIT_PRICE_AW");

    // Get the Source objects for the measure and for the default hierarchies
    // of the dimensions.
    NumberSource units = (NumberSource) mdmUnits.getSource();
    NumberSource sales = (NumberSource) mdmSales.getSource();
    NumberSource unitPrice = (NumberSource) mdmUnitPrice.getSource();

    StringSource prodHier = (StringSource)
        getMdmPrimaryDimension("PRODUCT_AW").getDefaultHierarchy().getSource();
    StringSource custHier = (StringSource)
        getMdmPrimaryDimension("CUSTOMER_AW").getDefaultHierarchy().getSource();
View Full Code Here
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
    // Get the Source for the default product hierarchy                                   .
    StringSource prodHier = (StringSource) mdmProdHier.getSource();

    // Get the Source objects for the measure and for the default hierarchies
    // of the other dimensions.
    NumberSource units = (NumberSource) mdmUnits.getSource();

    // Get the parent attribute of the PRODUCT dimension and the Source for it
    // to use in the recursiveJoin method.
    MdmAttribute mdmProdParentAttr = mdmProdHier.getParentAttribute();
    Source prodParent = mdmProdParentAttr.getSource();

    // Get the short value description attribute and its Source.
    MdmAttribute mdmProdShortDescrAttr =
                                mdmProdDim.getShortValueDescriptionAttribute();
    Source prodShortDescr = mdmProdShortDescrAttr.getSource();

    // Select the Direct Sales channel, the year 2001, and all customers.
    Source chanSel = chanHier.selectValue("CHANNEL_PRIMARY_AW::CHANNEL_AW::2");
    Source timeSel = timeHier.selectValue("CALENDAR_YEAR_AW::YEAR_AW::4");
    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

    // Get the short value description of the products.
    Source sortedProductShortDescr = prodShortDescr.join(sortedProduct);

    // 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
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
       
    // Get the measures and the Source objects for them.
    MdmMeasure mdmUnitCost = getMdmMeasure("UNIT_COST_AW");
    MdmMeasure mdmUnitPrice = getMdmMeasure("UNIT_PRICE_AW");
       
    NumberSource unitCost = (NumberSource) mdmUnitCost.getSource();
    NumberSource unitPrice = (NumberSource) mdmUnitPrice.getSource();
   
    DataProvider dp = getContext().getDataProvider();
       
    // Get the placeholder Source for the Number data type.
    Source ph = dp.getFundamentalMetadataProvider().getNumberPlaceholder()
                                                   .getSource();
       
    // Create a Source that specifies the value to assign as the
    // value of a measure for the custom dimension member.
    Source calc = ((NumberSource)
                   (ph.join(prodHier, "PRODUCT_PRIMARY_AW::ITEM_AW::14")))
                  .plus(
                  (NumberSource)
                  (ph.join(prodHier, "PRODUCT_PRIMARY_AW::ITEM_AW::15")));
       
    // Get the level to which the dimension members belong.
    MdmLevel mdmItemLevel = getContext().getLevelByName(mdmProdPrimary,
                                                        "ITEM_AW");
       
    // Create the custom dimension member.
    MdmStandardMember mdmItem60 = mdmProdStdDim.createCustomMember(
                                                "60",  // member local value
                                                 mdmItemLevel, // member level
                                                 "4",   // parent local value
                                                 calc, // calculation Source
                                                 10);   // precedence value
       
    // Select a set of Product member values.
    StringSource prodSel = prodHier.selectValues(
                               new String[]{"PRODUCT_PRIMARY_AW::ITEM_AW::14",
                                            "PRODUCT_PRIMARY_AW::ITEM_AW::15",
                                            "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
23
24
25
26
27
28
29
30
31
32
33
34
35
36
  {
    println("Creating a Custom Member of the MdmMeasureDimension\n");
       
    // Get the measures and the Source objects for the measures.
    MdmMeasure mdmUnitPrice = getMdmMeasure("UNIT_PRICE_AW");
    NumberSource unitPrice = (NumberSource) mdmUnitPrice.getSource();
       
    MdmMeasure mdmUnitCost = getMdmMeasure("UNIT_COST_AW");
    NumberSource unitCost = (NumberSource) mdmUnitCost.getSource();
       
    // Get the primary dimensions for the measures.
    MdmPrimaryDimension mdmProdDim = getMdmPrimaryDimension("PRODUCT_AW");
    MdmPrimaryDimension mdmTimeDim = getMdmPrimaryDimension("TIME_AW");
       
View Full Code Here
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
    throws NotCommittableException
  {
    println("\nPositions in an Asymmetric Query");

    MdmMeasure mdmUnits = getMdmMeasure("UNITS_AW");
    NumberSource units = (NumberSource) mdmUnits.getSource();
    Source unitsGT1 = units.gt(1);

    MdmPrimaryDimension mdmChanDim = getMdmPrimaryDimension("CHANNEL_AW");
    MdmPrimaryDimension mdmCustDim = getMdmPrimaryDimension("CUSTOMER_AW");
    MdmLevelHierarchy mdmChanHier = (MdmLevelHierarchy)
                                     mdmChanDim.getDefaultHierarchy();
    MdmLevelHierarchy mdmCustHier = (MdmLevelHierarchy)
                                     mdmCustDim.getDefaultHierarchy();

    StringSource chanHier = (StringSource) mdmChanHier.getSource();
    StringSource custHier = (StringSource) mdmCustHier.getSource();

    Source chanSel = chanHier.selectValue("CHANNEL_PRIMARY_AW::CHANNEL_AW::2");
    Source custSel = custHier.selectValue("SHIPMENTS_AW::SHIP_TO_AW::61");

    // Create the query
    Source querySource2 = prodSel.join(chanSel)
                                 .join(custSel)
                                 .join(timeSel)
                                 .select(units.gt(1));

    //Prepare and commit the current Transaction.
    prepareAndCommit();

    // Create the Cursor. The DataProvider is dp.
View Full Code Here
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
    // Get the Source for the default product hierarchy.
    StringSource prodHier = (StringSource) mdmProdHier.getSource();
       
    // Get the Source objects for the measure and for the default hierarchies
    // of the other dimensions.
    NumberSource units = (NumberSource) mdmUnits.getSource();
    StringSource custHier = (StringSource)
        getMdmPrimaryDimension("CUSTOMER_AW").getDefaultHierarchy().getSource();
    StringSource chanHier = (StringSource)
        getMdmPrimaryDimension("CHANNEL_AW").getDefaultHierarchy().getSource();
    StringSource timeHier = (StringSource)
        getMdmPrimaryDimension("TIME_AW").getDefaultHierarchy().getSource();
       
    Source totalProds =
           prodHier.selectValue("PRODUCT_PRIMARY_AW::TOTAL_PRODUCT_AW::1");
       
    MdmLevel mdmProdFamilies = getContext().getLevelByName(mdmProdHier,
                                                           "FAMILY_AW");
    Source prodFamilies = mdmProdFamilies.getSource();
   
    // Get the Source for the short value description attribute of the dimension.
    Source prodShortLabel = mdmProdDim.getShortValueDescriptionAttribute()
                                      .getSource();
       
    Source prodFamiliesShortDesc = prodShortLabel.join(prodFamilies);
       
    NumberSource totalUnits = (NumberSource) units.joinHidden(totalProds);
       
    Source productShare = units.div(totalUnits).times(100);
       
    Source result =
          //productShare.join(prodFamilies)
View Full Code Here
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
  protected void run() throws Exception
  {
    println("Using the Lag Method");

    MdmMeasure mdmUnitPrice = getMdmMeasure("UNIT_PRICE_AW");
    NumberSource unitPrice = (NumberSource) mdmUnitPrice.getSource();

    MdmPrimaryDimension mdmProdDim = getMdmPrimaryDimension("PRODUCT_AW");
    MdmLevelHierarchy mdmProdHier = (MdmLevelHierarchy)
                                     mdmProdDim.getDefaultHierarchy();
    StringSource prodHier = (StringSource) mdmProdHier.getSource();
    Source prodSel = prodHier.selectValue("PRODUCT_PRIMARY_AW::FAMILY_AW::5");

    MdmPrimaryDimension mdmTimeDim = getMdmPrimaryDimension("TIME_AW");
    MdmLevelHierarchy mdmTimeHier = (MdmLevelHierarchy)
                                     mdmTimeDim.getDefaultHierarchy();
    StringSource timeHier = (StringSource) mdmTimeHier.getSource();

    MdmLevel mdmQuarterLevel = getContext().getLevelByName(mdmTimeHier,
                                                           "QUARTER_AW");
    Source quarterLevel = mdmQuarterLevel.getSource();

    NumberSource unitPriceLag4 = unitPrice.lag(mdmTimeHier, 4);
    Source measuresDim =
        getExpressDataProvider().createListSource(new Source[] {unitPrice,
                                                                unitPriceLag4});

    Source lagResult = measuresDim.extract()
View Full Code Here
TOP

Related Classes of oracle.olapi.data.source.NumberSource

  • com.narirelays.ems.olap.sample.chapter2.CreateCustomDimensionMember
  • com.narirelays.ems.olap.sample.chapter2.CreateCustomMeasureDimensionMember
  • com.narirelays.ems.olap.sample.chapter5.CreateCustomMemberWithAggVal
  • com.narirelays.ems.olap.sample.chapter5.CreateDependentAssignment
  • com.narirelays.ems.olap.sample.chapter5.ImplementingExtractAsACustomModel
  • com.narirelays.ems.olap.sample.chapter6.GettingShareOfUnits
  • com.narirelays.ems.olap.sample.chapter6.MakingQueriesExamples
  • com.narirelays.ems.olap.sample.chapter6.SelectingRangeWithNumberParam
  • com.narirelays.ems.olap.sample.chapter6.UsingLagMethod
  • com.narirelays.ems.olap.sample.chapter6.UsingMovingTotalMethod
    • Copyright © 2018 www.massapicom. 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.