How can I calculate Cost estimate to its base level to populate over SAC using CDS view?

I need to calculate material cost planning for which require material cost estimate to its base level of raw material by splitting it is semi finished material or finished material to accumulated raw from its BOM. This would be populate at SAP analytics cloud through CDS view. Please guide what should I look for?