In a dimension table you have an id with a corresponding name. For Microstrategy Desktop, all of the attributes/metrics are linked by the ID. I would like to have the Select statement choose the id to do all calculations, but I want them to be Grouped by the name.
Is there a way to group by name vs id or perhaps have both name and id in the select statement?
thanks in advance,
annie123
Is there a way to group by name vs id or perhaps have both name and id in the select statement?
thanks in advance,
annie123