Drill From Summary is returning rows from Data Workbench that were loaded to a different cube
SummaryDrill From Summary is returning rows from Data Workbench that were loaded to a different cube
When using drill from summary in IGNORE mode, if you drill on a dimension member with > 1000 descendants, it is ignored in the drill (which is fine) but the drill-through returns all matching rows for different cubes as well.
e.g. we have data loaded against an account 511000 in the Group model, and lower level data against the same account and the Project in our Margin model.
When we drill on the Total Project number, the drill-through only matches on the account, and returns the rows from both Group and Margin loads. This is obviously wrong.