Package oracle.olapi.data.source

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

35
36
37
38
39
40
41
42
43
44
45
//    MdmPrimaryDimension mdmProdDim = getMdmPrimaryDimension("MEDIA");
    MdmLevelHierarchy mdmTimeHier = (MdmLevelHierarchy)
                                     mdmTimeDim.getDefaultHierarchy();
    StringSource timeHier =  (StringSource) mdmTimeHier.getSource();
       
    Source levelElement = timeHier.selectValue("TIMEHIER::MONTH::MONTH_2011-M01");
       
    // Get the Source for the short label attribute of the dimension.
    Source prodShortLabel = mdmTimeDim.getShortValueDescriptionAttribute()
                                      .getSource();
       
View Full Code Here
133
134
135
136
137
138
139
140
141
142
143
      // Reverse the ancestors relation to get the descendants relation.
      Source mktSegmentDescendants =
                mktSegment.join(mktSegmentAncestors, mktSegment.value());
     
      // Select an element of the hierarchy.
      Source selVal = mktSegment.selectValue(node);

      // Select the descendants of the specified element.
      Source selValDescendants = mktSegmentDescendants.join(mktSegment,
                                                            selVal,Source.COMPARISON_RULE_DESCENDING,
                                                            false);
View Full Code Here
133
134
135
136
137
138
139
140
141
142
143
    Source prodHier = (Source) sources.get(1);
    StringSource calendarHier = (StringSource) sources.get(2);
    StringSource shipmentsHier = (StringSource) sources.get(3);
    Source chanHier = (Source) sources.get(4);
   
    Source custSel = shipmentsHier.selectValue(
                                       "SHIPMENTS_AW::SHIP_TO_AW::104");
    
    Source edge = prodHier.join(calendarHier).join(chanHier);
    
    Source edgeSel = edge.selectValues(dp.createListSource(
View Full Code Here
233
234
235
236
237
238
239
240
241
242
243
    MdmLevelHierarchy mdmTimeHier = (MdmLevelHierarchy)
                                     mdmTimeDim.getDefaultHierarchy();
    StringSource timeHier = (StringSource) mdmTimeHier.getSource();
   
    // Select one member of each dimension.   
    Source timeSel = timeHier.selectValue("CALENDAR_YEAR_AW::YEAR_AW::4");   
    Source prodSel = prodHier.selectValue("PRODUCT_PRIMARY_AW::FAMILY_AW::7");
   
    // Join the dimension selections to the measure and display the result.
    Source result = unitPrice.join(prodSel)
                             .join(timeSel);
View Full Code Here
62
63
64
65
66
67
68
69
70
71
72
    Source shipmentsParentAttr = mdmParentAttr.getSource();
    Source custValDescAttr = mdmCustValDescAttr.getSource();
   
    // Specify a parent value from the hierarchy.
    Source parentValue =
            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(),
View Full Code Here
250
251
252
253
254
255
256
257
258
259
260
      {
        MdmDimensionMemberInfo mdmDimMemInfo = (MdmDimensionMemberInfo)
                                                dimMemberInfosItr.next();
        MdmHierarchy mdmHier = mdmDimMemInfo.getHierarchy();
        StringSource hierSrc = (StringSource) mdmHier.getSource();
        Source memberSel = hierSrc.selectValue(mdmDimMemInfo.getUniqueValue());
       
        // Join the Source objects for the selected dimension members
        // to the measure.
        result = result.joinHidden(memberSel);
      }
View Full Code Here
149
150
151
152
153
154
155
156
157
158
159
      MdmAttribute mdmShortDescrAttr =
                          mdmPrimDim.getShortValueDescriptionAttribute();
      Source shortDescrAttr = mdmShortDescrAttr.getSource();
      MdmHierarchy mdmHier = mdmDimMemInfo.getHierarchy();
      StringSource hierSrc = (StringSource) mdmHier.getSource();
      Source memberSel = hierSrc.selectValue(mdmDimMemInfo.getUniqueValue());
      Source shortDescrForMember = shortDescrAttr.joinHidden(memberSel);
           
      // Prepare and commit the current transaction.
      try
      {
View Full Code Here
78
79
80
81
82
83
84
85
86
87
88
      // Reverse the ancestors relation to get the descendants relation.
      Source mktSegmentDescendants =
                mktSegment.join(mktSegmentAncestors, mktSegment.value());
     
      // Select an element of the hierarchy.
      Source selVal = mktSegment.selectValue(node);

      Source result = null;
      if(decendentsOnly){
        Source mktSegmentDescendantsOnly =
          mktSegmentDescendants.join(mktSegmentDescendants.getDataType().value(),
View Full Code Here
84
85
86
87
88
89
90
91
92
93
94
      for(int yeari=0;result!=null&&yeari<result.size();yeari++){
        LazyDynaBean yearbean = result.get(yeari);
        Object objectID = yearbean.get("id");
        if(objectID!=null){
          String id = objectID.toString();
            Source levelElement = timeHier.selectValue(id);
            Source levelElementChildren = timeHierChildren.join(timeHier, levelElement);
            Source levelElementChildrenWithShortDescr =
                                             prodShortLabel.join(levelElementChildren);
            queryCursor = getCursor(context,levelElementChildrenWithShortDescr);
            List<LazyDynaBean> quarterList = convertDimensionShortDescCursor2List(queryCursor);
View Full Code Here
96
97
98
99
100
101
102
103
104
105
106
          for(int quarteri=0;quarterList!=null&&quarteri<quarterList.size();quarteri++){
            LazyDynaBean quarterbean = quarterList.get(quarteri);
            objectID = quarterbean.get("id");
            if(objectID!=null){
              id = objectID.toString();
                  levelElement = timeHier.selectValue(id);
                  levelElementChildren = timeHierChildren.join(timeHier, levelElement);
                  levelElementChildrenWithShortDescr =
                                                   prodShortLabel.join(levelElementChildren);
                  queryCursor = getCursor(context,levelElementChildrenWithShortDescr);
                  List<LazyDynaBean> monthList = convertDimensionShortDescCursor2List(queryCursor);
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.