Class AggGen


  • public class AggGen
    extends java.lang.Object
    This class is used to create "lost" and "collapsed" aggregate table creation sql (creates the rdbms table and inserts into it from the base fact table).
    Author:
    Richard M. Emberson
    • Method Detail

      • isReady

        public boolean isReady()
        Return true if this instance is ready to generate the sql. If false, then something went wrong as it was trying to understand the columns.
      • getFactTableName

        protected java.lang.String getFactTableName()
      • getSqlQuery

        protected SqlQuery getSqlQuery()
      • getFactCount

        protected java.lang.String getFactCount()
      • getRolapStarColumnName

        protected java.lang.String getRolapStarColumnName​(RolapStar.Column rColumn)
      • addForeignKeyToNotLostColumnUsages

        protected void addForeignKeyToNotLostColumnUsages​(JdbcSchema.Table.Column column)
      • makeLostAggregateTableName

        java.lang.String makeLostAggregateTableName​(java.lang.String factTableName)
      • makeCollapsedAggregateTableName

        java.lang.String makeCollapsedAggregateTableName​(java.lang.String factTableName)
      • createLost

        public java.lang.String createLost()
        Return a String containing the sql code to create a lost dimension table.
        Returns:
        lost dimension sql code
      • insertIntoLost

        public java.lang.String insertIntoLost()
        Return the sql code to populate a lost dimension table from the fact table.
      • createCollapsed

        public java.lang.String createCollapsed()
        Return a String containing the sql code to create a collapsed dimension table.
        Returns:
        collapsed dimension sql code
      • insertIntoCollapsed

        public java.lang.String insertIntoCollapsed()
        Return the sql code to populate a collapsed dimension table from the fact table.