can somebody help me please where to put filter clause
-
Thursday, February 14, 2013 6:42 PM
hi
im an mdx noob. can i ask about a statement on where to put the filter clause???
thank you a lot!
i can give you the autogenerated query from microsoft sql facility and the filter clause to insert :D- Edited by tinapai Thursday, February 14, 2013 6:54 PM
All Replies
-
Thursday, February 14, 2013 7:14 PMModerator
Hi,
You have more than one option in MDX but if you want the filter to apply to rows and columns, in a sql like behaviour, you should put it in the Where-clause. There are also options like Subselects( a MDX select clause in the FROM part instead of a cube), Filter() and Having( a clause).
BR
Thomas ivarsson
- Edited by Thomas IvarssonModerator Thursday, February 14, 2013 7:15 PM
- Proposed As Answer by Elvis LongMicrosoft Contingent Staff, Moderator Monday, February 25, 2013 4:19 AM
- Marked As Answer by Elvis LongMicrosoft Contingent Staff, Moderator Monday, February 25, 2013 4:19 AM
.png)
