SUBCUBE vs. Slice for YTD()
When cube is built and developer wants to browse it quickly, often the first choice is SSMS or BIDS Browse view. By right clicking on the cube in SSMS Object Explorer and selecting the “Browse” option, a Browse view opens with Cube Metadata viewer, OWC and additional Filter pane, which altogether make cube navigation experience fast and simple as it can be. The Filter pane gives you ability to navigate the cube based on conditional operator (=, in, no in, etc) as well as with MDX expression and range selection. This is very flexible way of defining your filter conditions and definitely adds up value in overall user experience comparing it against OWC Filter selector which in turn allows only specific member selections. But what about MDX which is generated by both filters and sent over to the server? Is it the same when we use different filters for the same constrain?
Read more...Tags: mdx