Monday, 28 May 2012

Error (Data mining): Either the user, ....\Administrator, does not have permission to access the referenced mining model, Adventure Works DW2008R2, or the object does not exist.

Hi All.
I got the above error message while I was trying to run basic MDX query. All I had to do was add axes group to the group i,e on 0 and on 1 as shown below


Select [Measures].[Sales Amount] on 0, [Dim Product].[English Product Name] on 1 from
[Adventure Works DW2008R2]

And viola..ur error is resolved :)

No comments:

Post a Comment