I am having a strange problem with two independant dimensions that
seem to be affecting each other when brought together in the same
cube. I have the following two dimensions

Accounts (parent child): [tb_DIM_Accounts]
AccountID
ParentID
AccountName

Category: [tb_Accounts]
AccountCode
AccountName
Category

Both join to the fact table on different keys, however if both exist
together in the same cube I get inconsistent results. If I set the
Accounts dimension to ALL, the category dimension does not report as
expected, remove the Accounts dimension from the cube and I get my
expected results on the Category dimension? Can anyone help?

Thanks Ian Hopewell