Operational Issues

The following issues pertain to the use of the SQL SELECT statement in Microsoft® SQL Server™ OLAP Services.

• You cannot use DISTINCT or GROUP BY if <select_list> contains members.
• Using the DISTINCT option with levels in <select_list> can cause the following problems:
  • If a parent level has more than one member, and not all parents are listed, OLAP Services may return duplicate rows. Be sure to explicitly include all parents.
  • If the root level for a dimension contains more than one member, OLAP Services may return duplicate rows. Include all dimensions with root levels having more than one member as columns.
• DISTINCT and GROUP BY may return multiple rows if the server contains more than one segment.