Error while sending mails

• sravan1729

  SSC Enthusiast

  Points: 138

  More actions

  May 30, 2008 at 6:59 am

  #121869

  Sir,

  I tried to retrieve Email ids from Cubes(developed using SQL server analysis) by executing the following MDX query....

  " SELECT { [Project Dim].[Project Manager Email]} ON COLUMNS,{[Project Dim].[Project Code].&[p01]} On ROWS FROM [Splice-m] WHERE ( KPIStatus("KPI"))"

  But i got the following error in doing so..

  " The query must have atleast one axis.The first axis of the query should not have multiple hierarchies,nor should it refernce any dimension other than measures dimension"

  Looking forward to an early reply to solve this ....

  Thanks in advance!!!!

• stevefromOZ

  SSC-Forever

  Points: 43646

  More actions

  May 30, 2008 at 9:05 am

  #822394

  Have you tried adding a .MEMBERS to the end of the column set specification?

  so like { [Project Dim].[Project Manager Email].MEMBERS} ON COLUMNS

  Steve.