SQL Server 2008 Analysis Services(OLAP) - jpivot fetch hierarchy/level/members

来源：互联网发布：excel数组求和编辑：程序博客网时间：2024/05/01 23:27

Dimension[] dims = model.getDimensions();

            {
                XMLA_Dimension dim = (XMLA_Dimension)dims[18];
                System.out.println("/nDimension: "+dim.getUniqueName() + "   " + dim.getCaption() +" isMeasure="+dim.isMeasure());

                Hierarchy[] hierObjs = dim.getHierarchies();
                for(Hierarchy hierObj : hierObjs){
                    XMLA_Hierarchy hier = (XMLA_Hierarchy)hierObj;
                    //hier.hasAll();
                    System.out.println("    Hierarchy: "+hier.getUniqueName() + "   " + hier.getCaption()+" hasAll="+hier.hasAll());

                    Level[] levels = hier.getLevels(); // (XMLA_Level)
                    for(Level levelObj : levels){
                        XMLA_Level level = (XMLA_Level)levelObj;
                        //level.isAll();
                        System.out.println("        Level: "+level.getUniqueName() + "   " + level.getCaption()+" isAll="+level.isAll());

                        Member[] memObjs = level.getMembers();
                        for(Member m : memObjs){
                            XMLA_Member m_ = (XMLA_Member)m;
                            //m_.isAll();
                            System.out.println("            Member: "+m_.getUniqueName() + "   " + m_.getCaption()+" isAll="+m_.isAll());
                        }

                    }
                }
            }

结果=========================>>>

Dimension: [Dim Xb]   性别维度 isMeasure=false
    Hierarchy: [Dim Xb].[Xb]   性别 hasAll=true
        Level: [Dim Xb].[Xb].[(All)]   (All) isAll=true
            Member: [Dim Xb].[Xb].[All]   合计 isAll=true
        Level: [Dim Xb].[Xb].[Xb]   性别 isAll=false
            Member: [Dim Xb].[Xb].&[1]   男 isAll=false
            Member: [Dim Xb].[Xb].&[2]   女 isAll=false
            Member: [Dim Xb].[Xb].&[9]   未填写 isAll=false

Dimension: [Measures]   Measures isMeasure=true
    Hierarchy: [Measures]   Measures hasAll=false
        Level: [Measures].[MeasuresLevel]   MeasuresLevel isAll=false
            Member: [Measures].[Num]   登记数(重复) isAll=false
            Member: [Measures].[Sfzh Distinct Count]   登记数(不重复) isAll=false
            Member: [Measures].[tongbi_djrq]   登记日期同比(不重复) isAll=false
            Member: [Measures].[huanbi_djrq]   登记日期环比(不重复) isAll=false