Hi,
Products on an SKU level should typically be loaded to stage / custom table / BI Blend and be reported from there. The reporting requirements are the main driver for such a decision. Mostly, Product Groups are held in a UD where the (aggregated) SKU level data is loaded to (and can be drilled back to from).
Such a decision should be discussed with sufficient time with your implementation partner as many factors play a role here.
If the mentioned reporting capabilities outside of the cube are unclear, you might also ask for a demo so that this becomes more clear.
I agree with Henning & JackLacava . Its important on requirements like a product dimension at the SKU level to ask Why. Most FP&A groups don't plan, budget, nor forecast at the SKU level, and most Accounting groups don't run consolidations from the SKU level, To me this suggests a BI requirement. For which the given suggestions will work.
