Does anyone have a view of why the following may not work?
Problem: We want additional characteristics of the Sales Order presnet in our Sales Order Cube without having to drop and reload the data.
Proposal: Store the sales order as master data and hold all the characteristics of the Sales Order as attributes. Make all the attributes line item and navigational.
Proposal explored further: Redesign the cube so that it only contains the Sales Order Number, Sales Order Item and the key figures of the Sales Order. Have all other characterics as Nav Atts from the Sales Order Item master data.
Comments would be greatly appreciated.