Skip to Content

Merging two crosstabs in Lumira 2.0 Designer

Hi Experts,

I have a requirement where I have to merge two tables into one.

Both the tables have same fields as you can see. Only difference is the filter.

Left table is showing data for the selected Period(Listbox) while the right table is displaying data for " less than or equal to" the selected Period.

The User wants to merge both datasets into one as shown in second image.

I did this by setting '0' column width to zero in Right Table.But this is not the right way as when I apply some of the global filters then number of records in both the table gets different and then this trick fails.

Is there any way to achieve this??

merge.png (68.7 kB)
merge2.png (79.7 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • May 04 at 12:55 PM

    This is what worked in Design Studio - see https://answers.sap.com/questions/73579/merging-2-queries-into-single-crosstab.html but I am not sure if it will work in Lumira Designer.

    Another idea is to blend back in Lumira Discovery and then bring it into Designer.

    What is your data source?

    Add comment
    10|10000 characters needed characters exceeded

    • Data Source/Data Flow is ----> Hana->Universe->Discovery->Designer

      The problem here is that both the tables has same Measures, and I have to apply different filter conditions on them.