5 Replies Latest reply: Sep 20, 2013 1:31 PM by Christian Berg RSS

    Union queries using RPD

    AkanshAgarwal

      Hi,

       

      I have requirement in which I have table based on asset groups, i.e each group is having a separate table.

       

      Now my reports queries all the asset groups. How to design that in the RPD.

       

      * We cannot build union all reports.

       

      lets take an example

       

      Group A table

      Group key

      column1

      column2

       

      Group B table

      Group key

      column1

       

      Group C table

      Group key

      column2

       

      Here column1 and column2 are respective information but for different asset groups( thats y we have 3 tables)

       

      This tables are dimensions.

       

      Tried making the tables as LTS for a single logical table. But the query is built up for a single table which both the columns

       

      Thanks in advance

      Akansh Agarwal