Hi Experts,
I guess everyone is familiar with aggregating datas. From source data, 10 records sharing the same dimensional keys, we can aggregate these records to 1 record, by selecting the desired aggregation rules (Max / Min / Sum .... )
Is there any way that we can "populate" , let's say 10 records from 1 record?
By using SQL, it can easily be defined by using an outer join. But is there a way that this can be done in SAP BI? The purpose of doing this, it provides a "complete" set of data with all combination of all keys so it can be used in YTD calculation.
Thank in advance.
Heng Meng