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

When the SAP Analytics Cloud (SAC) modeler removes the first three characters from a public dimension imported from a source system, this change impacts Stories that use this dimension. Specifically, any visualizations, calculations, or filters within those stories that rely on the original dimension values may need to be adjusted to account for the change. This modification does not affect the source system or public datasets directly, but it can impact how the data appears and behaves in stories that use the modified dimension.

References:

• SAP Analytics Cloud Help Documentation: Modifying Dimensions
• SAP Analytics Cloud User Guide: Impact of Dimension Changes on Stories

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