Linked Model creates non-summable data

[Former Member]

Fellow users,

I have a Story in which I have my data displayed like this:

The dimension used is called "Prodh L1", the first measure is a standard measure from my live BW-connection and the 2nd and 3rd measures are calculated measures based on measures from BW. If I add a second dimension called "Prodh L4" the data is split in several underlying levels. Below is the example of the breakdown for the first dimension:

Now I have created a Excel-file in which I map every "Prodh L4" to a "Prod Segm 1". I created Linked Dimension, looking like this:

Both are matched on "ID". I add this Linked Dimension to my table as a Linked Model. I add the "Prod Segm 1" as a Dimension and my table changes to this:

The mapping has worked correctly and most of the table still looks the same. However: all the 'zero' values - which were presented as a "-" in the previous table - have now been replaced by a diagonal line in the cell, as if SAC says it can't calculate anything there. If I now remove the first two Dimensions and leave only my newly added Dimension "Prod Segm 1" - as this is my goal for this entier exercies - I get this:

Instead of getting the aggregated sums for all the underlying levels, it gives me all 'diagonal lines' (except for the "ACT Gross Sales" column, because this column contains no cells with a 'zero' value). I'm guessing this has something to do with SAC replacing the 'zero' on the underling levels with a 'diagonal line'. Why does SAC do this? Is there something I'm doing wrong or is what I'm trying to achieve impossible due to some reason I'm not aware of?

Any help is greatly appreciated!

[IngoH]

Hello Stefan,

the columns showing the measure in your scenario, are those just values from BW (actual measures in the BW Query) or are you calculating between the BW data and the XLS file ?

and most likely it is not related to the Null values.

Regards

Ingo Hilgefort, SAP

[Former Member]

Hello ingo.hilgefort,

thanks for your response. The columns with the measures are just values from BW. The only thing the XLS-file does is adding a Dimension.

You say it is most likely not related to the Null-values ; what exactly do you mean? I've tried Martijn's suggestion and if I 'remove' the Live BW Blending and use the Combine Data functionality, everything works as it should...

Kind regards,

Stefan van Diepen

[mfoeken · Accepted solution]

Hi Stefan,

Maybe you can extract the BW live data via SAC to Excel and create an import model via this way? If it works with an import model and the combine data feature you are pretty sure it's a live BW blending issue.

Kind regards,

Martijn van Foeken | Interdobs

[Former Member · Accepted solution]

Hello Martijn,

this is indeed the case. I've extracted the data through BW and saved it as a Excel-file. Created a Model based on this file and used the 'Combine Data' feature to add my custom Mapping. I created a Story afterwards and now the measures add-up nicely:

Test Model (non live connection with Combined Date feature):

Main Story (live-connection with data blending):

Thanks for your help in sorting this out, guess I'll have to find another way to work around the issue at hand.

Kind Regards,

Stefan