Examples of MdmStandardDimension

Examples of oracle.olapi.metadata.mdm.MdmStandardDimension

25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
{
   
  protected void run() throws Exception
  {
    // Get the Dimension objects.
    MdmStandardDimension mdmProdStdDim =
                (MdmStandardDimension) getMdmPrimaryDimension("MEDIA");
    MdmPrimaryDimension mdmTimeDim = getMdmPrimaryDimension("MYTIME");
       
    // Get the Source for the Product dimension.
    Source prodStdDim = mdmProdStdDim.getSource();
       
    // Get the default hierarchies of the dimensions and the Source objects for
    // them.
    MdmLevelHierarchy mdmCalendar = (MdmLevelHierarchy)
                                     mdmTimeDim.getDefaultHierarchy();
    MdmLevelHierarchy mdmProdPrimary = (MdmLevelHierarchy)
                                     mdmProdStdDim.getDefaultHierarchy();
    StringSource calendar = (StringSource) mdmCalendar.getSource();
    StringSource prodHier = (StringSource) mdmProdPrimary.getSource();
       
    // Get the measures and the Source objects for them.
    MdmMeasure mdmUnitCost = getMdmMeasure("AMOUNT");
View Full Code Here

Examples of oracle.olapi.metadata.mdm.MdmStandardDimension

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
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
     MdmMeasure mdmSales = getMdmMeasure("SALES_AW");
     NumberSource sales = (NumberSource) mdmSales.getSource();
   
    // Get the dimensions. Cast the Product dimension as an MdmStandardDimension
    // so that it has a createCustomMember method.
    MdmStandardDimension mdmProdStdDim = (MdmStandardDimension)
    getMdmPrimaryDimension("PRODUCT_AW");
    MdmPrimaryDimension mdmTimeDim = getMdmPrimaryDimension("TIME_AW");
    MdmPrimaryDimension mdmChanDim = getMdmPrimaryDimension("CHANNEL_AW");
    MdmPrimaryDimension mdmCustDim = getMdmPrimaryDimension("CUSTOMER_AW");
   
    // Get the Source for the product dimension.
    Source prodStdDim = mdmProdStdDim.getSource();
       
    // Get the marketing manager attribute and the Source for it.   
    MdmAttribute mdmMktMngrAttr = getContext().getAttributeByName(mdmProdStdDim,
                                                        "MARKETING_MANAGER_AW");
    Source mktMngrAttr = mdmMktMngrAttr.getSource();
       
    // Get the default hierarchies of the dimensions and the Source objects
    // for them.
    MdmLevelHierarchy mdmCalendar = (MdmLevelHierarchy)
                                     mdmTimeDim.getDefaultHierarchy();
    MdmLevelHierarchy mdmProdHier = (MdmLevelHierarchy)
                                     mdmProdStdDim.getDefaultHierarchy();
    MdmLevelHierarchy mdmChanHier = (MdmLevelHierarchy)
                                     mdmChanDim.getDefaultHierarchy();
    MdmLevelHierarchy mdmShipHier = (MdmLevelHierarchy)
                                     mdmCustDim.getDefaultHierarchy();
   
    StringSource calendar = (StringSource) mdmCalendar.getSource();
    StringSource prodHier = (StringSource) mdmProdHier.getSource();
    StringSource chanHier = (StringSource) mdmChanHier.getSource();
    StringSource shipHier = (StringSource) mdmShipHier.getSource();
   
    // Get the placeholder Source for the Number data type.
    Source ph = dp.getFundamentalMetadataProvider()
                  .getNumberPlaceholder()
                  .getSource();
   
    // Get the level to which the dimension members belong.
    MdmLevel mdmItemLevel = getContext().getLevelByName(mdmProdHier,
                                                        "ITEM_AW");

    // Get the Source for the ITEM level.
    Source itemLevel = mdmItemLevel.getSource();
   
    // Select the members of the level that are managed by a marketing manager.
    Source prodForManager = itemLevel.join(mktMngrAttr, "Jackson");
   
    // Get the short value description attribute for Product and the Source
    // for it.
    MdmAttribute mdmProdShortDescr =
                         mdmProdStdDim.getShortValueDescriptionAttribute();
    Source prodShortDescr = mdmProdShortDescr.getSource();
   
    // Create the calculation Source, which specifies the aggregation of
    // the selected products.
    Source calc = ((NumberSource)
              (ph.join(prodHier,
                   new String[] {"PRODUCT_PRIMARY_AW::ITEM_AW::24",
                                 "PRODUCT_PRIMARY_AW::ITEM_AW::25",
                                 "PRODUCT_PRIMARY_AW::ITEM_AW::26",
                                 "PRODUCT_PRIMARY_AW::ITEM_AW::33",
                                 "PRODUCT_PRIMARY_AW::ITEM_AW::34",
                                 "PRODUCT_PRIMARY_AW::ITEM_AW::35",
                                 "PRODUCT_PRIMARY_AW::ITEM_AW::36",
                                "PRODUCT_PRIMARY_AW::ITEM_AW::37",
                                 "PRODUCT_PRIMARY_AW::ITEM_AW::38",
                                 "PRODUCT_PRIMARY_AW::ITEM_AW::39"}))).total();
                       
    // Create the custom dimension member.
    MdmStandardMember mdmMktMngrTotal =
            mdmProdStdDim.createCustomMember("65",  // member local value
                                             mdmItemLevel, // member level
                                             "4",   // parent local value
                                             calc, // calculation Source
                                             10);   // precedence value
   
View Full Code Here

Examples of oracle.olapi.metadata.mdm.MdmStandardDimension

31
32
33
34
35
36
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
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
    // Get the DataProvider.
    DataProvider dp = getContext().getDataProvider();
   
    // Get the dimensions. Cast the MdmPrimaryDimension for the Product dimension
    // as an MdmStandardDimension so it has a createCustomMember method.
    MdmStandardDimension mdmProdStdDim = (MdmStandardDimension)
                                          getMdmPrimaryDimension("PRODUCT_AW");
    MdmPrimaryDimension mdmTimeDim = getMdmPrimaryDimension("TIME_AW");
       
    // Get the Source for the Product dimension.
    Source prodStdDim = mdmProdStdDim.getSource();
       
    // Get the default hierarchies of the dimensions and the Source objects
    // for them.
    MdmLevelHierarchy mdmCalendar =
                        (MdmLevelHierarchy) mdmTimeDim.getDefaultHierarchy();
    MdmLevelHierarchy mdmProdPrimary =
                     (MdmLevelHierarchy) mdmProdStdDim.getDefaultHierarchy();
    StringSource calendar = (StringSource) mdmCalendar.getSource();
    StringSource prodPrimary = (StringSource) mdmProdPrimary.getSource();
       
    // Get the Unit Cost and Unit Price 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();
       
    // Get the level to which the dimension members belong.
    MdmLevel mdmItemLevel = getContext().getLevelByName(mdmProdPrimary,
                                                        "ITEM_AW");
       
    // Get the placeholder Source for the Number data type.
    Source ph = dp.getFundamentalMetadataProvider()
                  .getNumberPlaceholder()
                  .getSource();
       
    // Get a Source that specifies the value to assign for the custom member.
    Source calc = ((NumberSource)
                   (ph.join(prodPrimary, "PRODUCT_PRIMARY_AW::ITEM_AW::14")))
                   .plus(
                   (NumberSource)
                   (ph.join(prodPrimary, "PRODUCT_PRIMARY_AW::ITEM_AW::15")));
       
       
    // Create a custom member of the Item level of the Product dimension.
    MdmStandardMember mdmItem60 =
              mdmProdStdDim.createCustomMember("60",  // member local value
                                                mdmItemLevel, // member level
                                                "4",   // parent local value
                                                calc, // calculation Source
                                                10);   // precedence value
       
    // Get a Source that specifies a value to assign for another custom member
    // that depends on the value to assign for the first custom member.
    Source dependentCalc = ((NumberSource)
                            (ph.join(prodPrimary,
                                     "PRODUCT_PRIMARY_AW::ITEM_AW::60")))
                            .plus(
                            (NumberSource)
                            (ph.join(prodPrimary,
                                     "PRODUCT_PRIMARY_AW::ITEM_AW::13")));
       
    // Create another custom member of the Item level of the Product dimension.
    MdmStandardMember mdmItem61 =
                          mdmProdStdDim.createCustomMember("61",
                                                           mdmItemLevel,
                                                           "4",
                                                           dependentCalc,
                                                           10);
       
View Full Code Here

Examples of oracle.olapi.metadata.mdm.MdmStandardDimension

24
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
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
{
   
  protected void run() throws Exception
  {
    // Get the Dimension objects.
    MdmStandardDimension mdmProdStdDim =
                (MdmStandardDimension) getMdmPrimaryDimension("PRODUCT_AW");
    MdmPrimaryDimension mdmTimeDim = getMdmPrimaryDimension("TIME_AW");
       
    // Get the Source for the Product dimension.
    Source prodStdDim = mdmProdStdDim.getSource();
       
    // Get the default hierarchies of the dimensions and the Source objects for
    // them.
    MdmLevelHierarchy mdmCalendar = (MdmLevelHierarchy)
                                     mdmTimeDim.getDefaultHierarchy();
    MdmLevelHierarchy mdmProdPrimary = (MdmLevelHierarchy)
                                     mdmProdStdDim.getDefaultHierarchy();
    StringSource calendar = (StringSource) mdmCalendar.getSource();
    StringSource prodHier = (StringSource) mdmProdPrimary.getSource();
       
    // 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
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.