When i write a MDX query to get the results from ROLAP cube with proactive caching.. the cube generartes T-SQL query with errors.. SSAS introduces aliases on Columns that in the where statment are not used. Instead it uses original name from the columns and produces an error.
This is an example!
SELECT [MemberId] AS [V_H_Account_AccountMemberId1_0],[Formulario] AS [V_H_Account_AccountFormulario1_1],[ParentMemberId] AS [V_H_Account_AccountParentMemberId1_2]
FROM [dbo].[V_H_Account_Account] AS [V_H_Account_Account_1]