We have a requirement to build a custom hierarchy based on the combination of two fields in the S/4HANA code block (Account + Custom Dimension) to be consumed for reporting by AO in an embedded consolidation BPC solution.
At the higher levels of the hierarchy it will represent the FSV but at the lower levels it will represent Account + Custom Dimension. How might this be achieved in the Real Time Consolidation Model? Is it better to configure this in S/4HANA using a custom CDS view or perhaps in BW as a custom characteristic, and what would be the benefits of either approach? Any insight would be much appreciated.