Skip to Content
0
Former Member
Jan 06, 2008 at 08:12 AM

Adding records during trasnformation

20 Views

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