I want to create and fill an info cube through two characteristics infoprovider.
The first Master data characteristic has the data key_id_1, attribut1, attribut2;
The second master data characteristic has the data key_id_2, key_id_1 (foreign key), attribut3, attribut4
I want to fill the infocube with the data key_id_2, key_id_1 (foreign key), attribut1, attribut2, attribut3, attribut4
One key figure will be fill with a constant value (for example 1)
How can i proceed: Through transformation oder infosource oder how do i have to do it.
Thank for helping