SAP Analytics Cloud - Loading Data with different structure within the SAC Models

[guenay]

Hi friends,

I need to load data from different Sources/Models and want a specific outcome.

Let me explain step by step:

FIrst of all I want to share this image where i tried to visualize my issue:

As you can see I have two sources:

1. A Model within the SAC where I can load Sales Quantity per Customer and Material. So the first Data inside my COGS-Model will be Sales Quantity but without the production plant, it remains #.

2. Now I use the BW to load further Data into my COGS Model. I want to load my Cost Rates. With "Production Plant" I do have further information.

Goal: I now want to add the BW data to the already existing data.

For example: Every Material has the same Cost Rate independant from the Customer. So that means the Cost Rate should only be mapped by Material. And every Material also has one specific Production Plant.

How would you solve this issue without creating data set holding # for some Dimensions. Iam concerned that overwriting data sets isn't possible for Dimension elements...

Any way, what Ideas do you have?

Looking forward hearing from you.

Kind regards,

Ismail

[N1kh1l]

Ismail,

From BW, Every Material has only 1 plant associated with it ? Is it possible that the same material comes from other plant also like

Cost 10431 34 0,91

Nikhil

[guenay]

Hi Nikhil,

it is also possible that one material comes from 2 different plants! If so they also have different Cost Rates.

Kind regards,

Ismail

[N1kh1l]

In that case how do you know what plant and cost to use with the customer. In your Desired outcome how do you know its like below

and not

As material 10431 can be from two plants with different rate and there is no link of this with customer.

Regards

Nikhil

[guenay]

We do get further information like the distribution per plant and the also the cost rate per plant.

that means from the dairy data which is stored in the BW, I get a data record with Material, Plant, Distribution rate per plant, Cost Rate per plant.

Kind regards,

Ismail

[N1kh1l]

Hello Ismail,

You have to load both data sources into your model and then use Advance formula Data action to bind those two records together with material being the common link.

Regards

Nikhil

[guenay]

Thanks for the quick response. I will try it out!