Difference between revisions of "Datamart DSL"

datamart <datamart name> [described by <discription>] 
    from <schema name> persistenceUnit <persistence unit name> 
    using entity/cube/task <entity/cube/task name> [<task mode> <mode name> for task] [nonempty values for cube] {
...
}

datamart EmployeeSalary 
    from CCNGDEFAULT persistenceUnit "foodmart" 
    using entity Memployee {. . .}

datamart SalesByState described by "cube based profit review" 
    from CCNGDEFAULT persistenceUnit "foodmart" 
    using cube Sales nonempty values {. . .}

datamart TaskDetails described by "Task details" 
    from BPM persistenceUnit "drools" 
    using task BusinessAdministrator locale "de-DE" {. . .}

datamart <datamart name> . . . using entity <entity A name> (tracking){
		[navigation {. . .}]
		[properties {. . .}] 
		[conditions {. . .}] 
		[filler rows <INTminRow> to <INTmaxRow>{. . .}] 
	}

entity <entity A name> {
    navigation {
        many to one <entity A name>.<entity B reference in entity A> to entity <entity B name> { 
            [navigation {. . . }] 
            [properties {. . . }] 
            [conditions {. . . }] 
        }
    }
    . . .
}

datamart EmployeeSalary from CCNGDEFAULT persistenceUnit "foodmart" using entity Memployee {
    navigation { 
        many to one Memployee.position to entity Mposition {
            properties {
                property position_title on axis rows
                property max_scale on axis columns
                property min_scale on axis columns
            }
            conditions {
                condition property pay_type = filtered
            }
        }
    }
    . . .
}

private String statement = 
    "select Mposition.MAX_SCALE as \"max_scale\",
            Mposition.MIN_SCALE as \"min_scale\", 
            Mposition.POSITION_TITLE as \"position_title\"
            . . .  
    from CCNG.MEMPLOYEE Memployee 
    left join CCNG.MPOSITION Mposition on(Mposition.id=Memployee.position_id) 
    where (Mposition.pay_type = $Mposition.pay_type$) 
    . . .";

private HashMap<Integer, ArrayList<String>> axisMap = new HashMap<Integer,ArrayList<String>>() {{
    put(0,new ArrayList<String>() {{
        . . .
        add("max_scale");
        add("min_scale");
    }});
    put(1,new ArrayList<String>() {{
        . . .
        add("position_title");
    }});
}};

entity <entity A name> {
    navigation {
        one to many <entity A name>.<entity B reference in entity A> to entity <entity B name> { 
            [navigation {. . . }] 
            [properties {. . . }] 
            [conditions {. . . }] 
        }
    }
    . . .
}

datamart SalesByDistrict described by "entity based aggregation of store sales and store cost" 
    from CCNGDEFAULT persistenceUnit "foodmart" 
    using entity Mregion 
{
    navigation {
        one to many Mstore.region to entity Mstore {
            navigation {
                one to many Msales_fact_1998.store to entity Msales_fact_1998 {
                    properties {
                        property store_sales aggregate summation on axis columns
                        property store_cost aggregate summation on axis columns
                    }
                }
            }
        }
    }
    . . .
}

private String statement = 
    "select SUM(Msales_fact_1998.STORE_SALES) as \"store_sales\",
            SUM(Msales_fact_1998.STORE_COST) as \"store_cost\" 
            . . .
    from CCNG.MREGION Mregion 
    left join CCNG.MSTORE Mstore on(Mstore.region_id=Mregion.id) 
    left join CCNG.MSALES_FACT_1998 Msales_fact_1998 on(Msales_fact_1998.store_id=Mstore.id) 
    where . . . group by . . .";
  
private final HashMap<String, String> filterMap = new HashMap<String,String>() 
{{
    put("$Mregion.id$","&");
    put("$Mstore.id$","&");
    put("$Msales_fact_1998.id$","&");
    . . .
    }};

properties {
property <entity A property> [aggregate <sql aggregation>] 
[on axis <axis name>] [scale <scale group number>]
. . .
}

property sales_region on axis rows
property store_sales _nm on axis columns

private HashMap<Integer, ArrayList<String>> axisMap = new HashMap<Integer,ArrayList<String>>() {{
            put(0,new ArrayList<String>() {{
                add("store_sales");
                . . .
            }});
            put(1,new ArrayList<String>() {{
                add("sales_region");
                . . .
            }});
    }};

property store_sales aggregate summation

private String statement = 
    "select SUM(Msales_fact_1998.STORE_SALES) as \"store_sales\", . . . 
     from . . . left join . . . on(. . .) group by . . . ";

property store_sales scale group1

conditions {
     condition 
     [<operator>]
           Number
           /STRING
           /(filtered [optional])|selected
           /property <entity A property> [aggregate <sql aggregation>]
           /entitycolumn <entity C>.<entity C Property>
           /column <task column>
     [<operator>
           Number
           /STRING
           /(filtered [optional])|selected
           /property <entity A property> [aggregate <sql aggregation>]
           /entitycolumn <entity D>.<entity D Property>
           /column <task column>
     ]
}

condition property gtin_cd = selected

private String statement = 
    ". . .
    where (gtin.gtin_cd in (§gtin.gtin_cd§))
    . . .";
private final HashMap<String, String> filterMap = new HashMap<String,String>() 
{{
    . . . 
    put("§gtin.gtin_cd§","select distinct GTIN_CD as \"gtin_cd\" from pod.GTIN");
    }};

condition property pay_type = filtered

private String statement = 
". . .
where (Mposition.pay_type = $Mposition.pay_type$)
. . .";
private final HashMap<String, String> filterMap = new HashMap<String,String>()
{{
    . . .
    put("$Mposition.pay_type$","select distinct PAY_TYPE as \"pay_type\" from CCNG.MPOSITION");
    }};

condition property education_level = filtered optional

private String statement = 
    ". . .
    where (($Memployee.education_level$='*' or Memployee.education_level = $Memployee.education_level$))
    . . .";
private final HashMap<String, String> filterMap = new HashMap<String,String>() {{
	. . . 
      put("$Memployee.education_level$","select '*' from dual union select distinct EDUCATION_LEVEL as \"education_level\" from CCNG.MEMPLOYEE");
    }};

filler rows <INTminRow> to <INTmaxRow>{
      [fill <entity property> with 
            filler-address city
            | filler-address postalcode
            | filler-date future <INT> years
            | filler-date past <INT> years
            | filler-date range <+-INTby> up to and including <+-INTey> years
            | filler-person full name
            | filler-person first name
            | filler-person last name
            | filler-person email
            | filler-person phone
            | filler-person gender male as <STRINGmt> female as <STRINGft>
            | filler-signed-double range 
              [ <+- Double> | <entity property>] 
              up to and including
              [ <+- Double > | <entity property>]
              with <INT> decimals
              round to < Double >
            | filler-signed-double random (<+-Double >)
            | filler-signed-integer range 
              [ <+-INT> | <entity property>] 
              up to and including
              [ <+-INT> | <entity property>]
              round to <INT>
            | filler-signed-integer random ( <+-INT> )
            | filler-text random ( <STRING> )
            | filler-text paragraps [<INT>]
            | filler-text sentences [<INT>]
            | filler-text words [<INT>]
            | filler-unsigned-double range 
              [ < Double > | <entity property>]
              up to and including
              [ < Double > | <entity property>]
              with <INT> decimals
              round to < Double >
            | filler-unsigned-double random ( < Double > )
            | filler-unsigned-integer range 
              [ <INT> | <entity property>]
              up to and including
              [ <INT> | <entity property>]
              round to <INT>
            | filler-unsigned-integer random ( <INT> )
      ]
}