namespace AnalyticsDAL.Query.Warehouse
{
    public static class WarehouseFactQB
    {
        // Index: PK_MWAREHOUSEFACT_FACTID
        public const string GET_FACT_BY_ID = @"
            SELECT  f.FACTID              AS FactId,
                    f.FACTCODE            AS FactCode,
                    f.FACTNAME            AS FactName,
                    f.FACTTABLENAME       AS FactTableName,
                    f.GRAINDESCRIPTION    AS GrainDescription,
                    f.DATEDIMCOLUMN       AS DateDimColumn,
                    f.OUDIMCOLUMN         AS OuDimColumn,
                    f.BUSINESSDESCRIPTION AS BusinessDescription,
                    f.SYNONYMS            AS Synonyms,
                    f.TENANTID            AS TenantId
            FROM    MWAREHOUSEFACT f
            WHERE   f.FACTID = @FactId
            AND     f.STATUS <> 2";

        // Index: IX_MWAREHOUSEMEASURE_FACTID
        public const string GET_MEASURES_BY_FACT_ID = @"
            SELECT  m.MEASUREID              AS MeasureId,
                    m.FACTID                  AS FactId,
                    m.MEASURECODE             AS MeasureCode,
                    m.MEASURENAME             AS MeasureName,
                    m.COLUMNNAME              AS ColumnName,
                    m.DATATYPE                AS DataType,
                    m.ADDITIVITYTYPE          AS AdditivityType,
                    m.SEMIADDITIVEDIMENSION   AS SemiAdditiveDimension,
                    m.DEFAULTAGGREGATION      AS DefaultAggregation,
                    m.FORMATSTRING            AS FormatString,
                    m.BUSINESSDESCRIPTION     AS BusinessDescription,
                    m.SYNONYMS                AS Synonyms,
                    m.ISVISIBLE               AS IsVisible
            FROM    MWAREHOUSEMEASURE m
            WHERE   m.FACTID    = @FactId
            AND     m.STATUS   <> 2
            AND     m.ISVISIBLE = 1
            ORDER BY m.SORTORDER, m.MEASURENAME";
    }
}