DataSet Query with filter [Measures].[Revenue] > 0
Hello, I want to add the filter [Measures].[Revenue] > 0 to my DataSet Query. How can this be done in Design Mode? I cannot drag&drop a measue to the Query Designer's filter area. Thanks
November 17th, 2011 9:47am

Is the source for your dataset is a cube? Please let me know.Phani Note: Please vote/mark the post as answered if it answers your question/helps to solve your problem.
Free Windows Admin Tool Kit Click here and download it now
November 17th, 2011 12:01pm

Yes, it is a cube. I need to parameterize the MDX query by measure Revenue > 0 When I add this to the WHERE clause of the MDX query: WHERE ( ... , [Measures].[Value Euro BR2008]>0) I get this error: The function expects a tuple set expression for the 6 argument. A string or numeric expression was used. Microsoft SQL Server 2008 R2 Analysis Services)
November 18th, 2011 3:16am

hi ax123, You have to move out of Design Mode to query Mode Specify your query here with the filter you want to achieve. Please, let me know if you want further info. Regards, Manoj *Happy to help http://experiencingmsbi.blogspot.com/
Free Windows Admin Tool Kit Click here and download it now
November 18th, 2011 4:22am

hi ax123, You have to move out of Design Mode to query Mode Specify your query here with the filter you want to achieve. Please, let me know if you want further info. Regards, Manoj *Happy to help http://experiencingmsbi.blogspot.com/
November 18th, 2011 12:18pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics