Merge/Concatenate rows in SAC

[diegoviquez1293]

Hi SAC Experts !!

I'm trying to figure out a way to merge or groups columns.

Currently I'm creating a story for insp lots, however I'm having a issue with the lot status because the data set contains a row for each insp lot status.

I'm trying to merge or concatenate the different status in one single row, instead of repeating the row per status

Is there a way to achieve this?

Thanks in advance.

[William_Yu]

I don't see a way to achieve this dynamically in SAC table. The only option is to remove 'Status' from row axis, but you will lose the insight on detail status in this table.

But I guess your desired layout will only work if there is only few status per Insp Lot, concantenated display won't like nice if you have more status.

[DebjitSingha]

Hello diegoviquez1293,

Transformation functionalities in SAC are limited compared to any DW solutions (like eHANA or BW or DWC or non SAP DW). The grouping functionality available in SAC works based on measures.

These kind of transformation are better suited at source (say in BW transformation or eHANA SQL procedures etc.)

Workaround would be to setup "level based hierarchy" between Insp Lot and Status dim. While display in stories uncheck "Unbooked" values. You may need to consider all possible status in each node. This is not going to be an elegant setup in-terms of development or support though.

Viewers/ readers - If you find above information helpful, feel free to up-vote (arrows on left side).

-Debjit