Performance Issues when Showing Multiple Attributes Using Dimensionally-modeled Relational Data Sources
If you display multiple attributes for the items
in a set on the crosstab, you can only select one attribute at a time,
so Analysis Studio executes a query for each attribute selection.
The performance of this approach is an expensive one to execute against a relational data source because of the query necessary to retrieve the attribute and its value.
You can select multiple attributes for a selected crosstab set in Analysis Studio by using the Properties pane. By selecting multiple attributes before clicking OK or Apply in the dialog box, only a single query for all selected attributes is executed, instead of one per attribute. Multiple selection in the UI is the preferred approach for enabling the display of more than one attribute for dimensionally modeled relational data source packages, because of the reduced performance impact on the relational data source.