Table Visual

In SSAS:

1. The table visual will display every member by default. Dimensional filters applied in the same dimension appears to apply, but other filters do not. For example, displaying StandardMonth Year with a Color filter of "NA" will not change anything.
2. When other hierarchies are added to the visual, then only combinations that have data in any of the measure groups are displayed. For example, StandardMonth.Year and Color will only display years between 2005 to 2008, with only colors that have data for those years.
3. Measure filters are applied. Adding ISA > 1 will only display years 2005 to 2008.

In AtScale, when query.factless.ignoreIncidentalFilter=true (ignoreIncidentalFilter for short, see About Factless Queries):

1. All members are displayed regardless of dimensional filtering.
2. Steps 2 and 3 for SSAS work the same way in AtScale.

In AtScale, when ignoreIncidentalFilter=false:

1. Dimensional filters always apply if they are related (when they connect to the same fact tables). For example, displaying StandardMonth Year with a Color filter of "NA" will change the list of Years from 2000 to 2025 to 2006 to 2008.
2. Steps 2 and 3 for SSAS work the same way in AtScale.

Matrix (and related) Visuals

In SSAS:

1. When only rows or only columns are used, the Table visual behavior is applied.

2. When rows and columns are used, then the same behavior as a Table with multiple hierarchies selected is applied.

   For example, StandardMonth.Year on columns and Color on rows will limit the Year and Color members to only those that have data in the same fact table. Only the years 2005 to 2008 are displayed, and Grey is omitted from Color because no data for it exists.

   

3. Measure filters always apply.

In AtScale:

1. When only rows or only columns are used, the Table visual behavior is applied (for both ignoreIncidentalFilter settings).

2. When rows and columns are used, the rows are limited to ones that have data relative to the columns, just as they are in SSAS. However, every column member is displayed.

   For example, if Color is on rows and StandardMonth.Year on columns, then the years 2000 to 2025 are displayed, but Grey is not shown on the rows.

   

3. Steps 2 and 3 for SSAS work the same way in AtScale.