locked
Union Set of queries in Tabular 2012 RRS feed

  • General discussion

  • Hi ALL,

    I have a  view that
    has

    Create view  view_name
    as

    (

    Select    * from  fact_ table join dim1 on fact_ table.id = dim1.id
     inner join dim2 on dim2.2_id = fact_table.2_id

    )     

    And in tabular model I select these tables and join them in
    model instead of selecting the whole view. This approach we had to take because
    all the individual tables process perfectly with partitions. This was not
    possible with selecting the single view in the model. This method had
    processing issues even with partitions.

    Now for other requirements.

    Create view  view_name1
     as

    (

    Select    *  from  fact_ table join dim1 on fact_ table.id = dim1.id
     inner join dim2 on dim2.2_id = fact_table.2_id

    Union all

    Select    *  from  fact_ table join dim1 on fact_ table.id = dim1.id
     inner join dim2 on dim2.2_id = fact_table.2_id

    Union
    all

    …………………………………

    )

    How can this be achieved by individually selecting tables in
    the tabular model. I cannot try union two tables in tabular( Sugessted by Jason Thomas blog: union two tables using DAX) using DAX.As this itself has complex DAX code.My requiremnt is more complex thant his.. If I
    decide to make two views of the above union query and select them in the model
    individually. Still it is not acceptable as .As  both views take lot of time to process by any
    means

    Thursday, June 27, 2013 2:09 PM

All replies