How to compare data between two models in SAP Analytics Cloud

[Ajit_K_Panda]

Hi Experts,

We have 2 models. One is live and another one is from excel upload. One of our requirement is to compare data between two models and check for errors.

For example:

Model 1 (Live Data):
IdField M1FieldValue
ID0001 900020
ID0002 904591

Model2 (Excel Upload)
IdField M2FieldValue
ID0001 900020
ID0002 904400
ID0003 234567

Output Required
IdField ErrorType
ID0001 NoError
ID0002 Value Mismatch
ID0003 ID Doesnot Exist.

Is it possible in SAC?
Note: Combining Data not possible as one is live model and another one is Excel Upload Model.

Thanks in advance.

Regards, Ajit

[former_member95956]

Dear Ajit,

First, combining data is possible as we will say to build blending data. Based on source of Live data, you could refer to KBA 2762642.

Second, you could use the Variance to compare measure with another measure, only show difference as numbers instead of custom texts. Of course there are limitations of real-time source, for example: if live connect SAP BW, suggest to BW 7.5 SP16 or higher.

If you could provide the information of Live data source, we could give more information. Thanks.

Best Regards,

Stephen

[former_member650982]

But when blanding you do not have the possibly to:

Sort

Totals

Agg calculations

And much more

The blending is really poor and should not be used for data analysis

Only present small tables and where data match or else do the calculator. Somewhere else as SAC provides no help