Measure expression to get data calculated at different grain

presently in cube grain set on order id.

however , there multiple order line items under main order id. presently due grain of fact table amount each line item showing total amount related order amount . , looking solution @ cube level can amount split each order line item based on percentage allocation . last 2 columns show expected output , formula want use it.

---

surya bose

you want @ database design , etl stages, not in cube.

you need column in line item contain percent @ each line item, , make sure add 100. etl use percent distribute value order header line item column line item amount.

then, cube aggregate line item, nto grain. grain @ order header not work.

---

thomas leblanc twitter ( @thesmilingdba )

SQL Server  >  SQL Server Analysis Services