cancel
Showing results for 
Search instead for 
Did you mean: 

Dimensions and Measures separate entities to increase performance

former_member316819
Discoverer

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,

Suma

Accepted Solutions (0)

Answers (1)

Answers (1)

robin_williams
Explorer
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. https://blogs.sap.com/2018/03/29/working-with-sap-analytics-cloud-sac-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.