• Hi,

    That's fine if you are writing all the MDX yourself but not ideal if you are using an ad-hoc query tool (like pivot tables in Excel or ProClarity or XLCubed etc)

    You might find it easier to push the data down to the lowest level of your hierarchy

    For example my company budgets at sales team but the lowest level is salesperson. I then push the budget down to and aribitary salesperson in that team and apply the budget to them (or you could split the budget evenly).

    I appreciate that this is not a true representation of the data but it allows correct rollups & ad-hoc query tools will work correctly

    Mack