SSAS 2012 generates incorrect ROLAP query to SQL with use of attributes as a filter on rows - by NICOVERNET

Status : 

  Duplicate<br /><br />
		This item appears to be a duplicate of another existing Connect or internal item.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.


1
0
Sign in
to vote
ID 786033 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 5/1/2013 1:57:23 PM
Access Restriction Public

Description

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]

		(
			
		(
			[V_H_Account_Account_1].[Formulario]			=		
						@P129
Sign in to post a comment.
Posted by Microsoft on 8/12/2013 at 8:36 AM
The fix for SQL Server 2012 will be released approximately either October 21st or November 18th.
Posted by Microsoft on 8/8/2013 at 9:03 AM
This defect will be fixed in the next cumulative update.
Posted by Microsoft on 7/31/2013 at 6:58 PM
We are already working on the fix for a similar issue for SSAS 2010. Soon a fix will be released also for SSAS 2012.
Posted by Microsoft on 7/31/2013 at 6:55 PM
Hi,

Thank you for reporting this issue. Could you please attach the AS and SQL Server databases you can reproduce the with?

Thank you,
Vitaliy