Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sravan1729
Starting Member
5 Posts |
 Posted - 2008-05-30 : 08:57:01
|
| 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!!!! |
|
|
|
|
|
Error while sending mails