I am designing cube with document data (let's say purchase order). I want to have granularity on document item level. Each item has many reference documents (e.g. purchase requisition, purchase agreement etc.). I plan to design all of document numbers as line items. It makes that in my cube will be about 3-4 item lines.
Is this way correct or I should deal with such data in other way?