4 Discovering the Available Metadata

Example 4-2 Getting the Root MdmSchema

MdmSchema rootSchema = mp.getRootSchema();

Example 4-3 Getting MdmDimension Objects

List dims = rootSchema.getDimensions();

Example 4-4 Getting Subschemas

List subSchemas = rootSchema.getSubSchemas();

Example 4-5 Getting the MdmMeasureDimension and Its Contents

MdmMeasureDimension mdmMeasureDim =
             (MdmMeasureDimension) rootSchema.getMeasureDimension();
List mdmMeasureDimMeasures = mdmMeasureDim.getMeasures();
Iterator mdmMeasureDimMeasuresItr = mdmMeasureDimMeasures.iterator();
MdmMeasure measure = null;
System.out.println("The measures in the MdmMeasureDimension are:");
while (mdmMeasureDimMeasuresItr.hasNext()) 
{
  measure = (MdmMeasure) mdmMeasureDimMeasuresItr.next();
  System.out.println("\t" + measure.getName());
}

Example 4-6 Getting the Dimensions of an MdmMeasure

List dimsOfUnits = mdmUnits.getDimensions();

The getMeasureInfo method, which is in the Example 4-9, shows one way to iterate through the MdmPrimaryDimension objects belonging to an MdmMeasure.

Example 4-7 Getting the MdmHierarchy Components of an MdmPrimaryDimenison

List mdmHiers = mdmPrimaryDim.getHierarchies();
Iterator mdmHiersItr = mdmHiers.iterator();
System.out.println("The MdmHierarchy components of " + mdmPrimaryDim.getName()
                   + " are:");
while (mdmHiersItr.hasNext()) 
{
  MdmHierarchy mdmHier = (MdmHierarchy) mdmHiersItr.next();
  System.out.println("\t" + mdmHier.getName());
} 

The getDimInfo method in Example 4-9 shows one way to get the following metadata objects for an MdmDimension.

Example 4-9 Discovering the OLAP Catalog Metadata

package globalExamples;

import oracle.express.olapi.data.full.ExpressDataProvider;
import oracle.olapi.metadata.mdm.*;
import oracle.olapi.data.source.Source;

import java.util.List;
import java.util.Iterator;

/**
 * Discovers the MDM metadata objects in the Global schema.
 * This file and the MyConnection10g.java file are available from the
 * Overview of the <I>Oracle OLAP Java API Reference</I>.
 */
public class SampleMetadataDiscoverer10g
{
/**
 * Constant to use to display less information about metadata objects.
 */
static final int TERSE = 0;
/**
 * Constant to use to display more information about metadata objects.
 */
static final int VERBOSE = 1;

private MdmSchema root = null;
private MdmPrimaryDimension mdmDim = null;

  public SampleMetadataDiscoverer10g()
  {
  }

  /**
   * Creates an object that makes a connection to an Oracle database
   * and gets MDM metadata objects.
   */
  public void run(String[] args) 
  {
    // Connect through JDBC to an instance of an Oracle database
    // and get a DataProvider.
    MyConnection10g myConn = new MyConnection10g();
    ExpressDataProvider dp = myConn.connectToDB(args, TERSE);

    // Get the default MdmMetadataProvider from the DataProvider.
    MdmMetadataProvider mp = null;
    try
    {
      mp = (MdmMetadataProvider) dp.getDefaultMetadataProvider();
    }
    catch (Exception e) 
    {
      System.out.println("Cannot create the MDM metadata provider."  + e);
    }

    // Get metadata information about the root MdmSchema and its subschemas.
    try
    {
      root = mp.getRootSchema();
      System.out.println("The root MdmSchema is " + root.getName() + ".\n");
      getSchemaInfo(root, VERBOSE);
    }
    catch (Exception e)
    {
      System.out.println("Encountered exception. " + e);
    }

    // Get the Source for the dimension that was saved in getDimInfo.
    System.out.println("\nMaking a Source object for dimension " +
                       mdmDim.getName() + ".");
    Source dimSource = mdmDim.getSource();
    System.out.println("Made the Source.");

    // Close the ExpressDataProvider and the connection.
    dp.close();
    System.out.println("\nClosed the DataProvider.");
    myConn.closeConnection();
    System.out.println("Closed the connection.");
  }

  /**
   * Gets information about an MdmSchema.
   */
  public void getSchemaInfo(MdmSchema schema, int outputStyle) 
  {
    if (schema == root) 
    {
      System.out.println("The MdmPrimaryDimension components of" +
                         "the root schema are:");
    }
    else 
    {
      System.out.println("   The MdmPrimaryDimension components of schema "
                        +  schema.getName() + " are:");
    }
    // Get the dimension information for the MdmSchema.
    MdmPrimaryDimension oneDim = null;
    int i = 1;
    try 
    {
      List dims = schema.getDimensions();
      Iterator dimIter = dims.iterator();
      // Save the first dimension to use later for getting its Source.
      mdmDim = (MdmPrimaryDimension) dims.get(0);
      // Iterate through the list of MdmPrimaryDimension objects and get
      // information about each one.
      while (dimIter.hasNext()) 
      {
        oneDim = (MdmPrimaryDimension) dimIter.next();
        getDimInfo(i, oneDim, outputStyle);
        i++;
      }
    }
    catch (Exception e)
    {
      System.out.println("   Encountered exception. " + e);
    }

    // If the MdmSchema is the root MdmSchema, get the
    // MdmMeasureDimension amd get its measures.
    MdmMeasure oneMeasure = null;
    MdmMeasureDimension mdmMeasureDim =
                         (MdmMeasureDimension) schema.getMeasureDimension();
    if (mdmMeasureDim != null) 
    {
      System.out.println("The measures of the MdmMeasureDimension are:");
      List mdmMeasures = mdmMeasureDim.getMeasures();
      Iterator mdmMeasuresIter = mdmMeasures.iterator();
      while (mdmMeasuresIter.hasNext()) 
      {
        oneMeasure = (MdmMeasure) mdmMeasuresIter.next();
        getMeasureInfo(oneMeasure, outputStyle);
        System.out.println(" ");
      }
    }

    // Get the measures from the MdmSchema.
    try 
    {
      List mdmMeasures = schema.getMeasures();
      if (mdmMeasures.size() > 0) 
      {
        Iterator mdmMeasuresIter = mdmMeasures.iterator();
         System.out.println("\n   The measures of schema " +
                            schema.getName() + " are:");
        while (mdmMeasuresIter.hasNext())
        {
          oneMeasure = (MdmMeasure) mdmMeasuresIter.next();
          getMeasureInfo(oneMeasure, outputStyle);
        }
      }
    }
    catch (Exception e) 
    {
        System.out.println("   Encountered exception. " + e);
    }

    // Get the subschema information for the MdmSchema.
    MdmSchema oneSchema = null;
    try 
    {
      List subSchemas = schema.getSubSchemas();
      Iterator subSchemaIter = subSchemas.iterator();
      while (subSchemaIter.hasNext()) 
      {
        oneSchema = (MdmSchema) subSchemaIter.next();
        // To get information on subschemas other than the Global
        // schema, GLOBAL_CAT, remove the if condition and call
        // the getSchemaInfo method.
        if (oneSchema.getName().equals("GLOBAL_CAT")) 
          getSchemaInfo(oneSchema, TERSE);
      }
    }
    catch (Exception e) 
    {
        System.out.println("   Encountered exception. " + e);
    }
  }

  /**
   * Gets information about an MdmMeasure.
   */
  public void getMeasureInfo(MdmMeasure measure, int outputStyle) 
  {
    System.out.println("   " + measure.getName());
    if (outputStyle == VERBOSE) 
    {
      // Get the dimensions of the MdmMeasure.
      try 
      {
        List mDims = measure.getDimensions();
        Iterator mDimIter = mDims.iterator();
        System.out.println("   Its dimensions are: ");
        while (mDimIter.hasNext())
        {
            System.out.println("   " + 
                        ((MdmDimension) mDimIter.next()).getName());
        }
      }
      catch (Exception e) 
      {
        System.out.println("   Encountered exception. " + e);
      }
    }
  }

  /**
   * Gets information about an MdmDimension.
   */
  public void getDimInfo(int count, 
                         MdmPrimaryDimension dim,
                         int outputStyle) 
  {
    if (outputStyle == TERSE)
      System.out.println("   " + dim.getName());

    else if (outputStyle == VERBOSE) 
    {
      System.out.println(count + ": MdmPrimaryDimension Name: " +
                         dim.getName());
      String description = dim.getDescription();
      if (description.length() > 0)
        System.out.println("   Description: " + dim.getDescription());
      // Determine the type of the MdmPrimaryDimension.
      try 
      {
        if (dim instanceof MdmStandardDimension)
        {
          System.out.println("   It is an MdmStandardDimension.");
        }
        else if (dim instanceof MdmTimeDimension)
        {
          System.out.println("   It is an an MdmTimeDimension.");
        }
        else if (dim instanceof MdmMeasureDimension)
        {
          System.out.println("   It is an MdmMeasureDimension.");
        }
      }
      catch (Exception e)
      {
        System.out.println("   Encountered exception. " + e);
      }

      // Get the attributes of the MdmPrimaryDimension
      System.out.println("   Its attributes are:");
      try 
      {
        List attributes = dim.getAttributes();
        Iterator attrIter = attributes.iterator();
        while (attrIter.hasNext())
        {
          System.out.println("   Attribute: " +
                            ((MdmAttribute) attrIter.next()).getName());
        }
      }
      catch (Exception e) 
      {
        System.out.println("   Encountered exception. " + e);
      }

      // Get the hierarchies of the MdmPrimaryDimension
      getHierInfo(dim);
      System.out.println(" ");
    }
  }

  /**
   * Gets the MdmHierarchy components of an MdmPrimaryDimension.
   */
  public void getHierInfo(MdmPrimaryDimension dim) 
  {
    List mdmHiers = dim.getHierarchies();
    Iterator mdmHiersItr = mdmHiers.iterator();
    MdmHierarchy mdmHier = null;
    MdmLevelHierarchy mdmLevelHier = null;
    boolean isLevelHierarchy = false;
    int i = 1;
    System.out.println("   The MdmHierarchy components of " +
                        dim.getName() + " are:");
    while (mdmHiersItr.hasNext()) 
    {
      mdmHier = (MdmHierarchy) mdmHiersItr.next();
      System.out.println("   "+ i + ": " + mdmHier.getName());
      if (mdmHier.isDefaultHierarchy()) 
      {
        System.out.println("   "+ i + ": " + mdmHier.getName());
           " is the default MdmHierarchy of " + dim.getName()  + ".");
      }
      if (mdmHier instanceof MdmLevelHierarchy)
      {
        mdmLevelHier = (MdmLevelHierarchy) mdmHier;
        System.out.println("      It is an MdmLevelHierarchy.");
        isLevelHierarchy = true;
      }
      else if (mdmHier instanceof MdmValueHierarchy)
      {
        System.out.println("      It is an MdmValueHierarchy");
      }
      System.out.println("      Its attributes are:");
      if (isLevelHierarchy)
      { 
        System.out.println("      Level attribute: "
                          + mdmLevelHier.getLevelAttribute().getName());
        System.out.println("      Level depth attribute: "
                           + mdmLevelHier.getLevelDepthAttribute().getName());
      }
      System.out.println("      Parent attribute: " +
                          mdmHier.getParentAttribute().getName());
      System.out.println("      Ancestors attribute: " +
                          mdmHier.getAncestorsAttribute().getName());
      if (isLevelHierarchy)
        getLevelInfo(mdmLevelHier);
     i++;
    }
  }

  /**
   * Gets the MdmLevel components of an MdmLevelHierarchy.
   */
  public void getLevelInfo(MdmLevelHierarchy mdmHier)
  {
    List mdmLevels = mdmHier.getLevels();
    Iterator mdmLevelsItr = mdmLevels.iterator();
    System.out.println("      Its levels are:");
    while (mdmLevelsItr.hasNext()) {
      MdmLevel mdmLevel = (MdmLevel) mdmLevelsItr.next();
      System.out.println("      " + mdmLevel.getName());
    }
  }

  /**
   * Creates a new SampleMetadataDiscoverer10g object and calls its
   * run method.
   */
  public static void main(String[] args) 
  {
    new SampleMetadataDiscoverer().run(args);
  }
}