Error running MDX query

• pshvets

  SSCommitted

  Points: 1850

  More actions

  June 30, 2009 at 6:03 pm

  #206535

  Hello,

  I have a cube in my local SSAS instance which I can query through Excel.

  I am getting security error when I attempt to run an MDX query against it.

  My query is very simple one:

  select

  [Measures].[TargetAttainment]

  from [HoursCube]

  Here is the error I am getting:

  Executing the query ...

  Error (Data mining): Either the user, \johns, does not have permission to access the referenced mining model, HoursCube, or the object does not exist.

  Error (Data mining): Either the user, \johns, does not have permission to access the referenced mining model, HoursCube, or the object does not exist.

  Execution complete

  Could anyone suggest how to resolve the issue, please.

  Thanks,

  Peter.

• Nimesh Shah-223269

  SSC-Addicted

  Points: 405

  More actions

  September 7, 2009 at 5:19 am

  #1050048

  Can you try running the following MDX

  select

  [Measures].[TargetAttainment] on 0

  from [HoursCube]

• will78

  Valued Member

  Points: 54

  More actions

  June 6, 2012 at 10:34 am

  #1497749

  I'm not sure if you ever heard back from the asker but this worked for me.

  Thank you!

• Raunak Jhawar

  SSCoach

  Points: 15701

  More actions

  June 8, 2012 at 4:39 am

  #1498628

  The correct syntax is:

  Select {Measures} ON COLUMNS,

  {Dimensions} ON ROWS

  FROM <<cube_name>>

  WHERE

  (any_slicers)

  Raunak J