Home Dashboard Directory Help
Search

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


Status: 

Closed
 as Duplicate Help for as Duplicate


1
0
Sign in
to vote
Type: Bug
ID: 786033
Opened: 5/1/2013 1:57:23 PM
Access Restriction: Public
0
Workaround(s)
view
0
User(s) can reproduce this bug

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
Details
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
Sign in to post a workaround.