mdx query

Posted by Rajarbind under ASP.NET on 6/26/2008 | Views : 3757 | Status : [Member] | Replies : 1

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

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

Latest Posts