I know that there is automatic grouping in AS. However, is there any "manual grouping" (i.e. do grouping according to my need)? I really want this function for my analysis. Thanks

Vinci

Sure. Add your own level and populate it via some calculated value.
A common technique is to create a calculated field in TSQL and load the
dimension via a view which adds the calculated field (or a simple CASE
statement).
--
Dave Wickert [MS]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Practices Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"Vinci" <anonymous (AT) discussions (DOT) microsoft.com> wrote

this function for my analysis. Thanks!