Hi Danie, possible causes if the relational query is different from the cube are:

1. Named Query in the Data Source View

2. Measure properties such as AggregateFunction and MeasureExpression

3. Dimension perperties such as IsAggregatable, CustomRollup, RootMemberIf

Regards,

Vincent