Showing results for 
Search instead for 
Did you mean: 

Dimensions and Measures separate entities to increase performance


Hello Experts,

I wanted to check if SAC allows Measures and Dimensions as separate data sources to be uploaded and then we create model by joining them to get analytics.

Example : (S/4HANA : Cradle to Gate) If I need to check Product Footprints based on Supplier inputs for a purchased product, can I have one entity which includes product, plant and supplier dimensions and another entity with their corresponding measures?

Thanks & Regards,


Accepted Solutions (0)

Answers (1)

Answers (1)

0 Kudos

Yes. The use case you've described is the purpose of the public dimensions. The following blog has information how to design a model that utilizes the public dimensions.

In your scenario, you would have 3 public dimensions (Supplier, Product, Plant). Your model would include the measures (and the keys for your dimensions) the reference to the 3 public dimensions.