Package oracle.olapi.data.source

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

108
109
110
111
112
113
114
115
116
117
118
                for(int monthi=0;monthList!=null&&monthi<monthList.size();monthi++){
                  LazyDynaBean monthbean = monthList.get(monthi);
                  objectID = monthbean.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> dayList = convertDimensionShortDescCursor2List(queryCursor);
View Full Code Here
32
33
34
35
36
37
38
39
40
41
42
    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();
View Full Code Here
78
79
80
81
82
83
84
85
86
87
88
        getMdmPrimaryDimension("TIME_AW").getDefaultHierarchy().getSource();

    // Select single values for the hierarchies.
    Source prodSel = prodHier.selectValue("PRODUCT_PRIMARY_AW::ITEM_AW::15");
    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);
View Full Code Here
129
130
131
132
133
134
135
136
137
138
139
    // 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("MARKET_SEGMENT_AW::ACCOUNT_AW::23");

    // Select the descendants of the specified element.
    Source selValDescendants = mktSegmentDescendants.join(mktSegment,
                                                          selVal,
                                                          false);
View Full Code Here
173
174
175
176
177
178
179
180
181
182
183
    // 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("MARKET_SEGMENT_AW::ACCOUNT_AW::23");

    // Create a descendants relation that removes the input value.
    Source mktSegmentDescendantsOnly =
        mktSegmentDescendants.join(mktSegmentDescendants.getDataType().value(),
                                   mktSegment.value(),
View Full Code Here
234
235
236
237
238
239
240
241
242
243
244
    // 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);

View Full Code Here
334
335
336
337
338
339
340
341
342
343
344
                                           {"PRODUCT_PRIMARY_AW::ITEM_AW::13",
                                            "PRODUCT_PRIMARY_AW::ITEM_AW::14",
                                            "PRODUCT_PRIMARY_AW::ITEM_AW::15"});
   Source chanSel = chanHier.selectValue("CHANNEL_PRIMARY_AW::CHANNEL_AW::2");
   //Source timeSel = timeHier.selectValue("CALENDAR_YEAR_AW::YEAR_AW::3");
   Source timeSel = timeHier.selectValue("CALENDAR_YEAR_AW::MONTH_AW::59");
   Source custSel = custHier.selectValue("SHIPMENTS_AW::TOTAL_CUSTOMER_AW::1");

   Source measDim = dp.createListSource(new Source[] {unitPrice, units, sales});

   Source result = measDim.extract().join(measDim)
View Full Code Here
199
200
201
202
203
204
205
206
207
208
209
    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)
View Full Code Here
31
32
33
34
35
36
37
38
39
40
41
    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();
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.