Infocube Creation Step 3 using SAP BI 7.0

In this section, we will see how to create transformation.20) Replicate the data source, select the source system, right click and select 'Replicate DataSources'

21) Select the data source as RSDS DataSource

22) Select the InfoCube and right click to 'Create Transformation'

23) Select Source and Target for Transformation

24) System will propose the mapping, incase system does not propose, select the InfoObject and drop for mapping

25) For 0CALMONTH, a constant will be used in this case, define the constant

26) After defining, press 'Transfer Values'

27) Check and activate the transformation

In the next section, we will see how to create Data Transfer Process and load data in InfoCube