To combine two dimensions, Firstname and Lastname, into a single dimension displaying as Lastname, Firstname in a live data model, you should create a calculated dimension in the data model. This calculated dimension will concatenate the two fields into one, according to the specified format. This approach allows for the creation of a new dimension that can be used across various reports and analyses within the model, maintaining the integrity of the original dimensions.

References:

• SAP Analytics Cloud Help Documentation: Creating Calculated Dimensions
• SAP Analytics Cloud User Guide: Data Modeling Best Practices

In SAP Analytics Cloud, data concatenation can be performed on Embedded datasets, Standalone datasets, and Imported data models. This process involves combining data from multiple sources or tables into a single dataset or model, providing a unified viewof the data. This is particularly useful for analyses that require a comprehensive dataset compiled from various data sources.

References:

• SAP Analytics Cloud Help Documentation: Working with Datasets
• SAP Analytics Cloud User Guide: Concatenating Data in Models and Datasets

To display differences between measures in a chart within SAP Analytics Cloud, you can use the Variance feature. Variance helps to highlight the differences or gaps between two data points or measures, making it easier to identify trends, outliers, or areas requiring attention in visual representations like charts.

References:

• SAP Analytics Cloud Help Documentation: Variance Analysis in Charts
• SAP Analytics Cloud User Guide: Displaying Measure Differences Using Variance