Examples of MdmLevelHierarchy


Examples of oracle.olapi.metadata.mdm.MdmLevelHierarchy

    println("Drilling in a Hierarchy");
       
    MdmPrimaryDimension mdmTimeDim = getMdmPrimaryDimension("MYTIME");
       
//    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();
       
    // Get the parent relation from the hierarchy.
    MdmAttribute mdmTimeHierParentAttr = mdmTimeHier.getParentAttribute();
   
    Source prodHierParentAttr = mdmTimeHierParentAttr.getSource();
       
    // Reverse the parent relation to get a children relation.
    Source timeHierChildren = timeHier.join(prodHierParentAttr,
View Full Code Here

Examples of oracle.olapi.metadata.mdm.MdmLevelHierarchy

    MdmPrimaryDimension mdmTimeDim = getMdmPrimaryDimension("MYTIME");
    MdmPrimaryDimension mdmMediaDim = getMdmPrimaryDimension("MEDIA");
   
    MdmValueHierarchy mdmDepartmentRollup = (MdmValueHierarchy)
                                       mdmDepartmentDim.getDefaultHierarchy();
    MdmLevelHierarchy mdmCalendar = (MdmLevelHierarchy)
                                      mdmTimeDim.getDefaultHierarchy();
    MdmLevelHierarchy mdmMedia = (MdmLevelHierarchy)mdmMediaDim.getDefaultHierarchy();
   
    System.out.println(mdmAmount.getID()+":"+mdmAmount.getName());
    System.out.println(mdmCOAL_EQUIVALENT.getID()+":"+mdmCOAL_EQUIVALENT.getName());
   
    System.out.println(mdmDepartmentRollup.getID()+":"+mdmDepartmentRollup.getName());
    System.out.println(mdmCalendar.getID()+":"+mdmCalendar.getName());
    System.out.println(mdmMedia.getID()+":"+mdmMedia.getName());
   
    /**
     * 选择维度这儿是正确的
     */
   
View Full Code Here

Examples of oracle.olapi.metadata.mdm.MdmLevelHierarchy

    println("Drilling in a Hierarchy");
       
    MdmPrimaryDimension mdmProdDim = getMdmPrimaryDimension("MEDIA");
       
//    MdmPrimaryDimension mdmProdDim = getMdmPrimaryDimension("MEDIA");
    MdmLevelHierarchy mdmProdHier = (MdmLevelHierarchy)
                                     mdmProdDim.getDefaultHierarchy();
    StringSource prodHier =  (StringSource) mdmProdHier.getSource();
       
    // Get one of the levels of the hierachy.
    MdmLevel mdmLevel = getContext().getLevelByName(mdmProdHier, "MEDIA");
       
    Source levelSrc = mdmLevel.getSource();
       
    int pos = 1;
    Source levelElement = levelSrc.at(pos);
       
    // Use levelElement as the comparison to select a level value.
    Source levelSel = prodHier.join(prodHier.value(), levelElement);
       
       
    // Get the Source for the short label attribute of the dimension.
    Source prodShortLabel = mdmProdDim.getShortValueDescriptionAttribute()
                                      .getSource();
       
    // Get the parent relation from the hierarchy.
    MdmAttribute mdmProdHierParentAttr = mdmProdHier.getParentAttribute();
   
    MdmAttribute mdmProdHierAncestAttr = mdmProdHier.getAncestorsAttribute();
   
   
    Source prodHierParentAttr = mdmProdHierParentAttr.getSource();
       
    // Get the ancestor relation from the hierarchy.
    MdmAttribute mdmProdHierAncsAttr = mdmProdHier.getAncestorsAttribute();
    Source prodHierAncsAttr = mdmProdHierAncsAttr.getSource();
       
    // Get ancestors of the level element.
    Source levelElementAncs = prodHierAncsAttr.join(prodHier, levelElement);
       
View Full Code Here

Examples of oracle.olapi.metadata.mdm.MdmLevelHierarchy

   
   
    System.out.println("Media:");
    MdmPrimaryDimension mdmMediaDim = getMdmPrimaryDimension("MEDIA");
   
    MdmLevelHierarchy mdmMediaHier = (MdmLevelHierarchy)
                                     mdmMediaDim.getDefaultHierarchy();
   
    Source levelSource = mdmMediaHier.getSource();
   
    depShortLabel = mdmMediaDim.getShortValueDescriptionAttribute().getSource();
   
    Source mediaShortLabel = depShortLabel.join(levelSource);
   
    prepareAndCommit();
 
    // Create Cursor objects and display their values.
   
    getContext().displayResult(mediaShortLabel);
   
   
   
    System.out.println("Time:");   
    MdmPrimaryDimension mdmTimeDim = getMdmPrimaryDimension("MYTIME");
   
    MdmLevelHierarchy mdmTimeHier = (MdmLevelHierarchy)
                                     mdmTimeDim.getDefaultHierarchy();
   
    levelSource = mdmTimeHier.getSource();
   
//    depShortLabel = mdmTimeDim.getShortValueDescriptionAttribute().getSource();
//   
//    Source timeShortLabel = depShortLabel.join(levelSource);
   
View Full Code Here

Examples of oracle.olapi.metadata.mdm.MdmLevelHierarchy

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

    MdmPrimaryDimension mdmProdDim = getMdmPrimaryDimension("PRODUCT_AW");
    MdmPrimaryDimension mdmTimeDim = getMdmPrimaryDimension("TIME_AW");
    MdmLevelHierarchy mdmProdHier = (MdmLevelHierarchy)
                                     mdmProdDim.getDefaultHierarchy();
    MdmLevelHierarchy mdmTimeHier = (MdmLevelHierarchy)
                                     mdmTimeDim.getDefaultHierarchy();

    // Get the Source for the hierarchy.
    StringSource prodHier = (StringSource) mdmProdHier.getSource();
    StringSource timeHier = (StringSource) mdmTimeHier.getSource();

    Source prodSel = prodHier.selectValues(new String[] {
                                           "PRODUCT_PRIMARY_AW::ITEM_AW::13",
                                           "PRODUCT_PRIMARY_AW::ITEM_AW::14",
                                           "PRODUCT_PRIMARY_AW::ITEM_AW::15"});
View Full Code Here

Examples of oracle.olapi.metadata.mdm.MdmLevelHierarchy

    MdmMeasure mdmUnits = getMdmMeasure("UNITS_AW");
    NumberSource units = (NumberSource) mdmUnits.getSource();

    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.selectValues(new String[] {
                                            "SHIPMENTS_AW::SHIP_TO_AW::58",
View Full Code Here

Examples of oracle.olapi.metadata.mdm.MdmLevelHierarchy

    MdmPrimaryDimension mdmTimeDim = getMdmPrimaryDimension("TIME_AW");
    MdmPrimaryDimension mdmCustDim = getMdmPrimaryDimension("CUSTOMER_AW");
    MdmPrimaryDimension mdmChanDim = getMdmPrimaryDimension("CHANNEL_AW");
   
    // Get the default MdmLevelHierarchy for each dimension.
    MdmLevelHierarchy mdmProdHier = (MdmLevelHierarchy)
                                     mdmProdDim.getDefaultHierarchy();
    MdmLevelHierarchy mdmTimeHier = (MdmLevelHierarchy)
                                     mdmTimeDim.getDefaultHierarchy();
    MdmLevelHierarchy mdmCustHier = (MdmLevelHierarchy)
                                     mdmCustDim.getDefaultHierarchy();
    MdmLevelHierarchy mdmChanHier = (MdmLevelHierarchy)
                                     mdmChanDim.getDefaultHierarchy();
   
    // Get the Source objects for the hierarhies.
    StringSource prodHier = (StringSource) mdmProdDim.getSource();
    StringSource timeHier = (StringSource) mdmTimeHier.getSource();
    StringSource custHier = (StringSource) mdmCustDim.getSource();
    StringSource chanHier = (StringSource) mdmChanHier.getSource();
   
    // Get the MdmAttribute for the short description attribute of the
    // Product dimension, and get the Source for the attribute.
    MdmAttribute mdmProdShortDescr =
                         mdmProdDim.getShortValueDescriptionAttribute();
View Full Code Here

Examples of oracle.olapi.metadata.mdm.MdmLevelHierarchy

    Source unitPrice = mdmUnitPrice.getSource();
 
    MdmPrimaryDimension mdmProdDim = getMdmPrimaryDimension("PRODUCT_AW");
    Source productDim = mdmProdDim.getSource();
   
    MdmLevelHierarchy mdmProdHier = (MdmLevelHierarchy)
                                     mdmProdDim.getDefaultHierarchy();
    StringSource prodHier = (StringSource) mdmProdDim.getSource();
   
    MdmPrimaryDimension mdmTimeDim = getMdmPrimaryDimension("TIME_AW");
    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");
   
View Full Code Here

Examples of oracle.olapi.metadata.mdm.MdmLevelHierarchy

    MdmPrimaryDimension mdmTimeDim = getMdmPrimaryDimension("MYTIME");
    MdmPrimaryDimension mdmMediaDim = getMdmPrimaryDimension("MEDIA");
   
    MdmValueHierarchy mdmDeptHier = (MdmValueHierarchy)
                                     mdmDeptDim.getDefaultHierarchy();
    MdmLevelHierarchy mdmTimeHier = (MdmLevelHierarchy)
                                     mdmTimeDim.getDefaultHierarchy();
   
    MdmLevelHierarchy mdmMediaHier = (MdmLevelHierarchy)mdmMediaDim.getDefaultHierarchy();

    // Get the Source for the hierarchy.

//    Source valueSource = mdmDeptHier.getSource();
   
   
    StringSource prodHier = (StringSource) mdmDeptHier.getSource();
    StringSource timeHier = (StringSource) mdmTimeHier.getSource();
    StringSource mediaHier = (StringSource) mdmMediaHier.getSource();
   
   
//    MdmAttribute mdmDeptAttr = getContext().getAttributeByName(mdmDeptDim,"SHORT_DESCRIPTION");
//    Source mktMngrAttr = mdmDeptAttr.getSource();
//    MdmLevel mdmItemLevel = getContext().getLevelByName(mdmDeptHier, "ITEM_AW");
View Full Code Here

Examples of oracle.olapi.metadata.mdm.MdmLevelHierarchy

    MdmPrimaryDimension mdmChanDim = getMdmPrimaryDimension("MEDIA");
       
    MdmValueHierarchy mdmProdDefLvlHier = (MdmValueHierarchy)
                                           mdmProdDim.getDefaultHierarchy();
       
    MdmLevelHierarchy mdmTimeDefLvlHier = (MdmLevelHierarchy)
                                           mdmTimeDim.getDefaultHierarchy();
       
    MdmLevelHierarchy mdmChanDefLvlHier = (MdmLevelHierarchy)
                                            mdmChanDim.getDefaultHierarchy();
       
    // Get the Source objects for the hierarchies.
    StringSource prodHier = (StringSource) mdmProdDefLvlHier.getSource();
    StringSource timeHier = (StringSource) mdmTimeDefLvlHier.getSource();
    StringSource chanHier = (StringSource) mdmChanDefLvlHier.getSource();
       
    // Get the DataProvider.
    ExpressDataProvider dp = getExpressDataProvider();
       
    // Get the short description attribute for the dimensions and the
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.