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 B table
Group C table
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