mdx query

Posted by Rajarbind under ASP.NET on 6/26/2008 | Views : 3599 | Status : [Member] | Replies : 1
I want to display headcount which is more than (>5) . this is the query

SELECT
Non empty{[Time].[School Year].[School Year]*{[Measures].[Headcount]>5}} ON COLUMNS
, HEAD(NonEmpty([Schools].[School Name].[School Name],Axis(0)),25) ON ROWS
from
[Enrollment] CELL PROPERTIES VALUE, FORMATTED_VALUE, FORE_COLOR, BACK_COLOR
please help me, if i will remove (>5) it is displaying report .
I am getting error.

Executing the query ...
Query (2, 46) The function expects a tuple set expression for the 1 argument. A string or numeric expression was used.
Execution complete




Responses

Posted by: Vuyiswamb on: 3/2/2009 [Member] [MVP] [Administrator] NotApplicable

Up
0
Down
You gonna have to explain Clearly what you want to Achieve.

Try to explain like this

i have a table with fields col1,col2,col3 and you want to display results based on col3 where its value is 5

then we will answer you like this


select col1,col2,col3
where col3 = 5


please try again

Thank you for posting at Dotnetfunda
[Administrator]

Rajarbind, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response